SQL Scripts « SQL Server Journey with SQL Authority

Archive for the ‘SQL Scripts’ Category

SQL SERVER – Convert Subquery to CTE – SQL in Sixty Seconds #001 – Video

Posted in Database, Pinal Dave, PostADay, SQL, SQL Authority, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Video on February 8, 2012 | 9 Comments »

SQL Server is an ocean of information. I believe if one starts learning today, after 60 years he/she may still be learning the subject (there are always a few exceptions)! Recently, I published the SQL Server Questions and Answers video tutorial, and since the course came out, I have been receiving lots of request to [...]

Read Full Post »

SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors

Posted in PostADay, SQL, SQL Authority, SQL DMV, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 4, 2012 | 1 Comment »

I recently received email from one of my very close friend from California. His question was very interesting. He wanted to know how many virtual processors are there available for SQL Server. He already had script for SQL Server 2008 but was mainly looking for SQL Server 2000. He made me go to my past. [...]

Read Full Post »

SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column

Posted in Pinal Dave, PostADay, Readers Contribution, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 24, 2011 | 26 Comments »

Christmas is just near and happy holidays to all of you. Today is Christmas eve and I decided to share something very simple but interesting with you. Recently some one reading my SQL Server Interview Questions and Answers book asked me following question. “Pinal, Instead of puzzle, or difficult interview question, I was asked following [...]

Read Full Post »

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on December 23, 2011 | 12 Comments »

Blogging is like writing a big novel in parts. It has its own mood and it has its own colors. Someday I feel like writing philosophy and some day I like writing theory and some day just a script. Today is one of the day when I just feel like providing working script for user [...]

Read Full Post »

SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on December 13, 2011 | 2 Comments »

This blog post is written in response to the T-SQL Tuesday post of Tips and Tricks. For me, this is a very interesting subject. I perfectly enjoy a discussion when it is about performance tuning. I commonly get follow-up questions regarding this subject, but most of them do not give the complete information about their [...]

Read Full Post »

Older Posts »