Viewing 15 posts - 5,356 through 5,370 (of 49,552 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...
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
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...
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
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...
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
July 10, 2015 at 3:57 am
You may want to do some reading on TDE 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
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...
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
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.
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
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....
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
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...
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
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...
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
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...
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
July 10, 2015 at 2:18 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
July 9, 2015 at 11:57 pm
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...
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
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...
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
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.
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
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...
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
July 9, 2015 at 1:32 pm
Viewing 15 posts - 5,356 through 5,370 (of 49,552 total)