Viewing 15 posts - 8,791 through 8,805 (of 49,552 total)
What, specifically do you want to know, beyond what is documented in Books Online for that DMV.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2014 at 3:24 am
Which one of the commands I gave you returned that? Is that the entire output?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2014 at 3:23 am
Does your database have read_committed_snapshot enabled?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2014 at 2:29 am
You can't rebuild indexes on system tables.
Take the DB into single user mode and run:
DBCC CheckDB ('RXL084BAY',Repair_Rebuild) with no_infomsgs
Post any output please. Once complete, run this:
DBCC CheckDB ('RXL084BAY') with no_infomsgs,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2014 at 2:24 am
Not estimated. Actual plans. Save as .sqlplan files and attach them
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 10, 2014 at 2:24 am
It's the same index, but different rows of that index (see the different values for ID in the keylock). It's not the same resource
Key lock is a lock on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 3:06 pm
wall str33t (6/9/2014)
Change your "in" clauses to a (value1 or value2), always avoid "in" clauses.
Um, why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 2:54 pm
Andrew Kernodle (6/9/2014)
EDIT: Incorrect on my part! Tested it just now; issuing BEGIN TRAN and then not doing a COMMIT or ROLLBACK won't hold locks.
It will hold...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 2:38 pm
Bear in mind that it could be something as simple as an open transaction. That could require reading through multiple log backups.
How many days do you have spare to do...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 2:31 pm
While it's possible to query a log backup, the results are not easy to interpret. There are no queries listed in the log, just the records of what objects were...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 9:42 am
lmacdonald (6/9/2014)
If DDL triggers run after, why does the trigger I have that prevents someone from dropping a database work?
Because you can run a drop database within a transaction, the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 9:11 am
In what context and where?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 8:25 am
yuvipoy (6/9/2014)
the database restoration will not happen.Data loss is accepted.
So what happens if there's a drive failure? Do you tell the customer 'Tough luck, you've lost everything'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 8:23 am
Ed Wagner (6/9/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 8:22 am
Not possible, because DDL triggers are AFTER triggers. They fire after the action has completed. Any trigger which fired after a restore database had run would not be able to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 9, 2014 at 8:19 am
Viewing 15 posts - 8,791 through 8,805 (of 49,552 total)