Viewing 15 posts - 48,361 through 48,375 (of 59,064 total)
Heh... if only it were that simple, Gary. 🙂 Op wants the 40th row... not the top 40. Of course, this is SQL Server 2005 and TOP is...
September 10, 2008 at 5:15 pm
Chris Morris (9/10/2008)
INSERT INTO sig...
September 10, 2008 at 5:11 pm
Chris Morris (9/10/2008)
You're welcome, thanks for the feedback.
The number of rows will probably matter if there are hundreds of thousands. If the query runs too slowly (and it runs...
September 10, 2008 at 5:08 pm
SanjayAttray (9/10/2008)
September 10, 2008 at 5:03 pm
Well done, Chris! And, no bloody UDF, either!
khushbu,
If you don't know what a Tally table is or does, please refer to the following article. I believe you'll find...
September 10, 2008 at 5:44 am
majorbloodnock (9/10/2008)
Indeed, the knowledge someone has those weapons available but chooses not to use them does in itself help to establish that person's integrity.
I found absolutely no correlation between soft-skills...
September 10, 2008 at 5:40 am
thivyapraba (9/10/2008)
Jeff,Nice article, But how do you measure the performance, is there any tools?
There's lot's of tools like Performance Monitor, etc. But, I didn't use anything quite so sophisticated...
September 10, 2008 at 5:14 am
Good article, but you do have to audit all the drives beforehand to use it. And, what if a new drive is made available by the SysOps? The...
September 9, 2008 at 6:11 am
Heh... thanks for the feedback guys.
September 9, 2008 at 6:03 am
Timothy! Great article on NO EXPAND. Nicely done!
September 9, 2008 at 6:01 am
M Roush (9/9/2008)
September 9, 2008 at 6:00 am
Or, you could do it the way I showed you and not worry about correlation. 😉
September 9, 2008 at 5:33 am
GAURAVKAUSHIK26 (9/9/2008)
September 9, 2008 at 5:28 am
gardenlady (9/8/2008)
September 8, 2008 at 7:25 pm
keywestfl9 (9/8/2008)
September 8, 2008 at 7:18 pm
Viewing 15 posts - 48,361 through 48,375 (of 59,064 total)