Viewing 15 posts - 6,541 through 6,555 (of 49,552 total)
No.
When you restored, you overwrote the old DB. Anything in there is gone, unless there was a full or differential backup taken between the times the user made the changes...
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
February 17, 2015 at 3:13 am
Because, for some reason, the log file (the .ldf file) is not accessible to SQL Server. Without a pile more information, that's about all that can be said
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
February 17, 2015 at 1:51 am
You can use the server-side trace feature. Express may not have the profiler GUI, but it's still got the trace feature. You'll just have to write up your own trace...
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
February 17, 2015 at 1:49 am
Anyone going to be at SQL Sat Vienna? It's the Saturday before SQLBits.
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
February 17, 2015 at 1:44 am
No. Replication allows for different indexes, different procedures/views, but the tables should be the same structure.
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
February 17, 2015 at 1:35 am
You have the advantage of me then, since I can't test.
Lowell's query is much what I would write if I was writing a query blind (no tables, no data) 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
February 16, 2015 at 6:24 am
If you don't want a tested solution, cool, your choice.
Look at Row_Number and the partition by clause, you can then filter on that value to get just the highest. Should...
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
February 16, 2015 at 6:16 am
Table definitions (as CREATE TABLE statements), sample data (as INSERT statements) and expected results please.
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
February 16, 2015 at 5:45 am
No, it won't block users, but it will slow things down and you will need to rebuild indexes afterwards and that will block users (unless it's an online rebuild)
If 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
February 16, 2015 at 5:03 am
The first, you can check in the shrink dialog, the second there's no way to determine
First however, why are you shrinking the database?
Unless you've just done some major archiving or...
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
February 16, 2015 at 4:34 am
Backup/restore strikes me as the easiest solution.
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
February 16, 2015 at 4:13 am
I hate seeing that in queries.
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
February 16, 2015 at 4:12 am
TheSQLGuru (2/13/2015)
GilaMonster (2/13/2015)
TheSQLGuru (2/12/2015)
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
February 16, 2015 at 2:52 am
There's no 'unless'. TDE protects data at rest only, it only prevents you from restoring or attaching the database to an instance without certificates. Nothing else.
What's the ultimate goal here,...
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
February 16, 2015 at 2:49 am
On SQL 2005 (this forum), no.
On SQL 2012, no.
On SQL 2014, yes.
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
February 16, 2015 at 2:45 am
Viewing 15 posts - 6,541 through 6,555 (of 49,552 total)