Three tested ways to install the NorthWind and Pubs sample databases on SQL Server 2005, starting from SQL2000SampleDb.msi, with screenshots for each.
SQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
Error 8629 appears when one UPDATE changes a text or image column and a clustering key together. Here is why SQL Server blocks it and a fix.
How to Read a SQL Server Error Message
Read a SQL Server error message by separating its number, severity, state, procedure, and line, then preserve the context needed to investigate.
SQL SERVER – Cannot Resolve Collation Conflict For Equal to Operation
Cannot resolve collation conflict for equal to operation. In MS SQL SERVER, the collation can be set at the column level.
SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table
Paging in SQL Server 2005 with ROW_NUMBER: CTE vs. derived table. I compare both methods and show they give the same performance for common queries.
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice
The best way to select only the date part from a DATETIME value: my team member’s DATEADD and DATEDIFF method, and the CONVERT style 111 method I prefer.
SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)
Msg 9514 means a distributed query touched an XML column. Why the type cannot cross a linked server, and four ways to get the data across anyway.