Category Archives: Uncategorized

SQL Server Installation Checklist

This is my version of SQL Server installation check-list. Pre-SQL Installation   Service Account Procure all AD Service accounts. Preferably one for each SQL Server service. Register an SPN. DBAs often do not have permission to do this. Have this done … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

List of new changes in SQL2014 SP1

Microsoft has release SQL Server 2014 Service Pack 1 on April 15 and recalled very shortly after going live on the Microsoft Download Center (only) to address a recall issue.  After resolving that issue the new release is now available –KB3058865. Here … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Nostalgia 01 (Fastest way to copy a database)

I can still remember, when I was a beginner, I used to take backup of my databases in most unconventional way, probably the fastest way to copy an image of a database. This is a big confession; still I like … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Types of Table Expressions in TSQL

Table expressions are named queries. We write an inner query that returns a relational result set, name it, and query it from an outer query. T-SQL supports four forms of table expressions Derived Tables Common Table Expressions (CTEs) Views Inline … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Optional parameters in a T-SQL stored procedure

Sometimes it’s really important to use optional parameter in Stored Procedure. For a beginner, it’s definitely a helpful if he/she practices optional parameters in Stored Procedure. For illustration the scenario here is an example. USE TSQL2012 CREATE PROCEDURE GET_EMP_SP ( … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Difference Between Stored Procedures and User Define Functions

SPs and UDFs are two most important database objects used every day by thousands of developers round the world. More than that SQL Server itself uses these two database objects very frequently. There are some fundamental differences between these two. … Continue reading

Posted in Uncategorized | Tagged | Leave a comment