Viewing 15 posts - 3,466 through 3,480 (of 39,726 total)
This is one reason I dislike many natural keys as PKs.
I don't understand how this follows from the discussion.. First, there's not a whole lot of cases where there...
August 21, 2019 at 3:26 pm
If you are doing updates, then SSIS works great. If this is a full migration each time, there is the SQL Server Migration Assistant that works well. A number of...
August 21, 2019 at 3:21 pm
A lesson from The Phoenix Project. No one should be above others. You might know more, but you don't get to break rules.
August 21, 2019 at 3:18 pm
Glad you enjoyed it. I missed it when retrying it today as well.
August 21, 2019 at 3:16 pm
You alter the key to use the new server certificate.
August 20, 2019 at 7:53 pm
The data could be structured differently, different amounts on pages, so reclaiming space might end up looking different later. Check fillfactor and any other config differences as well. Might be...
August 20, 2019 at 2:49 pm
It should still work. Was the data the same? The cleantable should rebuild the table and recover space.
August 20, 2019 at 2:48 pm
Which Microsoft page? There are differences in editions, so you need to know that. If you use developer, free, you can't disable telemetry. That's the price of the edition. For...
August 20, 2019 at 2:45 pm
I'll ping Mike for updated images.
August 20, 2019 at 2:22 pm
Hire one that doesn't open the ransomware ones.
NO idea of the details, but I do worry about a manager covering their own self-interest by firing a staffer. Could be justified,...
August 20, 2019 at 2:18 pm
Have you tried doing the snapshot restore WITH STATS?
Never had anyone worry about this, and I can't seem to find out if this is tracked. I'd have thought dm_exec_requests had...
August 20, 2019 at 2:14 pm
I'm guessing you need to determine the length of the number and not the value? If so, is the xxx the pattern you can use or are you using this...
August 20, 2019 at 2:06 pm
It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")
I'm assuming by now congratulations are...
August 20, 2019 at 1:54 pm
Viewing 15 posts - 3,466 through 3,480 (of 39,726 total)