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

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

March 8, 2011

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

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…

SQL SERVER – Enable PowerPivot Plugin in Excel

March 7, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

PowerPivot

Recently I had interesting experience at one conference. My PowerPivot plugin got disabled and I had no clue how to enable the same. After while, I figured out how to enable the same. Once I got back from the event, I searched online and realize that many other people online…

SQL SERVER – Running Multiple Batch Files Together in Parallel

March 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

Recently I was preparing a demo for my next technical session, I had to do run a SQL code in parallel. I decided to use Batch File to run the code. I am not the best guy to with command shell so I did it with following setup. Code of…

SQL SERVER – Concurrency Problems and their Relationship with Isolation Level

March 4, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Concurrency is simply put capability of the machine to support two or more transactions working with the same data at the same time. This usually comes up with data is being modified, as during the retrieval of the data this is not the issue. Most of the concurrency problems can…

SQL SERVER – Demo Script – Keeping CPU Busy

March 3, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Recently face very interesting situation, during presentations at event, I was asked very famous questions: “My CPU is very high all the time, how can I reduce it?” This is very interesting question and there are many answers and a single blog post is not good enough to justify this…

SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave

March 2, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Earlier this year Lohith (@kashyapa) from Bangalore took my ‘Uncut and Unedited’ video interview. It was really fun to answer his questions as it was very different from regular interview. He asked few personal details few technical details and made me show few secrets. [youtube=http://www.youtube.com/watch?v=k3yLkPt2LIc] I think if you want…

SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart

March 1, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Michael J. Swart is a very unique person. I have often exchanged emails with him and also used a couple of his scripts in my presentations (with his permission). Every time I conduct spatial database presentation, I always start with his script where he has drawn the wonderful image of…