Fill factor determines the percentage of space to leave open for new data added in an index. Changing the fill factor value from the default of 0 (no space left open) can help in rare cases with performance problems. In...
Set Statistics Time/IO For Each New Query Window
I doubt that I’m alone in the experience of beginning to troubleshooting a slow query, executing, and clicking over to the messages tab to get some juicy information only to find… Nothing too helpful. Far too often I...
SQL Backup to Multiple Files
I recently had a project that required uploading a large database to an FTP server. Sounds simple enough except that each folder on the FTP server had a size limit on file uploads. Uploading one database backup that...
Different Ways to script out stored procedures in SQL Server
Creating a new procedure is like visiting a new place ,while knowing how to script them is like reliving those memories. What is Stored procedure ? A Stored procedure is something like a set of code that contains many...
Truncate vs Delete in SQL Server
There is always a new beginning when we get rid of the obsolete /unused /wrong data . True to the saying ‘To err is human’ , we always come across some data correction in our tables .Its always quite frustrating to see...
Methods to find Table Structure in SQL
Most of the times while working with SQL server ,we are definitely dealing with lots of tables and it is quite straight forward that the data in SQL server are stored in the form of tables .Then it is pretty necessary...
Fun with Commenting codes in SQL Server
If a working code is interesting then a code that doesn’t work is much fascinating . I have got one question . Where does commenting using – – or /* */ doesn’t work in SQL server? It is pretty good question to think ...
ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe)
The ASP.NET SQL Server registration tool (Aspnet_regsql.exe) is used to create a Microsoft SQL Server database that is used by the SQL Server providers in ASP.NET. The tool is also used to add or remove options from an...
Save Image as Byte Array SQL Server using C#
Insert Image into SQL Server using C# OpenFileDialog for browse the Image and showing in picture box and Convert image into Byte using MemoryStream in GetImage method. GetImage method has a return value as btye array...
C# Comments
C# comments (or comments in any programming language, for that matter) are pieces of text that you add to a program in order to communicate something to a human reader. That’s pretty much it. The compiler ignores...
PHP echo variable with HTML tags
How to use HTML tags in PHP echo? Example 1: This example demonstrates that how HTML tags and variable can be used in PHP echo to display the result. <!DOCTYPE html> <html> <body> <?php $name =...
How to merge two or more arrays into one array in PHP
You can use the PHP array_merge() function to merge the elements or values of two or more arrays together into a single array. The merging is occurring in such a way that the values of one array are appended to the end...