Viewing 15 posts - 2,131 through 2,145 (of 49,571 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,...
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...
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...
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...
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,...
November 9, 2016 at 3:08 am
alex.sqldba (11/8/2016)
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...
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
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...
November 8, 2016 at 5:56 am
xsevensinzx (11/8/2016)
When one of these thresholds is met, new queries are...
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...
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...
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...
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...
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...
November 7, 2016 at 3:18 pm
Viewing 15 posts - 2,131 through 2,145 (of 49,571 total)