Sometimes you have to create views which are based on other views or tables. But there are some limitations and pitfalls when it comes to making changes in the structure of the underlying tables/v...

I am often asked how to determine the current database size from SQL code. SQL Server gives you the system stored procedure sp_spaceusedwhich does exactly this. To retrieve the current size o...

The following describes the possible ways and the steps needed the get more details about SQL Server dead locks. The engine saves the information by default to the SQL Server error logs. 1. Use...

On Monday, 04 June 2007, Microsoft released the first community technology preview (CTP)of SQL Server 2008, the official name for what was initially codenamed "Katmai." The announcement was made a...

The command line tool sqlcmd.exe is well known in the world of a Microsoft (SQL Server) developer.Normally you will execute SQL scripts using the following syntax: sqlcmd.exe -E -S <your_server...

Here is a short tutorial on switching a SQL Server 2005 instance to single user mode: 1. Stop the service: Using a command prompt type: net stop MSSQL$<your_instanceName> 2. Start t...

SQL Server 2005 introduces a new snapshot isolation level to enhance concurrency for OLTP applications. In earlier days concurrency was based on frequent locks of rows, pages and tables. snapshot i...

When you try to create an index on a column belonging to a view you receive the following error: Error: sql server error 1939: The Index cannot be created because the view is not bound to a sche...

With SQL Server 2005 Microsoft introduced a new set of so called Dynamic Management Views (DMV). The following views could be a good starter when searching for specific information in or around yo...

A frequently asked question is how to get currently opened and used connections on a SQL Server. The easiest way is to use one of the SQL Server managed views to select all open connections: sele...