How was the database damaged? If you still have access to the transaction log and can complete a tail log backup, using the most current full backup and the...

GSquared (4/2/2010)

---

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself or as part...

I think I can see people focusing this cert only to DBA's. I don't see that as the case. This should be certification that is also targeted to...

vaibhav.tiwari (4/2/2010)

---

Paul White NZ (4/2/2010)

---

vaibhav.tiwari (4/2/2010)

---

I was asking that if i will use your query then it will give me null for all invalid date but that might be possible...

WayneS (4/2/2010)

---

Grant Fritchey (4/2/2010)

---

I think the time in service, as part of the bridge between MCTIP and MCM, actually adds unnecessary overhead that is simply going to be gamed anyway....

WayneS (4/2/2010)

---

Grant Fritchey (4/2/2010)

---

That's the problem with bringing titles and time in rate to the equation. One of the best DBA's I know isn't a DBA, she's a developer; Gail...

With a chance of rain or snow this afternoon.

Another issue you run into is this:

02-05-2010 is this February 5, 2010 or May 2, 2010?

Do you have a way to determine which is the correct interpretation of the dates?

You may not get it all in one pass is something you may have to consider. Converting the data to a datetime may require multiple passes through the data....

CirquedeSQLeil (4/1/2010)

---

Lynn Pettis (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

Correct. As a SQL Server Database professional. It shouldn't matter that you are a developer, BI Specialist, or Admin. Working with SQL Server...

And be sure to pick the appropriate index on each table to be the clustered index. It doesn't have to be the primary index. Look at how the...

Use the model as a template. Nothing says you can't make changes, such as changing the primary key to a nonclustered index and making something else that is more...

CirquedeSQLeil (4/1/2010)

---

Correct. As a SQL Server Database professional. It shouldn't matter that you are a developer, BI Specialist, or Admin. Working with SQL Server is the important...

There is another option mirroring with a daily snapshot.

Egghead