Viewing 15 posts - 1 through 15 (of 73 total)
A fair point about the complexity determining what is the best solution. I can try to give you more clarity on that, but ultimately it would probably be easier for...
January 7, 2019 at 3:11 pm
Thanks for the write-up Evgeny. Here's a couple of things we've found with our system related to PKs. They don't apply in every case so as usual, everything depends on the...
December 27, 2018 at 7:59 am
Iwas Bornready - Friday, January 13, 2017 9:26 AMI think we are safer just encrypting the data in production.
Encrypting data in production and...
January 13, 2017 at 10:22 am
drew.allen (12/5/2016)
Have you...
December 8, 2016 at 9:32 am
Interesting. I've never seen that method of range seeking on GUIDs and I'm not quite sure I follow what you've posted. Can you post a short example? These GUIDs are...
December 7, 2016 at 10:07 am
Thank you for taking the time respond, but this thread has kind of gotten way off topic. I originally just wanted to know why the optimizer wasn't picking up the...
December 7, 2016 at 9:29 am
Thanks for the suggestions guys. I'll try them out and see if either of them makes a difference.
December 6, 2016 at 7:26 am
drew.allen (12/5/2016)
Have you...
December 5, 2016 at 11:40 am
2) Speaking of blocking, this type of operation REALLY needs to be done against an index that you get a SEEK plan on ALWAYS and NEVER escalates to a table...
December 5, 2016 at 11:29 am
drew.allen (12/5/2016)
Have you...
December 5, 2016 at 11:20 am
The understand that I could replace the variable, but the reason it was there in the first place was because there were multiple tables of relatively the same size involved...
December 5, 2016 at 10:04 am
Thank you for the link. The problem was schema qualification. As soon as I schema qualified the sequence in the constraint, everything works beautifully.
April 28, 2016 at 7:41 am
Because I need to be able to bulk generate IDs in the middle tier layer and use them prior to actually batch saving the data. I'm batch processing large numbers...
April 7, 2016 at 12:45 pm
After you do your clicking in the properties windows, can't you just generate the SQL script for what you did using the button at the top instead of clicking OK?
April 7, 2016 at 12:40 pm
Have you tried using extended events? Or are you looking for historical information that a new extended events session wouldn't catch?
March 28, 2016 at 2:21 pm
Viewing 15 posts - 1 through 15 (of 73 total)