SQL Scripts Archives - Page 211 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Query to Recent Query on Server with Execution Plan Function to Get SQL

April 12, 2011

This blog post is written in response to the T-SQL Tuesday hosted by Matt Velic. He has picked very interesting topic which is related to APPLY clause of the T-SQL. When I read the subject, I really liked the subject. This is very new subject and it is quite a…

SQL SERVER – Denali – ObjectID in Negative – Local TempTable has Negative ObjectID

March 23, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

I used to run the following script to generate random large results. However, when I ran this on Denali I noticed a very interesting behavior: SELECT o1.OBJECT_ID,o1.name, o2.OBJECT_ID, o2.name FROM sys.all_objects o1 CROSS JOIN sys.all_objects o2 I noticed lots of negative object_ID’s on Denali, whereas my experience on SQL Server…

SQLAuthority News – Solid Quality Journal – Importance of Statistics

March 22, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Statistics

My article on “Important of Statistics” has been published in Solid Quality Journal. Statistics are a key part of getting solid performance. In this article we will go over the basics of the statistics and various best practices related to Statistics. We will go over various frequently asked questions like…

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

March 19, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

After reading my earlier article SQL SERVER – master Database Log File Grew Too Big, I received an email recently from another reader asking why does the log file of model database grow every day when he is not carrying out any operation in the model database. As per the…

SQL SERVER 2008 – 2012 – Declare and Assign Variable in Single Statement

March 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Many of us are tend to overlook simple things even if we are capable of doing complex work. In SQL Server 2008, inline variable assignment is available. This feature exists from last 3 years, but I hardly see its utilization. One of the common arguments was that as the project…

SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer

March 15, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

My friend Jacob Sebastian has SQL Server Quiz 2011 launched. This time when he asked me to come up with quiz question – I wanted to come up with something which is new and make participant to think about it. After carefully thinking I come with question which I really…

SQL SERVER – Difference between COUNT(DISTINCT) vs COUNT(ALL)

March 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Scripts

This blog post is written in response to the T-SQL Tuesday hosted by Jes Schultz Borland. Earlier today, I was presenting a 45-minute session at the Community College about “The Beginning SQL Server Database”. One of the students asked me the following question. What is the difference between COUNT(DISTINCT) vs…