Viewing 15 posts - 9,361 through 9,375 (of 49,571 total)
allaspects (4/9/2014)
Lynn is obviously trolling. Sad that on a resource such as this website, someone is out to troll and not help.
You might want to google Lynn's contributions here before...
April 9, 2014 at 2:25 pm
Eirikur Eiriksson (4/9/2014)
April 9, 2014 at 1:16 pm
Grant Fritchey (4/8/2014)
yuvipoy (4/8/2014)
What about DTA statistics ?
are they not statistics?
How DTA able to do get those details(Statistics), which means that it was missed...
April 9, 2014 at 12:12 pm
Only way to do this is to implement a trigger, I recommend an INSTEAD OF trigger and do your validation in the trigger.
April 9, 2014 at 12:06 pm
Ok, so it is session 507 which has had an active transaction since the 5th of April (last week friday)
You may want to do some investigation as to how and...
April 9, 2014 at 11:00 am
sql-lover (4/9/2014)
GilaMonster (4/9/2014)
sql-lover (4/9/2014)
I need to know how to update sys.indexes view or system catalog directly on SQL2012.
You can't. sys.indexes is not a table, it's a view.
Please, don't try the...
April 9, 2014 at 10:57 am
Table definitions, index definitions and actual execution plan please.
The root cause it that your query is pulling a hell of a lot of data. Is it all necessary?
April 9, 2014 at 10:52 am
No, don't. It's not necessarily the blocking session which is causing the large log. It's an active transaction. It may be the same session, it may not.
What does DBCC OPENTRAN...
April 9, 2014 at 10:39 am
yuvipoy (4/9/2014)
Lynn Pettis (4/9/2014)
Simple, don't use NOLOCK.What is the cause of the problem ?
The nolock hint.
I have been using this statement for nearly 6 years in prodution i did not...
April 9, 2014 at 10:35 am
sql-lover (4/9/2014)
I need to know how to update sys.indexes view or system catalog directly on SQL2012.
You can't. sys.indexes is not a table, it's a view.
Please, don't try the 'partial restore...
April 9, 2014 at 10:30 am
charipg (4/9/2014)
full restaoration will take again half day.
Then you may want to get started.
Probably longer than half a day, since the last restore failed part way through for some reason...
April 9, 2014 at 6:53 am
What you're seeing there is perfectly normal, expected, documented behaviour.
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
April 9, 2014 at 6:52 am
No.
Detecting that they have occurred is easy. Predicting that they may would require massive, in-depth analysis of every piece of code, how it runs, how often it runs and even...
April 9, 2014 at 5:07 am
The database can't be offline as you can not run any commands against an offline database.
Rebuilds take locks (unless you run them with the ONLINE option) and hence will block...
April 9, 2014 at 5:06 am
If you stop it before it's complete, you're just wasting time, you won't get the results of what (if anything) is wrong and hence you may as well not have...
April 9, 2014 at 5:04 am
Viewing 15 posts - 9,361 through 9,375 (of 49,571 total)