Viewing 15 posts - 3,586 through 3,600 (of 14,953 total)
Steve Jones - SSC Editor (8/3/2011)
GSquared (8/3/2011)
Government's role in human civilization is application of force. So, the moment it moves outside of defense against force, it turns into a...
August 4, 2011 at 6:32 am
If you were talking about the clustered index, I'd agree with you completely. But, if you're looking at wider tables, and you want to avoid bookmark lookups, the extra...
August 3, 2011 at 1:56 pm
Unless you've run sp_preparesql with the same values on both servers, you're not going to get what you need.
Have you traced those?
August 3, 2011 at 1:51 pm
On the DBA = Director bit, I just can't help but be reminded that Uwe Boll makes a pretty good living ....
August 3, 2011 at 1:34 pm
Grant Fritchey (8/3/2011)
August 3, 2011 at 1:26 pm
If you want to grant execute permission to only a certain selection of stored procedures, have you thought about moving those to a different schema? Then you can grant...
August 3, 2011 at 9:02 am
LutzM (8/3/2011)
Tom.Thomson (8/3/2011)
Actually, if there were a world competition for the worst beers, no European country would come top - the worst European beers are comfortably outclassed for awfulness by...
August 3, 2011 at 8:59 am
Dan.Humphries (8/3/2011)
I love that people are actually claiming that we need to look to the...
August 3, 2011 at 8:57 am
Cool biz.
Not a problem in posts here. But on a resume, you want to look as good as you can.
August 3, 2011 at 8:53 am
ChrisM@Work (8/3/2011)
GSquared (8/3/2011)
ChrisM@Work (8/3/2011)
Recursive CTE's don't allow aggregate functions but they do allow ROW_NUMBER() which provides you with a means of obtaining MIN() and MAX():
It's probably going to be slower...
August 3, 2011 at 7:42 am
The grammatical issues are pretty pervasive.
For example, this:
I am good reader for this forum but never posted much on this.I finished my Masters in dec 2007 and gave birth to...
August 3, 2011 at 7:41 am
ChrisM@Work (8/3/2011)
Recursive CTE's don't allow aggregate functions but they do allow ROW_NUMBER() which provides you with a means of obtaining MIN() and MAX():
It's probably going to be slower than a...
August 3, 2011 at 7:30 am
Since the data modification is on the same resources as the select, it will hold the locks from that. You'll only run into the deadlock in cases of either...
August 3, 2011 at 7:21 am
I think the Quote button works by inverted position on the page, not by ID.
You can use it easily on an earlier page than the most recent one without the...
August 3, 2011 at 7:14 am
The first thing I recommend is to get in touch with local recruiters.
I have to ask, is English your native language? Not to criticize, but your posts in this...
August 2, 2011 at 2:42 pm
Viewing 15 posts - 3,586 through 3,600 (of 14,953 total)