Viewing 15 posts - 5,356 through 5,370 (of 49,571 total)
You need to confirm whether or not what you believe is true, before you start making changes. Otherwise you could waste a huge amount of time making ineffectual changes.
If you...
July 10, 2015 at 4:36 am
Is the query that is timing out doing so because of async network IO, or is that just a high wait on the server?
The sessions that are suspended, what are...
July 10, 2015 at 4:18 am
erics44 (7/10/2015)
proc2 is set outside the catch block
In that case, if anything goes wrong in the statements in proc 1, proc 2 will still execute and commit. If that's what...
July 10, 2015 at 3:57 am
You may want to do some reading on TDE first.
July 10, 2015 at 3:43 am
No, why would you only want proc 2 to be executed if there's an error? Doesn't make much sense and isn't the same as the previous ones.
You need to decide...
July 10, 2015 at 3:43 am
DBCC CheckDB is what you use to check corruption. SQL won't delete data or mangle data in an upgrade process. Corruption comes from hardware problems, usually IO subsystem.
July 10, 2015 at 3:12 am
Koen Verbeeck (7/10/2015)
And yes, I stole the copyright notice from Grant and Gail 😀
But, unlike Grant, didn't ask for permission first....
July 10, 2015 at 2:53 am
In this case, no, because you're naming transactions. Instead the rollback will *fail* and you will be left with an uncommitted transaction that will cause huge problems later.
Stop naming your...
July 10, 2015 at 2:52 am
keshab.basnet (7/10/2015)
is it recommended to do frequent log back up for our scenario.
Yes. Your DR strategy doesn't protect you in the slightest from the accidentally dropped table, or incorrect data...
July 10, 2015 at 2:22 am
Firstly, don't name your transactions. Doing so can lead to errors later on. Naming transactions is pretty much for documentation purposes.
Second, SQL doesn't actually have nested transactions. The syntax looks...
July 10, 2015 at 2:18 am
Joy Smith San (7/9/2015)
So since SQL 2008 doesn't have option to encrypt only DB its both the DB and Backups are encrypted I assume.
I said 2008 doesn't have the ability...
July 9, 2015 at 11:48 pm
They're places to put backups. No performance advantage.
May I suggest you get a new keyboard, since your current one appears to have either a broken shift key or a broken...
July 9, 2015 at 1:39 pm
sindura.pulimamidi1 (7/9/2015)
WHAT IS THE MINIMUM POSSIBLE DATA LOSS?1 HOUR?
1 MINUTE?
10 SECONDS??
Depends on the backups you have and the type of disaster. Anything from all of it to none.
July 9, 2015 at 1:36 pm
DENY SELECT ON dbo.Accounts TO Analytics
The view won't break, because of ownership chaining. As long as the view and the table are owned by the same user (dbo preferably), the...
July 9, 2015 at 1:32 pm
Viewing 15 posts - 5,356 through 5,370 (of 49,571 total)