Viewing 15 posts - 106 through 120 (of 643 total)
This is some excellent piece of work Steve & Michael! Thank you for sharing this with the community :-).
April 12, 2013 at 2:38 am
mealies (3/22/2013)
select *
from sys.dm_exec_query_stats qs cross apply sys.dm_exec_sql_text(sql_handle) st
ORDER BY qs.total_logical_reads DESC
. Am assuming that this DMV data is since the last fail over at 6:17am...
March 22, 2013 at 5:18 am
kevaburg (3/20/2013)
March 20, 2013 at 4:07 am
Thanks Lowell & Gazareth. We were able to track down the problem last week. It was collation of the SQL Server instance that was playing its role over there. Due...
March 19, 2013 at 7:59 am
Eugene Elutin (3/19/2013)
For heap tables order is not guaranteed at all.
Thanks Eugene, this is what I wanted to confirm. So, I take it as the identity values will be...
March 19, 2013 at 7:54 am
clintonG (3/14/2013)
March 15, 2013 at 6:55 am
Lowell (3/14/2013)
if the database was deleted, then you'll see that error, and need to reassign the default login, probably to master.
so as an...
March 14, 2013 at 7:53 am
Who is the author of this article? "Todd Thiemann" or "Ashvin Kamaraju" ?:-D
March 7, 2013 at 3:51 am
GilaMonster (2/15/2013)
jblovesthegym (4/18/2012)
February 20, 2013 at 1:25 am
Thanks George. Thanks a lot, you cleared the confusion. π
February 8, 2013 at 3:53 am
Hi All,
I know itβs an old thread but seemed a right place to ask this question. I want to confirm that what databases I need to restore back if we...
February 8, 2013 at 3:29 am
Bhuvnesh (1/30/2013)
but i was not sure why everything got blocked by internal processes.
Should i have been waited for sometime ? (for commmand which i executed to change the db to...
January 31, 2013 at 2:04 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.
I have checked whether there is any available space/allocated...
January 28, 2013 at 5:47 am
SQL* (1/27/2013)
Specify the TABLOCK hint in the DELETE statement. Using the TABLOCK hint causes the delete...
January 28, 2013 at 4:20 am
Okay, jokes apart. I think you want to delete the data from a table which is already locked as some other query is doing some modification in that table.
If that...
January 24, 2013 at 4:13 am
Viewing 15 posts - 106 through 120 (of 643 total)