July 30, 2014 at 2:18 pm
A vendor's help desk provided us with this stellar support.
“You can let your DBA know that our databases must be set to “Simple” logging and they must be shrunk AND Repaired regularly – especially with the heavy use y’all give them.“
SMH...
July 30, 2014 at 2:34 pm
Zubius (7/30/2014)
A vendor's help desk provided us with this stellar support.“You can let your DBA know that our databases must be set to “Simple” logging and they must be shrunk AND Repaired regularly – especially with the heavy use y’all give them.“
SMH...
What? And what if your business requires point in time recovery as part of its recovery processes? Simple recovery model won't give you that.
July 30, 2014 at 2:36 pm
Flash from the Access database passed :sick:
😎
July 30, 2014 at 2:40 pm
WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 30, 2014 at 2:46 pm
Don't forget to use NOLOCK hints on all your queries and never ever run DBCC CHECKD, update statistics or rebuild indexes. You might encounter a lot of objects locked during this operations.
:hehe:
PS. Just to make it safe for anyone lurking in here, this is just humor.
July 30, 2014 at 2:47 pm
Alvin Ramard (7/30/2014)
WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:
The one that is shrinked regularly?
July 30, 2014 at 2:55 pm
Luis Cazares (7/30/2014)
Alvin Ramard (7/30/2014)
WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:The one that is shrinked regularly?
Guess shrinked is the simple mode and shrunken is the full recovery mode
😎
July 30, 2014 at 3:01 pm
Eirikur Eiriksson (7/30/2014)
Luis Cazares (7/30/2014)
Alvin Ramard (7/30/2014)
WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:The one that is shrinked regularly?
Guess shrinked is the simple mode and shrunken is the full recovery mode
😎
Go ahead, make fun of my lousy english 😛
Actually, that might help me to remember the correct form.
July 30, 2014 at 3:43 pm
Luis Cazares (7/30/2014)
Eirikur Eiriksson (7/30/2014)
Luis Cazares (7/30/2014)
Alvin Ramard (7/30/2014)
WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:The one that is shrinked regularly?
Guess shrinked is the simple mode and shrunken is the full recovery mode
😎
Go ahead, make fun of my lousy english 😛
Actually, that might help me to remember the correct form.
Which form? The first normal form? 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 30, 2014 at 4:32 pm
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 30, 2014 at 4:35 pm
SQLRNNR (7/30/2014)
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.
From one particular vendor, heavily paraphrased for clarity: "We implemented horrible ORM practices so we update every record everywhere every time you update a single attribute in a table four levels down. Due to this, our log files explode inside of an hour. Please don't have any chance of recovering your data because this is the standard we've chosen. Do differential backups hourly if you're concerned. Have a nice day."
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 30, 2014 at 4:39 pm
Evil Kraig F (7/30/2014)
SQLRNNR (7/30/2014)
Sadly I have heard that same recommendation from more than one vendor and it is even printed in some vendor documentation for databases on SQL Server.From one particular vendor, heavily paraphrased for clarity: "We implemented horrible ORM practices so we update every record everywhere every time you update a single attribute in a table four levels down. Due to this, our log files explode inside of an hour. Please don't have any chance of recovering your data because this is the standard we've chosen. Do differential backups hourly if you're concerned. Have a nice day."
That sounds like the Vendor for one my current clients.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 30, 2014 at 4:39 pm
Ima LMAO at the responses here.. Thanks!
July 31, 2014 at 4:38 am
Zubius (7/30/2014)
A vendor's help desk provided us with this stellar support.“You can let your DBA know that our databases must be set to “Simple” logging and they must be shrunk AND Repaired regularly – especially with the heavy use y’all give them.“
SMH...
That's lovely. And have you put the vendor into the on call rotation so that they can take part in the entertaining event that your first disaster recovery test will be? I sure would.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2014 at 4:59 am
I love it! Always compact and repair your SQL Server databases :-D!
Viewing 15 posts - 1 through 15 (of 35 total)
You must be logged in to reply to this topic. Login to reply