Brandie Tarvin (2/15/2012)

---

bitbucket-25253 (2/15/2012)

---

Now, now be honest is it the chocolate or the Martinis or maybe a...

I assume you're joking? If not, what in particular can't you understand?

Sean Lange (2/13/2012)

---

Great question and excellent scenario setup. I am quite surprised that at the time I am posting there are 417 answers and 16% of them still think truncate...

jdamm (2/13/2012)

---

I'll add another "Great Question" - I like the questions that make you sit and think about an answer, rather than either run a snippet of code or look...

GSquared (2/13/2012)

---

kschwid (2/13/2012)

---

I would just like to comment: Sometimes the people asking the question give enough information but the people trying to answer the question either don't understand and shouldn't...

To add for a moment to Paul's well answered posts, the Snapshot Isolation won't save you from the necessary locks for Truncate, but will save you from the necessary dirty...

cengland0 (2/13/2012)

---

I've thought of creating a view that points to the table. Then, you can populate another table with the new information and then update the view to point...

Thanks. I was concerned that I wouldn't explain the components well enough. Hopefully the scenario is clear and this doesn't end up as...

I'm afraid I have to agree with Hugo on this one. The wording of the question left me to believe it was intended to mean "without using specific hints"....

Roy Ernest (2/10/2012)

---

Thx for all the advice. Yes, they have plans for me to go higher up in the management. I have been asked to manage all Development teams and...

bitbucket-25253 (2/9/2012)

---

Koen Verbeeck (2/9/2012)

---

Revenant (2/9/2012)

---

L' Eomot Inversé (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

HowardW (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

Interesting fact: Historically, it used to be in the UK that people drank more beer than water as it was...

+1 for allocating a different drive for TempDB. C:\ is usually where your OS, installs, and Swapfile go. If tempdb starts getting hammered and memory drives the swapfile...

A) Dynamic SQL should be used sparingly and with a specific intent to optimization, otherwise: kill it with fire. Even then, # tmps work just as well in dynamic...

At a guess it's parameter sniffing and coming up with a generic plan that's 'bad'.

Check out this blog by Gail Shaw for more information:

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

print dateadd( ss, 60, DATEADD(hh, -6, DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))

OR

print dateadd( n, 1, DATEADD(hh, -6, DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))

n = minute, m = month.