Viewing 15 posts - 3,676 through 3,690 (of 49,552 total)
Table definitions (as CREATE TABLE statements) and sample data in an easy to use format (INSERT statements) 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 3, 2016 at 3:17 am
Please note: 5-year old thread
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 3, 2016 at 3:04 am
You've given them names. First and Second in your code example. You can reference them by those names in the last query.
What are you trying to do?
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 3, 2016 at 2:28 am
dxu (2/2/2016)
The interesting thing is I have restored the full back up into another database and I can shrink the log without any problem.
Not at all a surprise, since...
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 3, 2016 at 2:08 am
jonathan.crawford (2/2/2016)
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 3, 2016 at 2:07 am
jasona.work (2/2/2016)
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 3, 2016 at 1:57 am
You can't do an in-place from 32-bit to 64-bit iirc. You'll need to either install a new instance and move the DBs across or uninstall the old and install the...
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 3, 2016 at 1:55 am
Remove the first two maybe? If you don't need their results, don't put them in the procedure.
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 3, 2016 at 1:53 am
dajonx (2/2/2016)
So once I restore the backup, I can just change the compatibility to 130 and that should be it, right?
Should be it to start...
and starting the testing now (on...
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 2, 2016 at 9:20 am
curious_sqldba (2/2/2016)
Very interesting, during PASS 2015 a very senior and well know MVP told us that you could upgrade only up to 2 editions.
Replication has a 2-version limit. Upgrades,...
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 2, 2016 at 9:19 am
Yes, but it would be easier to script out the linked servers before dropping them and keep the script somewhere safe.
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 2, 2016 at 4:09 am
DamianC (2/2/2016)
Won't resizing down to 1MB then growing back to 80GB every night slow the process down (especially with 100MB autogrow) and, from what I have read, cause serious fragmentation?
Yes.
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
February 2, 2016 at 3:14 am
Run checkDB to be safe.
If it's just the log, the usual solution to that is to, during a maintenance window:
Switch the DB to simple recovery
Shrink the log file to 0
Resize...
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 2, 2016 at 1:39 am
You don't need DECLARE, CONVERT or CAST.
EXEC SimpleGUIDTest '00000000-0000-0000-0000-000000000000'
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 1, 2016 at 3:31 pm
You can, it'll work fine.
Or, if there was a differential backup at midnight, you could restore the 9pm full, the midnight diff and the logs until 1:15
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 1, 2016 at 3:19 pm
Viewing 15 posts - 3,676 through 3,690 (of 49,552 total)