SQLAuthority passed 3 Million readers. Thank you for your active participation. Here are my best and favorite articles if you want to keep reading.
SQL SERVER – UNPIVOT Table Example
UNPIVOT Table is the reverse of PIVOT. This AdventureWorks example turns state columns back into rows, and shows why the detail rows do not return.
SQLAuthority News – Download – Windows Server 2008 w/ SQL Server 2005
Microsoft offers Windows Server 2008 with SQL Server 2005 as a pre-configured VHD download, so you can test web designs without installing every server yourself.
SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 3
Nanda Kumar improved the UDF to get the day of the week: it now uses the date you pass in instead of GETDATE() and handles Saturday correctly.
SQLAuthority News – SQL SERVER 2008 – New Logo
Microsoft SQL Server 2008 has a new logo, and I really liked the new design. Here is a quick look at the SQL Server 2008 logo.
SQL SERVER – T-SQL Script to Devide One Column into Two Column
A quick script to split one column into two with LEFT, RIGHT and CHARINDEX, plus what to check when a value has no comma or has extra spaces.
SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description
Looking for a job or a candidate? Here are my links to SQL Server interview questions and answers, SQL Server related jobs and a DBA job description.
SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2
Mihir Popat improved my Day of the Week Function with @@DATEFIRST, so Sunday does not have to be the first day of the week. Here is his UDF.
SQL SERVER – PIVOT Table Example
A PIVOT Table example on AdventureWorks that counts addresses by state, plus why UNPIVOT cannot always give you back the original rows.
SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance
Twelve tips for better SQL Server 2005 query performance, from execution plans and covering indexes to avoiding cursors, using APPLY and archiving old data.