Looking at the following query:

Select

Table2.PId,

Table2.SSN,

Table2.Name

From

Table1

Inner Join Table2

...

Paul White NZ (3/19/2010)

---

And, at the risk of going on about this, READ COMMITTED can increase CPU usage by 50% compared to READ UNCOMMITTED, see http://sqlblog.com/blogs/alexander_kuznetsov/archive/2008/07/12/cpu-overhead-for-higher-isolation-levels.aspx.

READ UNCOMMITTED gets a bad...

Paul White NZ (3/19/2010)

---

Lynn Pettis (3/19/2010)

---

Partitions are great, but you have to running the Enterprise Edition to use them. So, with that, are you running SQL Server 2005 Enterprise...

CirquedeSQLeil (3/19/2010)

---

GilaMonster (3/19/2010)

---

GSquared (3/19/2010)

---

Well, I get to tell stories about riding a horse home through the woods at 40 degrees below zero with enough wind-chill to make spit freeze before...

CirquedeSQLeil (3/19/2010)

---

Lynn Pettis (3/19/2010)

---

Explaination I got from my Executive...

Explaination I got from my Executive Director was that...

Partitions are great, but you have to running the Enterprise Edition to use them. So, with that, are you running SQL Server 2005 Enterprise Edition?

I ask for a link, you provide it, and where do I use it?...

And, you really should consider dropping the use of the NOLOCK hint everywhere. You may want to start by reading this: http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx.

Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.

First, I want to thank Paul for referencing my article and the nice comments regarding it as well.

Second, Jeff makes a good point as well if this is a heavily...

[font="Comic Sans MS"]Snow Day![/font]

Once you attached the database to SQL Server 2008, it updated the file structures to SQL Server 2008 making it essentially a SQL Server 2008 database using SQL Server 2005...

The only other question then would be how long do you retain the snap shots? If you keep them too long, you will mostly start to experience performance issues...

Speaking of the individual, he...