Over the last couple of weeks I have taken a couple of the common queries that I use to analyze the health of a SQL Server and built them out into a SQL Server 2008 SSRS report. I have decided to make this report available to anyone who want to run it. The SQL Server Health report is available to …
Default Values and Computed Columns In SQL Server 2008, I was presented with the following error when attempting to create a table that has a default value that references other columns in the same table. Msg 128, Level 15, State 1, Line 6 The name “Subtotal” is not permitted in this context. Valid expressions are constants, constant expressions, and (in …
MSG 128, Level 15, State 1 – not permitted in this context Read more »
There was no change to the compatibility levels between SQL Server 2008 and SQL Server 2008 R2. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 …
This week I have been at the SQL Connections conference in Las Vegas. With 7 to 9 hours of classes and presentations every day, all on Microsoft SQL Server. The classes included the Next Generation of SQL Server, Distributed Applications with Service Broker, Building High Availability Using Microsoft SQL Server 2008, Virtualization, Installation and Migration Strategies, Logging and Recovery, Minimally …
Home after a week at SQL DevConnections 2009 in Las Vegas Read more »
The quick and easy way to determine how much memory your SQL Server is using is to look at the Task Manager on the server and find “sqlservr.exe” in the process list, and look at the “Mem Usage” column. But what if you are not on the server, or if you want to grab this information programmatically from an application, …
I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning on Oracle. The following is something that I have discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to …
How much Procedure Cache memory does one SQL Statement take up? Read more »
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 100 = SQL …
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 = SQL Server 7.0 80 = SQL Server 2000 90 = SQL Server 2005 Here is a …