:: Home
User: Guest  Login :: Home
... home of the code blues!

Found entries:

How To: Resolving unexpected behavior and errors using SQL Server views

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...

Posted: 10/14/2007 9:34:00 AM by mdenkmaier | 0
Filed under: SQLHow to
How to: Display current database and object size

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...

Posted: 10/8/2007 6:58:00 AM by mdenkmaier | 0
Filed under: SQLHow to
How to: Hunting SQL Server Deadlocks and logging them to file

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...

Posted: 8/10/2007 8:49:00 AM by mdenkmaier | 0
Filed under: SQLHow to
News: SQL Server 2008 CTP Released

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...

Posted: 6/5/2007 7:31:29 AM by mdenkmaier | 0
Filed under: SQLNews
How to: Ensure correct german characters in SQL scripts using sqlcmd.exe

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...

Posted: 5/11/2007 9:29:00 AM by mdenkmaier | 0
Filed under: SQLHow toDevelopment
How to: Switch SQL Server 2005 to single user mode

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...

Posted: 4/23/2007 5:17:41 PM by mdenkmaier | 0
Filed under: SQLHow to
How to enable Snapshot Isolation on SQL Server 2005

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...

Posted: 3/23/2007 7:32:54 AM by mdenkmaier | 0
Filed under: SQLHow to
Error 1939 when trying to create an index on View in SQL Server 2005

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...

Posted: 3/12/2007 11:01:14 PM by mdenkmaier | 0
Filed under: SQLDevelopment
SQL Server 2005 management views

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...

Posted: 3/3/2007 1:22:55 PM by mdenkmaier | 0
Filed under: SQLDevelopment
How to get current SQL connections

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...

Posted: 2/4/2007 1:04:51 PM by mdenkmaier | 0
Filed under: SQLDevelopment