Since it's only been in production for a couple of weeks, I have not heard any news about a possible service pack. I suspect it's at least 6-9 months out.

Yes,...

You can.

There are some design issues associated with GUIDs (Globally Unique IDentifiers) that you might want to know about. They're notoriously poor choices for clustered indexes, just as an example.

There is no function within backups that allows you to backup tables only.

You could move these tables to a different file group and try doing a file group only backup.

NEWID() is a built in function for SQL Server that generates a globally unique identifier value. You can run it within just about any TSQL code. Try:

SELECT NEWID()

Have you looked at the execution plans between different operating systems? It's hard to compare performance between different os's especially if you then toss in that Win 7 is a...

I guess I'm operating with a bigger budget. We've got two different backup generators that can each power the whole data center for about 72 hours without power interruption (two...

Another vote for Itzik's excellent book.

You might also want to check out Joe Sack's "Transact SQL Recipes." It's just a very straight forward listing of possible T-SQL solutions for common...

Well, pretty much, we start the SAN, get it online and tested, and then start up SQL Server. They are two, completely seperate operations and even managed by two completely...

nadersam (5/26/2010)

---

Grant Fritchey (5/26/2010)

---

I would suggest using connection pooling. As much as possible, reusing connections is the way to go because it reduces the amount of memory that connections take...

Jeff Moden (5/25/2010)

---

Steve Jones - Editor (5/25/2010)

---

Hyperbac, owned by Red Gate now, does something similar. You can work with a backup file as though it were a real database. The...

Since you're working in 2005, I'd suggest, especially for targeted information like this, to use the dynamic management views to pull the execution plans and execution information directly from the...

I would suggest using connection pooling. As much as possible, reusing connections is the way to go because it reduces the amount of memory that connections take up (new memory...

If you use the "fake" key in your...

karthikeyan-444867 (5/26/2010)

---

GilaMonster (5/25/2010)

---

There's a big, massive, huge difference between not using an int identity for a primary...

Identity gaps are only an issue if, for whatever reason, you're assuming a perfect chain of numbers. Don't make that assumption and the gap problem goes away. The idea is...