Oh yes :-D. There's exactly 217 uses of NOLOCK in that query. I have no idea why. Well, maybe... Considering how long this thing ran, and...

Personally, I'm working with 2,659 databases, which add up to about 700GB of data altogether.

And yes, this is a horrible, horrible design by a vendor :-D. Really, all of...

SQL Guy 1 (2/12/2014)

---

It is very strange to hear that a DBA applies for bunkropcy. We are highly paid professionals who receive much more than the average value in...

Hm. Personally, I left my last job after a year and a half; things started out rather good, but after the first year, management became rather frustrating to deal...

On a more ridiculous note...

The word "candy" is now trademarked[/url]

This is all sorts of absurd. The makers of the Candy Crush line of mobile phone games were granted a...

Actually, I thought I faintly remembered reading something similar at some point; after doing some digging, it turns out it was (incorrectly) attributed to Brent Ozar's site in my head:

Blog...

Terribly sorry for the late reply; I left work shortly...

Hm. If...

For your wildcard search portion, you need to use LIKE instead of the = operator; so:

Select FName,Lname from Customers

where ID LIKE '%' + @ID+ '%'

By using = instead of LIKE,...

seatedElephant (1/14/2014)

---

Hi,

Thanks a lot for the detailed reply. I totally take your point that a full restore (with DBCC CHECKDB) would be the only way to be absolutely sure that...

Aha! With what Jeff mentioned, it seems that you may indeed be a victim of the aforementioned bug:

Microsoft Fix Notes

It seems that this problem was fixed in a Cumulative...

Hmm. A bit more information is necessary here. What's the size of tempdb when it's grown out quite a bit? From your settings, it looks like tempdb...

Sean Lange (1/10/2014)

---

hisakimatama (1/10/2014)

---

Sean Lange (1/10/2014)

---

hisakimatama (1/10/2014)

---

The database most definitely isn't safe and secure if queries like those are being injected in. As Gail and the others have said,...

Sean Lange (1/10/2014)

---

hisakimatama (1/10/2014)

---

The database most definitely isn't safe and secure if queries like those are being injected in. As Gail and the others have said, your code's open...

The database most definitely isn't safe and secure if queries like those are being injected in. As Gail and the others have said, your code's open for injection, and,...