Grant Fritchey (5/6/2010)

---

Lynn Pettis (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

Paul White NZ (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

Make sure you've got your kilts in order gentlemen. Kilt Wednesday at the PASS Summit...

Grant Fritchey (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

Paul White NZ (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

Make sure you've got your kilts in order gentlemen. Kilt Wednesday at the PASS Summit is going to be...

CirquedeSQLeil (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

First, not...

samsql (5/5/2010)

---

Hi Gail and other experts

How does "ROWLOCK" work? I have this situation:

User1 - Query Analyzer

begin transaction

update t1 with (rowlock) set c1 = 10 where c1 = 5

User 2 -...

A gauntlet has been thrown down. Am I up to challenge? We shall see.

johnzabroski (5/5/2010)

---

I'm not sure you understand the problem.

bcp does not have a good way to represent NULL values in format files. If character data that contains a delimiter is...

Didn't know you could run DBCC CHECK DB against a .bak file.

Were you able to restore the database itself as under a differnet name using the .bak file?

Thinking about another way to do this, why not stage the data as is to a staging table in SQL Server and use T-SQL to fix the null values before...

Also, it sounds like you are trying to use the mdf from the older backup of the database and the ldf of a newer copy of the database; not going...

tosscrosby (5/5/2010)

---

Good old Chicago. There are a few things here, mainly consulting, but not a lot at...

A database snapshot is a point in time picture of the data. If you take a snapshot at 8:00 AM, you wont see any changes to the data that...

Glad it is working. Thanks for the feedback.

Paul White NZ (5/5/2010)

---

Lynn Pettis (5/5/2010)

---

Grant Fritchey (5/5/2010)

---

Make sure you've got your kilts in order gentlemen. Kilt Wednesday at the PASS Summit is going to be a happenning event this...

First, not currently planning on...

Now, for a simple answer without running any queries: Both applications are using tempdb and contributing to its growth.

You need to monitor the size of the tempdb, both mdf and...