A short video that shows the performance improvement in columnstore index queries on a big table, for readers who cannot run the demo themselves.
SQLAuthority News – Uncut and Unedited – Interview of Pinal Dave on Book Authoring
I was very happy when books were published and I got a print copy in my hand. In this blog post we will discuss about Book Authoring.
SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds
A 200 second, step by step installation video for Denali CTP3. There is no audio, since every screen of the install is easy to follow.
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
Connecting with Windows Authentication by SQLCMD needs the -E switch, not a username and password. Here is my fun chat with my old friend DJ about it.
SQL SERVER – Delete Duplicate Rows
Delete Duplicate Rows quickly with a CTE and ROW_NUMBER() in SQL Server 2005 and 2008. A sample table with 7 rows, 3 of them duplicates, shows how it works.
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
Turn on SQLCMD Mode and the SSMS Query Editor can run sqlcmd scripts that mix OS and SQL commands. The interesting part: the OS commands run first.
SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
Restore Database backups with a T-SQL script: read the logical file names with RESTORE FILELISTONLY, set single user mode, then run RESTORE WITH MOVE.