Viewing 15 posts - 3,676 through 3,690 (of 49,571 total)
Table definitions (as CREATE TABLE statements) and sample data in an easy to use format (INSERT statements) please.
February 3, 2016 at 3:17 am
Please note: 5-year old thread
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?
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...
February 3, 2016 at 2:08 am
jonathan.crawford (2/2/2016)
February 3, 2016 at 2:07 am
jasona.work (2/2/2016)
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...
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.
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...
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,...
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.
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...
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...
February 2, 2016 at 1:39 am
You don't need DECLARE, CONVERT or CAST.
EXEC SimpleGUIDTest '00000000-0000-0000-0000-000000000000'
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
February 1, 2016 at 3:19 pm
Viewing 15 posts - 3,676 through 3,690 (of 49,571 total)