Viewing 15 posts - 2,131 through 2,145 (of 49,552 total)
Log Reservation.
A transaction MUST always be able to roll back, even if the transaction log is full and can't grow. Since a rollback involves creating and then logging compensating operations,...
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
November 9, 2016 at 9:59 am
As I said in the thread where you asked that (http://www.sqlservercentral.com/Forums/Topic1833167-3739-1.aspx), don't use the largest index to judge log size. Assuming this is an active system, measure the % used...
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
November 9, 2016 at 7:02 am
Don't resize the log based on index size. Size it based on how large it needs to be for your regular operations. Track the used % of the log for...
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
November 9, 2016 at 5:24 am
As was mentioned in the other thread on this same topic, your options here are limited. You want to do a UNION, without using UNION and there isn't an obvious...
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
November 9, 2016 at 3:40 am
There's no join between the two tables, so you are getting a cartesian product, which will indeed result in more rows than you want.
If there's no relation between the two,...
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
November 9, 2016 at 3:08 am
alex.sqldba (11/8/2016)
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
November 8, 2016 at 12:36 pm
It's not that simple.
Casting the float to datetime directly gets you 20161108 days after the 1st of January 1900, which, since 20161108/365.25 leaves us with 55 thousand years, exceeds...
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
November 8, 2016 at 6:56 am
xsevensinzx (11/8/2016)
Oh, I was referring to the Redgate Data Platform Studio.
Sorry, misunderstood. I'll ping Grant and ask him to give you more details
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
November 8, 2016 at 5:56 am
richlion2 (11/8/2016)
Can someone please give me a sensible explanation? Is this a master procedure or within My SQL Server version is 2008 Epxress and also SQL Serv. 11 Enterprise.
IndexOptimize is...
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
November 8, 2016 at 5:56 am
xsevensinzx (11/8/2016)
When one of these thresholds is met, new queries are...
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
November 8, 2016 at 5:44 am
I would recommend, instead of creating one trigger FOR INSERT, UPDATE, DELETE, you create three different triggers. One FOR INSERT (which will be fired only for the inserted rows via...
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
November 8, 2016 at 5:43 am
xsevensinzx (11/8/2016)
Is there actual pricing and licensing information about this product?
Yes. It's Azure so it's cloud 'pay as you use' model. You don't buy licenses, you just pay for...
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
November 8, 2016 at 5:38 am
alex.sqldba (11/8/2016)
Is there a way to backup the file groups excluding the document one, and replace the missing documents one with an empty/trimmed/static version I keep for this purpose?
No.
You can...
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
November 8, 2016 at 5:16 am
Formatted for easier readability:
Edit: why removed?
Can you try a few things?
The same query with the CASTs removed. (you said that works fine)
The same query with the constants replaced with BIGINT...
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
November 8, 2016 at 12:57 am
Then you have a hell of a lot of work to do first, and a lot of reading, and I can almost guarantee you that putting the production DB into...
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
November 7, 2016 at 3:18 pm
Viewing 15 posts - 2,131 through 2,145 (of 49,552 total)