Viewing 15 posts - 12,166 through 12,180 (of 22,214 total)
I'd strongly suggest looking into the concept of data normalization. I'm not sure what business case this table is answering, but I'm positive it could be better met through relational...
July 21, 2011 at 4:55 am
I'd suggest you download a copy of SQL Monitor[/url] from Red Gate software. Based on the list of monitoring needs you think you have I think it might be a...
July 21, 2011 at 4:51 am
There are several white papers available from Microsoft on how to configure your tempdb, but from the sounds of things it might not help. Pre-sizing is good, but it might...
July 21, 2011 at 3:01 am
GilaMonster (7/20/2011)
Grant Fritchey (7/20/2011)
It can only be people who chose to register for one of those other pre-cons... THOSE people.
So at tea break, we run into Rob's session work on...
July 20, 2011 at 9:57 am
The Dixie Flatline (7/20/2011)
GilaMonster (7/20/2011)
Ninja's_RGR'us (7/20/2011)
GilaMonster (7/20/2011)
Jeff Moden (7/20/2011)
I understand that Gail Shaw will be co-presenting with you...
Yup, Grant and I are doing comed^H^H^H^H^H execution plans as a precon...
July 20, 2011 at 9:45 am
I really like that picture... well, the left side of it anyway.
July 20, 2011 at 9:35 am
Jeff Moden (7/20/2011)
Grant Fritchey (7/20/2011)
All joking aside, I'd love to see you win this one.
I never did read what the winner would be awarded before the folks at work nominated...
July 20, 2011 at 9:30 am
Based on what you describe, yeah, you're better off with temp tables. Although, how were the physical tables indexed? Did you put a cluster on the SPID column? There's a...
July 20, 2011 at 7:04 am
Also keep in mind that those costs are estimates based on statistics, not actual execution time for your server.
Look at the execution times, the number of scans and the number...
July 20, 2011 at 6:57 am
Lynn Pettis (7/20/2011)
Grant Fritchey (7/20/2011)
Jannie-186227 (7/20/2011)
ahem.How do you reply to a thread with 23 thousand replies?
Is there any more value to be added in this thread?
Cheers
Jannie
In this space, say whatever...
July 20, 2011 at 12:53 am
Jannie-186227 (7/20/2011)
ahem.How do you reply to a thread with 23 thousand replies?
Is there any more value to be added in this thread?
Cheers
Jannie
In this space, say whatever needs saying. Just read...
July 20, 2011 at 12:46 am
Lynn Pettis (7/19/2011)
Jeff Moden (7/19/2011)
But a late congrats to Lynn as well.
Dang it. I haven't been keeping up and I've obviously missed something good.
Lynn... what did you do?
My oldest...
July 20, 2011 at 12:45 am
Jeff Moden (7/19/2011)
Grant Fritchey (7/19/2011)
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].I'm sure you know who I'm talking about. 😉
I was just coming over to post...
July 20, 2011 at 12:31 am
Nope. Gail said that the two values combined would make a unique index, and they will. They could also be a clustered index. They could also be a primary key...
July 19, 2011 at 8:42 am
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].I'm sure you know who I'm talking about. 😉
I was just coming over to post a comment about someone...
July 19, 2011 at 8:06 am
Viewing 15 posts - 12,166 through 12,180 (of 22,214 total)