Viewing 15 posts - 12,616 through 12,630 (of 49,552 total)
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 21, 2013 at 1:31 am
Easiest thing, go look at the Microsoft exam certification page where they describe all the exams, list all the exam paths and all the certifications.
I think it's 3, but I'm...
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 21, 2013 at 12:52 am
Maybe, maybe not. Depends on what the root cause is.
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 21, 2013 at 12:41 am
mister.magoo (6/20/2013)
Not disagreeing, just expanding on your answer for those pedants among me. 😛
*sigh*
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 20, 2013 at 5:47 pm
If you're regularly moving millions of rows from one table to another, have you considered partitioning? One of its main features is exactly that.
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 20, 2013 at 5:33 pm
No, not at all.
They're two ways of stating the same thing, they perform and execute identically.
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 20, 2013 at 4:56 pm
Shaira (6/20/2013)
Do the transaction logs pickup where they ended? Don't they realize somethings missing :w00t:?
You mean your log backups? No, they won't just pick up again, yes, they...
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 20, 2013 at 4:55 pm
WolfgangE (6/20/2013)
In...
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 20, 2013 at 11:31 am
Abu Dina (6/20/2013)
Basically you use it so that you don't break the backup chain so go for it!
You mean 'don't reset the differential base', because that's all that a normal...
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 20, 2013 at 10:48 am
Look at the definition of the views (sp_helptext). Check the queries, what do they do?
Have you updated statistics since upgrading? Have you rebuilt indexes since upgrading.
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 20, 2013 at 10:28 am
Check the definition of the views. What filters are on the selects?
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 20, 2013 at 10:20 am
Jeremy-475548 (6/20/2013)
1. Will the 32 bit version of SQL Server still try to allocate memory over the 4 GB limit even though it's a 32 bit process?
Not without AWE 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 20, 2013 at 10:05 am
A restore will always recreate the database in exactly the same state it was at the time of backup. If the restore restored 4 tables, then the database at 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 20, 2013 at 10:02 am
Could you run the exact command I gave you please?
I don't have the time or patience to read over thousands of lines of the x rows in y pages...
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 20, 2013 at 9:58 am
Please note: 4 year old thread.
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 20, 2013 at 8:47 am
Viewing 15 posts - 12,616 through 12,630 (of 49,552 total)