Viewing 15 posts - 8,641 through 8,655 (of 49,571 total)
bugg (6/23/2014)
GilaMonster (6/23/2014)
The 0%, 0 seconds usually require a restart of SQL (not the server) to resolve. Otherwise wait.
Thanks Gila, when you say wait how long could that be before...
June 23, 2014 at 3:04 am
andrew gothard (6/23/2014)
GilaMonster (6/21/2014)
I love arguing this one with devs, so much 'agile' nonsense sometimes. 😀 "Creating validation in the database is a violation of the DRY principal"
The concept's...
June 23, 2014 at 3:01 am
The 0%, 0 seconds usually require a restart of SQL (not the server) to resolve. Otherwise wait.
June 23, 2014 at 2:34 am
rquest7 (6/22/2014)
What are the steps that a DBA or sql admin needs to do, to resolve the transaction log full issue
Did you bother to read the article I referenced?
June 23, 2014 at 2:33 am
This article appears to be an exact copy-paste of http://gavindraper.com/2012/02/18/sql-server-isolation-levels-by-example/
June 23, 2014 at 2:29 am
Locks you take never prevent you from taking other locks. They prevent *other* sessions from taking incompatible locks.
Still doesn't explain why you have an unnecessary (slow, inefficient) cursor.
June 22, 2014 at 2:20 pm
Shrinking the file - DBCC ShrinkFile. Requires that there's actually free space in the file first, if there isn't you'll have to delete data.
Full transaction log - http://www.sqlservercentral.com/articles/Administration/64582/
June 22, 2014 at 2:18 pm
There's a 3rd party SSIS component that assigns sequential numbers to data in a task. Can you not use that instead, possibly with an SSIS sort. May be faster, may...
June 22, 2014 at 1:17 pm
geo123abram (6/22/2014)
June 22, 2014 at 10:17 am
You are never blocked by yourself. Any locks that you hold are compatible with other locks that you request, they only prevent other people from taking incompatible locks.
June 22, 2014 at 10:15 am
WolfgangE (6/22/2014)
Also, the DTA shows you suggestions for one specific query, I think.
That's the missing index DMVs. DTA can tune a workload. It's still very prone to over-suggesting indexes....
June 22, 2014 at 10:14 am
I would agree with Chris Date on that. Yes, it's up-front work, but in my opinion everything that can be validated in a DB should be.
I love arguing this...
June 21, 2014 at 8:09 am
There's no such thing as a correct value for that counter. There's normal for your system, and abnormal based on your baselines.
Monitor for a while, see what is normal for...
June 21, 2014 at 6:34 am
Mirroring creates an exact copy (mirror) of the database on the second instance. Everything in the database is kept completely in sync.
June 20, 2014 at 1:36 pm
The only 'normal' that counter has is 'normal for your system'. It's dependant on hardware, database (structure and size), workload and probably other factors.
Monitor for a while, see what is...
June 20, 2014 at 1:32 pm
Viewing 15 posts - 8,641 through 8,655 (of 49,571 total)