Viewing 15 posts - 48,616 through 48,630 (of 59,065 total)
So... after you added the index, did you get index seeks or just scans? Also, never trust the execution plan by itself... did you turn statistics on or run...
August 23, 2008 at 1:51 pm
Thanks, Jack...
That's really the rub of it all when you're trying to print somerthing... fixed amount of real estate limited by the fat that the print still has to be...
August 23, 2008 at 1:42 pm
Thanks, Jeff...
August 23, 2008 at 11:34 am
Tom Brown (8/21/2008)
Its brilliant. But how on earth can anyone be expected to figure out the STUFF(... WHERE ... FOR XML PATH('') Syntax - especially when there is no...
August 23, 2008 at 10:51 am
rog pike (8/22/2008)
Jeff writes>Ok... show us the code that you would do it in RAC with.
Here yago.
Minimal Rac execute using standard defaults.
Nicely done... thanks.
August 23, 2008 at 10:30 am
DAvid (8/20/2008)
PRINT '===============...
August 23, 2008 at 10:29 am
Matt Frowe (8/21/2008)
Just wanted to say thanks for the great article - I myself was actually one of the noobies who posted in the forums about this sort of thing....
August 23, 2008 at 10:27 am
dphillips (8/20/2008)
August 23, 2008 at 10:23 am
dphillips (8/22/2008)
I wanted to retract with Jeff Moden before posting this publicly, but his mailbox here is full.
You can always send me an email. My PM on SSC is...
August 23, 2008 at 9:51 am
dphillips (8/20/2008)
August 21, 2008 at 12:15 am
Sergiy (8/20/2008)
create procedure procname
as
BEGIN
statement 1
statement 2
...
statement n
END
grant execute to procname to role1
grant execute to procname to role2
go
would change nothing and users would still...
August 20, 2008 at 8:23 pm
Tomm Carr (8/20/2008)
create procedure procname
as BEGIN
statement 1
statement 2
...
statement n
END
grant execute to procname...
August 20, 2008 at 8:22 pm
Indexed view materializes the SUM just as if it were in a table... except you don't have to worry about whether it's up to date or not. Just having...
August 20, 2008 at 7:54 pm
Carl Federl (8/20/2008)
August 20, 2008 at 7:42 pm
Wayne West (8/20/2008)
Alin Winters (8/20/2008)
Also, you should consider running a 64 bit installation, so you need x64 capable CPU's, 64 bit OS, and 64 bit SQL.
Check out this article by...
August 20, 2008 at 7:38 pm
Viewing 15 posts - 48,616 through 48,630 (of 59,065 total)