Three ways to send query results to text, grid or file in SSMS: the shortcuts CTRL+T, CTRL+D and CTRL+SHIFT+F, the toolbar, or the menu bar.
SQL SERVER – SPACE Function Example
Does SQL Server have a SPACE function? Yes. SELECT SPACE(100) returns 100 spaces, and a short example uses it to join last and first names.
SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup
Everything about restore and backup readers ask: can you restore without a backup? No. Here is the right restore order and a plan to stay safe.
SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
Stop building ORDER BY strings and running them with EXEC in a stored procedure. I show how a CASE statement in ORDER BY sorts by a variable without dynamic SQL.
SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability
My summary of two Microsoft white papers: the top 10 best practices for Analysis Services query performance, and Partial Database Availability with filegroups.
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – 15 Signs to Identify Bad DBA
A bit of SQL humor: 15 signs of a bad DBA, from reinstalling SQL Server when the sa password is lost to indexing every field to make it faster.
SQL SERVER – 2005 Collation Explanation and Translation – Part 2
Collation Explanation and Translation, part 2: one query on sys.fn_helpcollations() lists all 1011 collations in SQL Server 2005 with a description of each.