Viewing 15 posts - 12,661 through 12,675 (of 49,552 total)
HildaJ (6/19/2013)
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
June 19, 2013 at 3:30 pm
Books Online. The RESTORE DATABASE page. I suggest you spend some time reading Books Online on a variety of topics. Maybe also buy a copy of one of the SQL...
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
June 19, 2013 at 2:11 pm
Learner44 (6/19/2013)
I already metioned I am new to this encryption field..
The steps I gave have little to do with encryption, more to do with basic database operations like restoring a...
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
June 19, 2013 at 2:05 pm
Really, you're working with encryption and you either don't know what a certificate is or don't know how to restore a backup on another server?
Leave off the encryption and spend...
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
June 19, 2013 at 1:59 pm
Learner44 (6/19/2013)
But Now I am confused..how I can show him, that database is encrypted and if your restore it won't without proper key.
To prove it won't restore without 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
June 19, 2013 at 1:44 pm
balasaukri (6/19/2013)
Hence please help me to free up space.
Why? SQL Server uses memory for performance reasons, disk access is slow. Why do you want to reduce its memory usage? All...
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
June 19, 2013 at 12:36 pm
If you're not going to answer my questions, I'm not going to help you.
As for the steps to restore a TDE-encrypted database, they're in Books Online.
To prove it won't restore...
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
June 19, 2013 at 12:32 pm
Learner44 (6/19/2013)
Msg 3234, Level 16, State 2, Line 2Logical file 'mydb' is not part of database 'Encry2'. Use RESTORE FILELISTONLY to list the logical file names.
And when you did 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
June 19, 2013 at 11:26 am
bslchennai (6/19/2013)
can we use WITH(NOLOCK) option in select queries for these tables. how it will work.
Will the users be happy if the data that the queries return is inconsistent...
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
June 19, 2013 at 11:24 am
Sai Viswanath (6/19/2013)
Also, could you point out which part of the output has got incorrect structure.
The SELECT *, the fact that it's across a linked server, the lack of a...
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
June 19, 2013 at 11:21 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
June 19, 2013 at 9:02 am
Krishna1 (6/19/2013)
How do I test this. I need to show the diff that log will not get trucated even if we take full back every day.
Create a database, set...
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
June 19, 2013 at 8:59 am
Modest DBA (6/19/2013)
so what you telling me is that due to contention my set up should be as follows...6 CPU machine and 6 LUNS allocated for mdfs.
No, I'm not necessarily...
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
June 19, 2013 at 8:58 am
Because TempDB is prone to allocation contention (contention on the allocation pages in the data file), a contention that is alleviated by having more than one file and because there...
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
June 19, 2013 at 8:43 am
SQLSACT (6/19/2013)
The difference between the elapsed time and the worker time could be because of any wait type, right?
Correct, and you could miss queries that have waited, because of...
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
June 19, 2013 at 8:20 am
Viewing 15 posts - 12,661 through 12,675 (of 49,552 total)