Viewing 15 posts - 41,431 through 41,445 (of 49,562 total)
srihari nandamuri (1/26/2009)
Take corrective action
What kind of corrective action are you proposing?
Dropping indexes that haven't been used since the last server start is not recommended, unless you're very...
January 26, 2009 at 9:52 am
P Jones (1/26/2009)
I also get hot under the collar about bad spelling and grammar - I had a traditional English grammar school education
Just bear in mind that not everyone...
January 26, 2009 at 9:45 am
Has your job been doing full backups, or transaction log backups? In full recovery, you need both.
January 26, 2009 at 9:38 am
Steve Jones - Editor (1/25/2009)
Personally I dislike labeling things bad and good, especially with code since it's a question of where and when things make sense.
If you've read my blog...
January 26, 2009 at 9:36 am
David.Poole (1/26/2009)
I've heard that if an index grows beyond a certain point SQL Server is unable to use it.
May I ask where you heard that from?
As far as I know,...
January 26, 2009 at 9:36 am
Ed (1/26/2009)
IX_sysValidationList is a unique, non-clustered index on the column, ValidationPartyID. Is this index not appropriate for these joins?
Apparently not. Probably because it's not covering. I haven't looked at...
January 26, 2009 at 9:33 am
So the database size is 72GB, the unallocated space is 3GB
Then the reserved size is 69 GB, the data is 31 GB, the indexes are 38 GB and the unused...
January 26, 2009 at 12:54 am
Looks fine. I'll take a detailed look later.
One thing I can tell you straight off, there's no clustered index on the table that you're repeatedly joining to, and no useful...
January 26, 2009 at 12:43 am
thulani.moyana (1/25/2009)
I would like to find out if one can rely on the tuning advisor and implement all of its recommendations?
No.
The DTA does an OK job. Not great, but...
January 26, 2009 at 12:38 am
Please post in the appropriate forum in the future.
Temp tables are treated the same way (almost) as permanent tables. So creation of a temp table will force a proc to...
January 26, 2009 at 12:35 am
Why is that done in the CLR? For procs that affect data, T-SQL's a better choice.
There's no setting or anything, so the only thing I can think of is that...
January 26, 2009 at 12:32 am
The second has a very different exec plan for a simple reason. That subquery, as written, must return only one value. If it returns more, the query must fail (with...
January 26, 2009 at 12:30 am
Couple things...
Nolock is not a good thing to add everywhere. Are you aware of the problems it may cause and do you feel that the risks of bad data are...
January 25, 2009 at 11:11 am
True. I believe (from what I've been told) that correlated subqueries did always run once per row of the outer query, back in SQL 6.5.
RBarryYoung (1/25/2009)
January 25, 2009 at 10:38 am
Viewing 15 posts - 41,431 through 41,445 (of 49,562 total)