Viewing 15 posts - 39,571 through 39,585 (of 49,552 total)
Grant Fritchey (4/22/2009)
That's a huge topic. There have been books written about it (note the bottom of this post 😀 ).
Not enough books, unfortunately. I'd love to have a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 10:27 am
What's the full error with complete error message?
Where do you see that error?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 10:23 am
megho_man (4/22/2009)
do you find the solution ?please reply me .
It's not a SQL Server error.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 10:20 am
Other than dropping the primary key (bad idea), you could create a second index.
Where's the clustered index on this table?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 9:55 am
GilaMonster (4/21/2009)
sharanurampur (4/21/2009)
when I checked into the log files i got some message like..No errors there. Are there any messages in the log that relate to the database Common?
Well?
If the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 9:52 am
You don't have table scans, that's what I'm trying to say.
The Scan count does not count the number of table scans. It should be the number of times the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 3:14 am
Plan looks pretty good.
The scan count does not indicate the number of times the table was scanned. In fact, it's a pretty hard to interpret number as different query...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 2:37 am
stankirk (4/21/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 2:13 am
Scan count != Table scan.
Without seeing the exec plan, I can't say for sure but I'm guessing that you now have a nonclustered index seek and around 90 bookmark lookups....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2009 at 2:05 am
Jack Corbett (4/21/2009)
Grant Fritchey (4/21/2009)
The other key is to hook up with as many vendor parties as you possibly can. Then you eat for free.
This is definitely part of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 4:15 pm
I think I'm going to consult an expert on this one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 2:50 pm
Stupid question, and I know this may sound insulting (it's not the intention), are you sure you're running checkDB on the right database?
What version of SQL 2000? (SELECT @@Version)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 2:31 pm
Then you want to stay away from the official conference hotels. They are not cheap. I'll probably be staying at either the 6th Ave Inn or the 7th Ave Inn...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 2:25 pm
Don't give people alter table permissions?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 2:22 pm
Is there perhaps an index rebuild that runs after whatever triggered that mail but before the checkDB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 21, 2009 at 2:06 pm
Viewing 15 posts - 39,571 through 39,585 (of 49,552 total)