Viewing 15 posts - 45,646 through 45,660 (of 49,571 total)
sultankahut (7/16/2008)
After that a series of other messages like "SQL Server is terminating in response to a 'stop' request from Service Control Manager.
That means that either somebody stopped SQL (issuing...
July 17, 2008 at 12:27 am
J (7/16/2008)
SELECT DISTINCT ntext
would mean for each record in the query, go get the text stored at pointer of ntext...
July 17, 2008 at 12:18 am
Sandy (7/16/2008)
July 17, 2008 at 12:14 am
noeld (7/16/2008)
But I would go even further. When you find yourself in this situation you should try to call the webservice from the "CLIENT" not on the server.
Fully agreed....
July 17, 2008 at 12:10 am
Just bear in mind that the entriesd in the query stats dmv are transient and are removed when the plan is discarded from cache.
It cannot be guaranteed that everything...
July 16, 2008 at 11:30 am
You can, but beware if you have more than a couple hundred rows. That kind of correlated subquery/triangular join performs really, really badly on larger row counts.
Maybe a temp table...
July 16, 2008 at 10:56 am
Yes, it will have an effect. How much of one depends not only on the counters but on the frequency that you are logging the events.
I would suggest you try...
July 16, 2008 at 10:39 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/Topic535347-65-1.aspx
July 16, 2008 at 10:37 am
Books online states
The number of read operations on the logical disk that are performed by the server on behalf of the event. These read operations include all reads from...
July 16, 2008 at 10:36 am
I don't have an answer to your cursor question, but maybe a solution that eliminates the cursor would be acceptable.
First a check, are you using SQL 2005? (I assume so,...
July 16, 2008 at 10:30 am
It does normally work out that way, though I have seen cases (on a large table on a server with multiple procs) where the order could come back in different...
July 16, 2008 at 9:20 am
In my experience, if you can start SQL, you're fine.
Steve: System resource contains the definitions of all of the system views, DMVs, Information schema views, all of the sp_ procs...
July 16, 2008 at 9:12 am
Jack Corbett (7/16/2008)
I obviously need to read a lot more.Was a similar query available pre-2005?
No. In 2000 finding the cause of log filling was more trial and error....
July 16, 2008 at 9:04 am
To find the cause of the log filling up, run
SELECT name, recovery_model_desc, log_reuse_wait_desc from sys.databases
The log_reuse_wait_desc will tell you what is preventing the space in the log file from been...
July 16, 2008 at 8:54 am
Viewing 15 posts - 45,646 through 45,660 (of 49,571 total)