Viewing 15 posts - 6,661 through 6,675 (of 49,552 total)
Brandie Tarvin (1/29/2015)
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
Here's one for everyone. Does anyone have an environment where Enterprise is the production edition and Standard is the Dev / Test version?
That's kinda dumb....
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
January 29, 2015 at 7:53 am
Why do they have to land anywhere?
Why is the 'reward' for being very good at your job to be put into a completely different one? Management is a completely different...
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
January 29, 2015 at 7:46 am
Brandie Tarvin (1/29/2015)
Here's one for everyone. Does anyone have an environment where Enterprise is the production edition and Standard is the Dev / Test version?
That's kinda dumb. Instead of Standard...
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
January 29, 2015 at 7:43 am
Perry Whittle (1/29/2015)
GilaMonster (1/29/2015)
In simple recovery a checkpoint truncates the log.And even then there are drivers behind this, it won't necessarily truncate on every checkpoint
It will truncate on checkpoint. It...
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
January 29, 2015 at 7:38 am
Ed Wagner (1/29/2015)
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
That what will soon be illegal in SQL? (You have an unclear antecedent for the second "that" in your edited comment.)
The omission of the WITH...
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
January 29, 2015 at 7:14 am
Full backups do not truncate the transaction log in any recovery model.
In full and bulk-logged recovery a log backup truncates the log.
In simple recovery a checkpoint truncates the log.
The myth...
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
January 29, 2015 at 7:11 am
Brandie Tarvin (1/29/2015)
That what will soon be illegal in SQL? (You have an unclear antecedent for the second "that" in your edited comment.)
The omission of the WITH on the nolock...
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
January 29, 2015 at 5:32 am
That's not a SQL Server error, so you're doing something somewhere else wrong and getting an OS error.
Go through the link I posted, check each step carefully.
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
January 29, 2015 at 4:38 am
If the *server* (not the master database) is in single user mode then only a single user is allowed, which means you won't be able to use object explorer and...
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
January 29, 2015 at 3:30 am
Huh? Don't understand what you're asking
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
January 29, 2015 at 3:07 am
No, the process for restoring master is to put the *server* into single user mode, not the database.
https://msdn.microsoft.com/en-us/library/ms190679.aspx
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
January 29, 2015 at 3:01 am
Take a new backup of the certificate. If you can't, see my earlier post about changing the certificate.
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
January 29, 2015 at 2:42 am
umarrizwan (1/29/2015)
indexes which are never used by any plan and Gail is right that by last restart of server.
By 'never used', you mean never queried and the underlying table never...
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
January 29, 2015 at 2:27 am
You need the certificate.
The entire point of TDE is that a backup of a TDE protected database cannot be restored to any other server unless that server has the certificate.
If...
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
January 29, 2015 at 1:55 am
rajemessage 14195 (1/29/2015)
1) please tel me how it handels snapshot transactions in database recovery ?
Same as any other other isolation level, uncommitted transactions are rolled back, committed transactions 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
January 29, 2015 at 1:44 am
Viewing 15 posts - 6,661 through 6,675 (of 49,552 total)