Let’s say you’re facing parameter sniffing issues for a particular stored procedure. ...
Configure Database Autogrowth
Today, I want to discuss autogrowth in SQL Server. When creating a new database, SQL Server sets...
Reasons to Run DBCC UPDATEUSAGE
One e-mail alert that we all dread receiving is an alert stating that DBCC CHECKDB found issues...
How Fill Factor Can Affect Performance
Fill factor determines the percentage of space to leave open for new data added in an index...
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...
SQL Backup to Multiple Files
I recently had a project that required uploading a large database to an FTP server. Sounds simple...
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...
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...
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...
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...
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...
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...
C# Comments
C# comments (or comments in any programming language, for that matter) are pieces of text that you...
PHP echo variable with HTML tags
How to use HTML tags in PHP echo? Example 1: This example demonstrates that how HTML tags and...
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...