SQL Server Archives - Page 117 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Weekly Series – Memory Lane – #019

March 9, 2013

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – Tricky Question – What is the Default Size of the Database

March 8, 2013

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

I love tricky questions – they are fun and educating. Yesterday I was presenting in one of the largest organization in India on SQL Server Performance Tuning Subject. During the conversation, one of the user suggested that every single time they are creating new database it is created with the…

SQL SERVER – Watch Four Efficiency Tricks in SQL Server In Sixty Seconds – Subscribe for SQL Learning Videos

March 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL in Sixty Seconds

SQL in Sixty Seconds has been my favorite thing to do every Wednesday. It is indeed truly said that “A picture is worth a thousand words” – it is equally true that “A video is worth a thousand pictures”. Though recording the video is easy the difficult part is to…

SQL SERVER – Exporting Query Results to CSV using SQLCMD

March 5, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

sqlcmd

Social media is evolving at a rapid pace and every day I keep on getting question from different methods. Here is the latest question which I received on my Facebook page. The question was how to export the data of query into CSV using SQLCMD. This is indeed very easy…

SQL SERVER – Weekly Series – Memory Lane – #018

March 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane, SQL Scripts

SQL SERVER – Beginning SQL 2012 – Basics of CONVERT and FORMAT Function – Abstract from Joes 2 Pros Volume 5

March 1, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros, SQL Scripts

This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 5. You can get the Five part SQL Server 2012 Joes 2 Pros Combo Kit for complete reference. Book On Amazon | Book On Flipkart OPENXML has been around longer than the XML data type in SQL Server.…

SQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2

February 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 2. You can get the Five part SQL Server 2012 Joes 2 Pros Combo Kit for complete reference. Book On Amazon | Book On Flipkart All supporting files are available with a free download from the…