Viewing 15 posts - 14,596 through 14,610 (of 49,552 total)
sathiyan00 (1/28/2013)
because for past 2 hours its showing 0%.
Creating and zeroing out the database files.
January 28, 2013 at 6:01 am
anthony.green (1/28/2013)
purushottam2 (1/28/2013)
it is charging few dollars, i have to take approvals from client.I take it you missed the "Get your free eBook download here." link on the webpage then?
and...
January 28, 2013 at 5:38 am
Grant Fritchey (1/28/2013)
You can set a traceflag, 2371, to change this behavior. Here are the details.
For SQL 2008 R2 and above only unfortunately.
January 28, 2013 at 5:26 am
SQL* (1/28/2013)
From the above statement from MSDN, if we use TABLOCK in the DELETE statement then the allocated pages will be deallocated.
If the table is a heap.
So the above statement...
January 28, 2013 at 5:10 am
Did you read the book chapter I recommended?
January 28, 2013 at 4:56 am
Please note: 4 year old thread.
Also, ad-hoc queries and plan cache has nothing to do with sleeping connections. Sleeping connections are ones waiting for input from the application, they are...
January 28, 2013 at 2:16 am
Please note: 5 year old thread.
Also, ad-hoc queries and plan cache has nothing to do with sleeping connections.
January 28, 2013 at 2:15 am
Please note: 3 year old thread.
Also, ad-hoc queries and plan cache has nothing to do with sleeping connections.
January 28, 2013 at 2:09 am
Angel DBA Mex (6/5/2007)
could you help me how clearing this proccesses, maybe with a period of time, thank a lot
Why?
A sleeping connection is not doing anything, it's waiting for some...
January 28, 2013 at 2:05 am
Rahim-441309 (1/28/2013)
U can useDBCC FREEPOCCACHE Command to clear them regularly or
create a job that will do late in the night
Errr... no. FreeProcCache does nothing to...
January 28, 2013 at 2:03 am
You need to manage that log better
Please read through this - Managing Transaction Logs[/url]
Do not ever delete a database's transaction log. SQL cannot always recreate the log, only if the...
January 28, 2013 at 2:01 am
Next step would be to identify what in SQL Server is using the CPU.
See chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
January 28, 2013 at 1:59 am
Alex koranteng (1/27/2013)
The sproc is giving different row counts between the development and test servers.
The data is different or the code is different. Can't really say much more without...
January 27, 2013 at 7:05 am
There's a RiderNo in trip details that does not have a matching entry in Riders
January 26, 2013 at 10:43 am
Viewing 15 posts - 14,596 through 14,610 (of 49,552 total)