Viewing 15 posts - 4,921 through 4,935 (of 39,740 total)
In case you don't see it, Steve added a decimal to 100.
I do that as 100.0, so the decimal is not missed.
August 27, 2018 at 8:54 am
Shouldn't the knight be in front of the monitors, to defend them?
August 27, 2018 at 8:43 am
August 27, 2018 at 8:40 am
My guess is 1. There is likely some large customer that wanted either their really poor OLTP system to handle 200+ keys, or there's a DW that needs this and...
August 27, 2018 at 8:36 am
Correct. You could have set up log shipping with a backup and never had a backup taken, so log shipping would not work. If log shipping is working, those are...
August 26, 2018 at 3:40 pm
August 25, 2018 at 7:12 am
What's the use here? How often are things updated? Certainly you have duplicate data in that there are a large percentage of M and F in there, so you could...
August 24, 2018 at 3:22 pm
If you look closely, it does do a count, but it qualifies the count in a way that results in scanning every row.
August 24, 2018 at 3:10 pm
Keep in mind as well that despite any ordering in the clustered index, you might not get rows back in that order. If there is parallelism or the engine finds...
August 24, 2018 at 3:08 pm
Apologies, I dont' have time to dig in, but this might help: http://www.sqlservercentral.com/articles/Dynamic+SQL/131473/
August 24, 2018 at 1:04 pm
August 24, 2018 at 12:16 pm
Oh I'm planning too!
At least three authors whose work I enjoy will be...
August 24, 2018 at 10:30 am
August 24, 2018 at 10:18 am
Since clusters can be used to upgrade, I think you can certainly patch one side to a new sp/cu and it will continue to work. You can also upgrade some...
August 24, 2018 at 10:16 am
Viewing 15 posts - 4,921 through 4,935 (of 39,740 total)