Viewing 15 posts - 256 through 270 (of 49,552 total)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 21, 2018 at 8:54 am
Please note: 5 year old thread.
Please post new questions in a new thread. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2018 at 7:09 am
Short of asking people, no.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 13, 2018 at 5:28 am
What's the data type of the State column?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2018 at 8:43 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2018 at 2:45 am
No reasons. I recommend 2017.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2018 at 2:43 am
Rather upgrade to SQL 2017, not 2016..
The work in testing and upgrading will be the same.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 7, 2018 at 4:45 am
Viewing 15 posts - 256 through 270 (of 49,552 total)