SQL SERVER - sqlcmd vs osql - Basic Comparison
Today we will go over very simple but to the point comparison of two SQL Server utilities or SQL Server tools. This comes often to users which one to use sqlcmd or osql, when in need of running SQL Server ...
SQL SERVER - 2008 - Change Color of Status Bar of SSMS Query Editor
This is one very interesting issue which I have started to follow recently. Just like any other organization my company has many servers. Some are production and some are development. It is very much ...
SQL SERVER - Time Delay While Running T-SQL Query - WAITFOR Introduction
Today we will look at one very small but interesting feature of SQL Server. Please note that this is not much known feature of SQL Server. In SQL Server sometime there are requirement when T-SQL script ...
SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL
Recently my company owner asked me to find which query is running longest. It was very interesting that I was not able to find any T-SQL script online which can give me this data directly. Finally, I ...
SQLAuthority News - Happy New Year - 5 SQL New Year Resolutions
Happy New Year to All of YOU! Let us start year 2009 with word of wisdom from Albert Einstein. I feel that you are justified in looking into the future with true assurance, because you have a mode of ...