One of the applications we worked on recently had to deal with storing TSQL queries in a table and executing them based on some business logic. It was not a very complicated project, but the development team had a tough time with the formatting of the queries stored in the table. This was a huge pro......

I saw this question on the forum today and after writing an example that demonstrates this, I thought of including it as part of the XQuery Labs. Here is the sample XML we need to process. The task is to delete all notes elements that a......

I have always experienced and am convinced that, while learning a programming technique, it is more helpful to see an example that matches our specific requirement, rather than some theoretical stuff. Examples are really good for learning the basics and then the theories will help us to go deeper in......

GUID or int as Primary key ???Though it is not necessary that your Primary Key column is always a cluster index too. By default, Sql Server creates cluster index on column or group of columns which you have declared as your table PK, and most of DBAs don'...

What permissions does one need to capture SQL traces using SQL Server Profiler? Is it essential that the user must be a member of the sysadmin fixed server role? This post shows the minimal permissions required for a user to capture SQL traces using the SQL Server Profiler and demonstrates the necessary command to assign a login these permissions....

Often, you are advised not to use * in your SELECT statement. It is because the code that depends on * may be  broken if a column is added or removed. If you have a view that uses *, it will not reflect newly added/removed column until the view is ...

How do you script your database objects using T-SQL? I explore 3 different methods that I know about in this post....

I have posted a blog post about Different ways to remove TIME part from DATETIME values where I have shown six different ways to remove TIME part. Some of the regular users posted some alternate methods. Here is the analysis of how long each method take...

Well. You can express numbers in scientific form. ExampleSELECT 2E returns 2 SELECT 3E returns 3 Now what does the following select statement return?SELECT 2E-3ETRY to answer this question without running it....

Today is Sunday and I was not expecting this as today is holiday although I know it was Microsoft Mvp renewal day. At evening I got the congratulation email from the Microsoft. Yeah!! I am Microsoft Most Valuable Professional again. I got the same messa...