SQL Tips and Tricks Archives - Page 363 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache

June 17, 2010

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

This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query. Have you ever wondered what types of data are there in your cache? During SQL Server Trainings, I am usually…

SQL SERVER – Find Largest Supported DML Operation – Question to You

June 16, 2010

Pinal Dave

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

Best Practices

SQL Server is very big and it is not possible to know everything in SQL Server but we all keep learning. Recently I was going over the best practices of transactions log and I come across following statement. The log size must be at least twice the size of largest…

SQL SERVER – Shrinking Database NDF and MDF Files

June 15, 2010

Pinal Dave

SQL Tips and Tricks

Shrinking Database, SQL Server, SQL Server DBCC

Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.

SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch

June 14, 2010

Pinal Dave

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

SQL PASS, SQLAuthority Author Visit

June 11, 2010 was a wonderful day because I attended the very first SQL Server 2008 R2 Launch event held by Microsoft at Mumbai. I traveled to Mumbai from my home town, Ahmedabad. The event was located at one of the best hotels in Mumbai,”The Leela”. SQL Server R2 Launch…

SQL SERVER – What is Denali?

June 13, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I see following question quite common on Twitter or in my email box. “What is Denali?” Denali is code name of SQL Server 2011. Here is the list of the code name of other versions of SQL Server. In 1988, Microsoft released its first version of SQL Server. It was…

SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE

June 12, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

Earlier I wrote blog post SQL SERVER – Difference Between GETDATE and SYSDATETIME which inspired me to write SQL SERVER – Difference Between DATETIME and DATETIME2. Now earlier two blog post inspired me to write this blog post (and 4 emails and 3 reads from readers). I previously populated DATETIME…

SQL SERVER – Difference Between DATETIME and DATETIME2

June 11, 2010

Pinal Dave

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

SQL DateTime, SQL Scripts

Yesterday I have written a very quick blog post on SQL SERVER – Difference Between GETDATE and SYSDATETIME and I got tremendous response for the same. I suggest you read that blog post before continuing with this blog post today. I had asked people to honestly take part and share…