Viewing 15 posts - 256 through 270 (of 49,571 total)
March 21, 2018 at 8:54 am
Please note: 5 year old thread.
Please post new questions in a new thread. Thanks
March 21, 2018 at 8:34 am
No idea about the SSIS.
Availability groups cannot be set up between different versions.
And please, test carefully before you upgrade production.
March 21, 2018 at 8:33 am
Just noticed the deadlock graph is Excel. I don't like downloading unknown spreadsheets, and Excel mangles the data as it is.
Can you attach either the deadlock graph (.xdl) or...
March 15, 2018 at 4:19 am
sambartick 90616 - Wednesday, March 14, 2018 7:44 AMwhen you have a second to confirm your theory by checking the deadlock graph.
Nothing...
March 14, 2018 at 8:17 am
I haven't looked at the deadlock graph as I have a meeting in a couple minutes, but updates absolutely do take X locks.
The update will initially take U...
March 14, 2018 at 7:09 am
Short of asking people, no.
March 14, 2018 at 4:07 am
If you're going to switch to simple recovery, don't bother taking log backups first. Just switch to simple, and then shrink the log to a sensible size.
Just keep...
March 13, 2018 at 10:15 am
If the database is in full recovery (almost certainly) then the log gets retained until a log backup is taken. Not a full backup, not a differential, a log. This...
March 13, 2018 at 7:46 am
adiedler - Tuesday, March 13, 2018 4:10 AMHello,
Personally I feel bad about to use subselects in queries
Why?
March 13, 2018 at 5:28 am
Look at the queries, make sure they're efficient. Look at the indexes, make sure that they support the queries
If SQL's locking at the table level then either it can't...
March 8, 2018 at 2:45 am
No reasons. I recommend 2017.
March 8, 2018 at 2:43 am
Rather upgrade to SQL 2017, not 2016..
The work in testing and upgrading will be the same.
March 7, 2018 at 4:59 am
Compatibility is just for the query optimiser/query processor when executing query features that have changed across the versions. It's nothing more than that.
March 7, 2018 at 4:45 am
Viewing 15 posts - 256 through 270 (of 49,571 total)