Viewing 15 posts - 106 through 120 (of 252 total)
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...
February 24, 2014 at 2:21 pm
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...
February 21, 2014 at 2:01 pm
SQL Guy 1 (2/12/2014)
February 14, 2014 at 4:42 pm
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...
February 10, 2014 at 7:52 am
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...
January 30, 2014 at 8:22 am
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:
January 24, 2014 at 2:26 pm
sharonsql2013 (1/21/2014)
Here is what I was looking forSelect *
from SomeTable
where (table_id LIKE '%' + @ID+ '%' OR @ID = '*')
Terribly sorry for the late reply; I left work shortly...
January 22, 2014 at 6:01 am
sharonsql2013 (1/21/2014)
Yes, I see that. But how can I also see all the values through wildcard.I mean I should be able to pass "*" and see all aswell
Hm. If...
January 21, 2014 at 3:13 pm
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,...
January 21, 2014 at 2:32 pm
seatedElephant (1/14/2014)
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...
January 14, 2014 at 7:44 am
Aha! With what Jeff mentioned, it seems that you may indeed be a victim of the aforementioned bug:
It seems that this problem was fixed in a Cumulative...
January 13, 2014 at 3:00 pm
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...
January 13, 2014 at 2:21 pm
Sean Lange (1/10/2014)
hisakimatama (1/10/2014)
Sean Lange (1/10/2014)
hisakimatama (1/10/2014)
January 10, 2014 at 1:22 pm
Sean Lange (1/10/2014)
hisakimatama (1/10/2014)
January 10, 2014 at 1:11 pm
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,...
January 10, 2014 at 1:04 pm
Viewing 15 posts - 106 through 120 (of 252 total)