Viewing 15 posts - 10,366 through 10,380 (of 49,552 total)
TDE does not meet those requirements. It may be part of meeting them or it may not, but it's not sufficient. It also doesn't stop someone from querying the 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
January 16, 2014 at 1:02 pm
It's SQL Server waiting for the client to accept the results and send an acknowledgement. It's usually the client app, but could be anything from the server to the client...
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 16, 2014 at 1:01 pm
Michael Valentine Jones (1/16/2014)
Using the database backup files to restore somewhere else and looking at the data.
Copying the database data files, attaching to another...
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 16, 2014 at 12:34 pm
New Born DBA (1/16/2014)
Well maybe to protect the data.
From what? What threats is this going to mitigate?
TDE isn't a general 'protect the data', it protects the data from specific...
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 16, 2014 at 11:12 am
TheSQLGuru (1/16/2014)
IIRC explicit drops aren't even honored any longer...
They are, they always have been. Drop a temp table and you can't access it any longer. Essential when testing code before...
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 16, 2014 at 11:03 am
To solve what problem?
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 16, 2014 at 10:56 am
SELECT database_id, object_id, index_id, avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats(9,933578364,5,null, 'limited')
SELECT DB_NAME(9)
SELECT object_name(933578364,9)
What do those return?
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 16, 2014 at 9:31 am
SQL_Surfer (1/16/2014)
It seems like SQL server is leaking memory. I assign 30 GB to sql server memory. If I look at task manager, 30GB of Memory is used.
You told...
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 16, 2014 at 9:28 am
Perry Whittle (1/16/2014)
There is a list of pre requesites that need to be met before you can enable TDE, have you performed these?
Prerequisites including reading up on how you 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
January 16, 2014 at 8:24 am
Shouldn't be noticeable.
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 16, 2014 at 8:15 am
Repeat that code for each temporary table. Or just close the connection
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 16, 2014 at 8:09 am
Yes, it encrypts TempDB as well. The log is part of the database so 'encrypts the database' means encrypts the data files and log file.
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 16, 2014 at 8:08 am
Then all I can suggest is double check that you are looking at the correct server, correct database and correct query. Most common reason I've seen for problems like this...
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 16, 2014 at 8:07 am
As in, from the database you're in, querying FROM sys.indexes where object_id = 933578364?
Is the database you're currently using the one with an ID of 5? The sys.indexes view is...
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 16, 2014 at 7:49 am
How are you checking the index defs in database 5? What query?
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 16, 2014 at 7:42 am
Viewing 15 posts - 10,366 through 10,380 (of 49,552 total)