Viewing 15 posts - 46,171 through 46,185 (of 49,571 total)
Are you sure that the sleeping sessions come from IIS?
Are these sessions blocking other sessions? Why are you concerned about them?
June 20, 2008 at 12:42 am
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic520315-338-1.aspx
June 20, 2008 at 12:30 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic520331-148-1.aspx
June 20, 2008 at 12:28 am
The remote server or the driver for the linked server doesn't allow remote transactions.
It's nothing to do with the proc rewrite. Check the linked server settings or check with the...
June 20, 2008 at 12:24 am
Profiler or a server side trace.
If you want to see the queries within the procs, you want the sp:StmtCompleted event.
Be aware that if your server is busy the trace...
June 20, 2008 at 12:23 am
Depends on the queries that use that table. There's no hard rule.
You should have a clustered index. You should have enough nonclustered indexes on different columns that the frequently run...
June 19, 2008 at 7:38 am
Do you have a backup of that database?
June 19, 2008 at 7:34 am
What's your question?
June 19, 2008 at 7:31 am
Main difference between 2000 and 2005 is that in 2005 you can alse add columns as INCLUDE columns insted of as part of the key. Makes it a lot easier...
June 19, 2008 at 7:22 am
Ah. A form of serverside trace.
I thought for a moment that I'd missed a feature like 2005's default trace. :hehe:
June 19, 2008 at 6:58 am
Mscode_Pro (6/19/2008)
So the two ways are impossible
What ways are impossible?
I'll be wait for any solutions
Be patient. We're all volunteers here. We're not paid to answer forum questions.
June 19, 2008 at 6:52 am
<eyes glaze over> Right....
In addition to Grant's comments...
You have a lot of branching logic within the proc (if.. else...).
That kind of thing tends to lead to sub-optimal execution plans,...
June 19, 2008 at 6:50 am
Grant Fritchey (6/19/2008)
June 19, 2008 at 6:33 am
Do you have a backup of msdb?
If you look in the SQL log file (the error log), are there any entries that indicate why the database is suspect?
June 19, 2008 at 6:27 am
Bookmark lookups occur when SQL uses a nonclustered index to evaluate the rows required for a query. If the nonclustered index does not contain all the columns needed for the...
June 19, 2008 at 6:25 am
Viewing 15 posts - 46,171 through 46,185 (of 49,571 total)