A collation conflict means character expressions use incompatible comparison rules. I choose the intended rules before applying COLLATE.
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
Selecting the date part and formatting it are different tasks. I keep typed dates for calculations and text for display.
SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.
An error has occurred while establishing a connection to the server, also known as Error 40, is the top error searched on my blog. Here is the fix in screenshots.
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.
SQL SERVER – Spatial Database Definition and Research Documents
What is a spatial database? It is about lines, points, polygons and their features, and SQL Server was not one. My simple answer plus research documents.
SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
A script and UDF that show each current week date with its day, from Sunday to Saturday, using DATEPART and DATEADD. Handy for a weekly calendar report.