Viewing 15 posts - 1 through 15 (of 307 total)
SSMSBoost has a version that's compatible with SSMS 2016 with a formatter that can handle RESTORE statements.
It works so much better than any of the paid options that...
November 23, 2016 at 2:55 am
Yep, I think you're right. The table's a heap and has a unique nonclustered PK which is being referenced in the WHERE clause of the UPDATE statement.
I disabled the...
September 13, 2016 at 9:57 am
Actual plan attached.
Looking at the details for the TOP and SEEK operators, only one row is found so you're right that the TOP isn't removing any rows but I can't...
September 13, 2016 at 4:53 am
I've only got an estimate plan at the moment as I'm pulling the statements out of the deadlock xml.
I'll see if I can grab an actual now.
September 13, 2016 at 4:33 am
Yes, no problem. sqlplan file attached.
September 13, 2016 at 4:19 am
Nice thanks for that. Will be checking that out!
July 27, 2016 at 2:29 am
Thanks, it's not the end of the world. It was just a really handy feature that I'd gotten used to and was hoping that there was another product out that...
July 26, 2016 at 10:28 am
They're just standard backup/restore statements. I like to generate the statements by using the gui and then give them a once over before running.
RESTORE DATABASE [TESTDB] FROM DISK...
July 26, 2016 at 10:09 am
Downloaded and installed first the express dbforge version and then the full trial but unfortunately it doesn't work for backup/restore statements either.
July 26, 2016 at 9:49 am
Thanks, will give the dbForge trial a whirl
I'm not gonna go for the Red Gate product as even though it does have more features I really just want a code...
July 26, 2016 at 9:33 am
Cool! Will wait and check that out when it becomes available.
July 19, 2016 at 4:02 am
It's good but I can't see how to get it to format BACKUP/RESTORE statements.
I like to generate the script with the SSMS GUI, script it out and then format it...
July 19, 2016 at 3:56 am
Had a look at SQL prompt, bit pricey for a formatter isn't it?
I don't really want to use an online tool, not really that convenient.
It's a shame as the...
July 19, 2016 at 12:08 am
Thanks Gail. Yep was thinking that but got asked about it and I couldn't find anything on the web about it
April 4, 2016 at 8:32 am
Ha ha, I'm guessing that's a no then? 🙂
If I get to the bottom of this I'll post what I find.
March 30, 2016 at 6:48 am