Browse by Tags

Server Side Aliases
07 November 2010 21:37

Over the years i have come across a few situations where server side connections to SQL server fail when you use a DNS alias that points back to the server your initiating the connection from but you can connect remotely. Its an annoying problem which has a very unhelpful error message that changed in different versions of SQL. In SQL 2000 you are presented with... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, SQL 2000, Tips, Database Engine, 2008

The evils of implicit conversions
18 January 2009 17:18

I wanted to put up a brief post showing the impact of an implicit conversion on the performance of a query (or not......). In the example i will show an implicit conversion negatively impacting query performance and an implicit conversion that does not impact performance..... So, we need to setup the test environment using the code below. SET ANSI_WARNINGS OFF... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, SQL 2000, Tips, Performance

The overhead of a non-unique clustered index
20 October 2008 00:21

So, we all know that if we create a clustered index that is not unique that we will incur a 4 byte overhead right? Well not always because as usual, it depends..... When you create a non-unique clustered index SQL server must maintain uniqueness so it adds a hidden 4 byte column which is populated for each non-unique row (not every row) but what many people may... Read More...

by ACALVETT | 9 comment(s)

Filed under: SQL 2005, SQL 2000, Tips, Database Engine

My old mate sp_recompile
12 October 2007 11:33

As soon as i saw the error messages in the logs i thought to myself "Oh my, that did not happen in testing" (ok, maybe it was more colourful than that). We were creating a clustered index on a tiny little table and the index went through fine. However, the application started to generate the message " Could not complete cursor operation because the table schema... Read More...

by ACALVETT | 2 comment(s)

Filed under: SQL 2005, SQL 2000, Tips, System Procedures

The joy of template parameters
15 July 2007 20:23

I thought I would do a quick blog about template parameters since I have been writing allot of standard deployment scripts for our 2005 builds and have used them extensively. So what are they? Well they are place holders and you would you use them in the same places that you would probably put a variable. The key difference comes when you assign the values. With... Read More...

by ACALVETT | 1 comment(s)

Filed under: SQL 2005, SQL 2000, Tools