Viewing 15 posts - 3,061 through 3,075 (of 22,202 total)
I do love me some SQL Prompt from Redgate Software. It does more than just format the code. It also provides type-ahead, supports Azure SQL Database and Managed...
August 3, 2018 at 4:25 am
Check the links in my signature. The book on execution plans will help.
August 2, 2018 at 2:26 pm
Jeff Moden - Thursday, August 2, 2018 8:54 AMTLDR: It depends
Fixed that for you.
Ha!
August 2, 2018 at 9:02 am
August 2, 2018 at 8:49 am
So a little confusion here. Foreign keys should be bound to unique constraints/unique indexes. Now, whether that unique index is a clustered index or a nonclustered index, that's a different...
August 2, 2018 at 5:02 am
Another issue that is possible is that you've crossed a threshold on the data or in the statistics that has resulted in a change to the execution plan which is...
August 2, 2018 at 4:53 am
And, since you're on 2016, you can take advantage of the query store to force plans. It won't help now, since the upgrade is done, but in the future, the...
August 2, 2018 at 4:49 am
August 2, 2018 at 4:36 am
Thank you so much for the feedback--it's incredibly helpful. One more question, only because...
August 1, 2018 at 12:46 pm
July 31, 2018 at 12:49 pm
July 31, 2018 at 8:33 am
July 31, 2018 at 7:44 am
Ok, Grant. Let me make sure I understand what you're suggesting...
July 31, 2018 at 7:44 am
It's technically unsupported, but you could use sp_msforeachtable to walk through and do what you want. Here's a link with examples.
July 31, 2018 at 6:17 am
Viewing 15 posts - 3,061 through 3,075 (of 22,202 total)