Viewing 15 posts - 17,371 through 17,385 (of 22,214 total)
Doc (5/27/2009)
Roy have you forgot about the books from Grant Fritchey - "SQL Server 2008 Query Performance Tuning Distilled" and "Dissecting SQL Server Execution Plans"
Gail was still right. There is...
May 27, 2009 at 7:31 am
This is opinion, but no. I'd say 2008 is more of an upgrade than 7 to 2000 was. Not by a lot, but more. However, knowledge learned of 2005 is...
May 27, 2009 at 7:14 am
I worked for a dot com that had almost a tb on SQL 7. I'm working now for an insurance company and we don't have any databases over 100gb (yet,...
May 27, 2009 at 7:12 am
AShehzad (5/26/2009)
Statistics will be updated automatically after index rebuild. There is no requirement to separately configure this task.
Are you sure? 😉
But since you shouldn't automatically rebuild all indexes all the...
May 27, 2009 at 7:08 am
If people are posting code on the net, it has to be with the expectation that it will be used by others. I know that's the assumption that I have...
May 27, 2009 at 6:49 am
Tell them not to drop tables. In 2000 we couldn't revoke their privileges to create indexes. We had to tell them not to do it. Although, since we built our...
May 27, 2009 at 5:33 am
Create a role that you're going to add your developers to. Then add ddl_admin and security_admin roles that role. Then deny CREATE TABLE to the role. That about does it....
May 26, 2009 at 1:28 pm
David Burrows (5/26/2009)
...You could really mess with people's heads with this.
Well it obviously did with yours 😛
Yeah, but I'm a head case on the best days. I'm talking about...
May 26, 2009 at 6:37 am
RBarryYoung (5/22/2009)
Grant Fritchey (5/22/2009)
May 23, 2009 at 2:13 pm
The queries look identical.
Post the execution plans.
Depending on the complexity of the query, the table order in the JOINs doesn't matter because SQL Server can rearrange them as needed, based...
May 22, 2009 at 11:47 am
Just to deviate a bit from what everyone else is saying, if I were going to put any indexes on the system at all, because of how SQL Server stores...
May 22, 2009 at 11:26 am
Yep, in the Navy on Subs. Hated it, but I'm glad I did it.
May 22, 2009 at 11:21 am
Oh, and my wife runs a Girl Scout troop and I pitch in there occasionally. That's one strange organization, especially after dealing with the BSA so much.
We're considering getting involved...
May 22, 2009 at 11:19 am
Congratulations on achieving the rank of Eagle. That's an accomplishment I can only stand in awe of.
I'm currently an Assistant Scout Master for my local troop. I've only been directly...
May 22, 2009 at 11:14 am
Viewing 15 posts - 17,371 through 17,385 (of 22,214 total)