SQL 2000,SQL 2005 - Andrew Calvett
Andrew Calvett
Browse by Tags
All Tags
»
SQL 2000
»
SQL 2005
(
RSS
)
2008
Database Engine
Performance
System Procedures
Tips
Tools
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...
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...
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...
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...
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...
Go
This Blog
Home
Contact
Links
Tags
2008
2008 R2
64 Bit
Analysis Services
Backup
Blocking
Blogs
Cancelled
CPU
Database Engine
Deadlock
Default Database
DMV
Documentation
FileSystemCache
Hanging
Just for fun
Locking
Maintenance Plans
MDX
Operation
Operations Guide
Parallelism
Performance
Processing
Profiling
Ramblings
Reports
Security
SQL
SQL 2000
SQL 2005
SQL 2008
SQL Agent
SSAS
SSAS 2005
SSAS 2008
SSAS 2008 R2
SSMS
Stability
Synchronisation
Synchronization
System Procedures
Tips
Tools
Trouble Shooting
W2K3
Windows 2003
Navigation
Home
Blogs
Photos
Downloads
Archives
February 2012 (1)
January 2012 (1)
September 2011 (2)
June 2011 (1)
May 2011 (2)
April 2011 (1)
March 2011 (1)
December 2010 (1)
November 2010 (2)
July 2010 (1)
April 2010 (1)
January 2010 (1)
November 2009 (1)
September 2009 (1)
August 2009 (1)
April 2009 (1)
January 2009 (1)
October 2008 (1)
August 2008 (1)
May 2008 (1)
April 2008 (1)
February 2008 (1)
January 2008 (1)
December 2007 (1)
October 2007 (1)
September 2007 (1)
July 2007 (3)
June 2007 (2)
June 2006 (1)
April 2006 (1)
March 2006 (2)
February 2006 (1)
January 2006 (3)
Syndication
RSS
Atom
Comments RSS