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

SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE

January 29, 2011

SQL Server 2011 will contain one of the very interesting feature called SEQUENCE. I have waited for this feature for really long time. I am glad it is here finally. SEQUENCE allows you to define a single point of repository where SQL Server will maintain in memory counter. USE AdventureWorks2008R2…

SQL SERVER – Reducing Page Contention on TempDB

January 26, 2011

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL TempDB

I have recently received following email asking about how to reduce page contention on TempDB.

“We are using Trace Flag 1118 to reduce the tempDB contention on our servers (2000 and 2005). What is your opinion?

We have read lots of material, would you please answer me in single line.”

SQL SERVER – Denali – Multi-Monitor SSMS Windows

January 24, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

I have a dual screen arrangement at my home system. I love it because it’s very convenient. When I am working with SQL Server 2008 R2 or any earlier versions, I would want to use both of the Monitor so I open two separate SQL Server Management Studio and work along…

SQL SERVER- Differences Between Left Join and Left Outer Join

January 22, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

There are a few questions that I had decided not to discuss on this blog because I think they are very simple and many of us know it. Many times, I even receive not-so positive notes from several readers when I am writing something simple. However, assuming that we know…

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance

January 19, 2011

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server, SQL Server DBCC

Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good.

SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

January 14, 2011

Pinal Dave

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

SQL Scripts

Earlier I wrote SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine. That was the first article on the series of my real world experience of Performance Tuning experience. I have written second part the same series over here. Read second part over here: Quick…

SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name

January 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Quite often a simple things makes experienced DBA to look for simple thing. Here are few things which I used to get confused couple of years ago. Now I know it well and have no issue but recently I see one of the DBA getting confused when looking at the…