Viewing 15 posts - 9,256 through 9,270 (of 49,552 total)
Jagadeesh Chowdary (4/19/2014)
>Stop the SQL Service
>>Copy the MDF and LDF file and place in other...
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
April 19, 2014 at 11:52 am
PDW is different and you do have to create stats manually, but that's specific to PDW and not something you typically do on normal SQL databases. You'll need to read...
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
April 18, 2014 at 12:24 pm
Eduardo Olivera (4/17/2014)
What if I change the databases to simple recovery mode and then reboot?
You break your log chain and sit with potentially a many hour recovery after 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
April 18, 2014 at 7:35 am
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
April 18, 2014 at 7:29 am
No, that's exactly the same as the delete without a transaction. It's a single statement, so it's implicitly in its own transaction.
Delete in batches, not in a transaction and have...
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
April 18, 2014 at 7:29 am
You can try that. You may have the entire DB offline for hours or days as a result.
The approximation is just that. An approximation.
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
April 17, 2014 at 11:33 am
If the view has an index, SQL may not need to go to the base tables at all.
Bear in mind there are a massive set of restrictions around indexed views....
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
April 17, 2014 at 7:37 am
The Associated_object_id is not an object ID, it's too big. It's an allocation unit ID (or HoBT). See sys.partitions and/or sys.allocation_units
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
April 17, 2014 at 7:34 am
Then it's probably just chugging along. Rollbacks usually take longer than the initial changes did.
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
April 17, 2014 at 7:27 am
Kick all other users off the server will help. :hehe: 🙂
Check what the rollback is waiting for (wait type in sys.dm_exec_requests) first.
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
April 17, 2014 at 4:51 am
Unfortunately the only thing you can do with a rollback is wait. It has to finish.
Don't restart SQL or the rollback will just start over from the beginning with 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
April 17, 2014 at 4:38 am
Divine Flame (4/17/2014)
I have written something on it. I may submit it today.
Cool, I'll scratch it off my to-write list then.
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
April 17, 2014 at 3:52 am
Schema changes are in the default trace, though only for a while. It keeps 5 files of 20MB each. On some servers I've seen that overwritten within 4 hours.
Otherwise, unless...
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
April 17, 2014 at 3:29 am
What do you mean by 'priority'? They can run concurrently.
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
April 17, 2014 at 12:25 am
That makes sense.
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
April 16, 2014 at 4:43 pm
Viewing 15 posts - 9,256 through 9,270 (of 49,552 total)