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

SQLAuthority News – Blog Stats Revealed

November 19, 2010

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

I often receive praises, questions, suggestions and skeptical emails regarding my blog stats. Let me put everything aside and open up my stats page for all. I use wordpress.com and stats are maintained by them. Every month, I will put the blog stats on the following page for every one’s…

SQLAuthority News – SQL Server Performance Series Hyderabad / Pune – Nov/Dec 2010

November 18, 2010

Pinal Dave

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

SQL Scripts

Just a quick note that SQL Server Performance Tuning and Optimizations Seminar series which I am offering at Hyderabad and Pune are almost all sold out. Read the details of the earlier successful seminar conducted at Colombo, Sri Lanka over here. Hyderabad Nov 27-28, 2010 (Last 3 Seats Left) Best…

SQL SERVER – History of SQL Server Database Encryption

November 17, 2010

Pinal Dave

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

SQL PASS, SQL Server Encryption, SQLAuthority Book Review

I recently met Michael Coles and Rodeney Landrum the author of one of the kind book Expert SQL Server 2008 Encryption at SQLPASS in Seattle. During the conversation we ended up how Microsoft is evolving encryption technology. The same discussion lead to talking about history of encryption tools in SQL…

SQLAuthority News – Download Whitepaper – Understanding and Controlling Parallel Query Processing in SQL Server

November 16, 2010

Pinal Dave

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

SQL White Papers

My recently article SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database has received many good comments regarding MAXDOP 1 and MAXDOP 0. I really enjoyed reading the comments as the comments are received from industry leaders and gurus. I was further researching on the subject and I end…

SQL SERVER – Information Related to DATETIME and DATETIME2

November 15, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I recently received interesting comment on the blog regarding workaround to overcome the precision issue while dealing with DATETIME and DATETIME2. I have written over this subject earlier over here. SQL SERVER – Difference Between GETDATE and SYSDATETIME SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE SQL…

SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database

November 13, 2010

Pinal Dave

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

SQL Scripts, SQL White Papers

While engaging in a performance tuning consultation for a client, a situation occurred where they were facing a lot of CXPACKET Waits Stats. The client asked me if I could help them reduce this huge number of wait stats. I usually receive this kind of request from other client as…

SQL SERVER – Get All the Information of Database using sys.databases

November 12, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Earlier I wrote blog article SQL SERVER – Finding Last Backup Time for All Database. In the response of this article I have received very interesting script from SQL Server Expert Matteo as a comment in the blog. He has written script using sys.databases which provides plenty of the information…