I doubt that I’m alone in the experience of beginning to troubleshooting a slow query, executing...
Category - SQL Server
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...
Generate New Guid (uniqueidentifier) in SQL Server
Welcome to our in-depth guide on generating random unique identifiers in SQL Server using SQL...
Using a Cursor in SQL
Everything is in the title, this tutorial uses for example the insertion of data into a table...
How to return records in random order in Stored Procedure
Here is simple example to return records in Random Order. Example if you have rank...
How to search using a stored procedure
To search using a stored procedure, you will need to have a stored procedure in your database that...