Viewing 15 posts - 39,586 through 39,600 (of 49,571 total)
mikeoflaherty (4/22/2009)
What are the ramifications of ticking the Boost SQL Server Priority on Windows option?
Don't. It's strongly advised (by Microsoft) that the setting not be changed.
If you have performance problems,...
April 22, 2009 at 10:49 am
Here's something that may get you started. I make no guarantees as to how well it will perform.
SELECT USER,
SUM(CASE WHEN STATUS NOT IN ('90R','99I') THEN 1 ELSE...
April 22, 2009 at 10:46 am
megho_man (4/22/2009)
Ok , it's not a SQL Server error , but what is the cause ?I want to know the reason of this issue , or the solution.
No...
April 22, 2009 at 10:35 am
Something my previous manager told me that's stuck in my memory.
"When you accept a job, have a plan for what you want to do next."
April 22, 2009 at 10:29 am
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...
April 22, 2009 at 10:27 am
What's the full error with complete error message?
Where do you see that error?
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.
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?
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...
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...
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...
April 22, 2009 at 2:37 am
stankirk (4/21/2009)
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....
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...
April 21, 2009 at 4:15 pm
I think I'm going to consult an expert on this one.
April 21, 2009 at 2:50 pm
Viewing 15 posts - 39,586 through 39,600 (of 49,571 total)