Viewing 15 posts - 6,661 through 6,675 (of 49,571 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....
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...
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...
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...
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...
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...
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...
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.
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...
January 29, 2015 at 3:30 am
Huh? Don't understand what you're asking
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.
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.
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...
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...
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...
January 29, 2015 at 1:44 am
Viewing 15 posts - 6,661 through 6,675 (of 49,571 total)