Viewing 15 posts - 1,126 through 1,140 (of 5,394 total)
As far as I know, increasing the width of the column is a metadata only operation and doesn't require updating all the rows.
Reducing the width of the column does.
October 17, 2014 at 3:50 am
OK, what do you want to compare with those two columns? Current date? A parameter?
October 17, 2014 at 2:48 am
Where are FromDate and ToDate?
One of the two tables?
Parameters?
You're not providing much information: could you please read the first article linked in my signature line? You'll find out how to...
October 17, 2014 at 1:58 am
Tell us something more. What's the logic behind?
If it relies on the order of the rows in the table, there has to be a way to explicitly extract it from...
October 16, 2014 at 3:34 am
INSTEAD OF triggers run instead of the code that fired the trigger, which means that the table is not touched unless explicitly defined in the trigger code. I don't see...
October 16, 2014 at 3:12 am
Eirikur Eiriksson (10/16/2014)
It is likely that a server wide setting of MAXDOP = 1 would be helpful in your case as CXPacket waits are high
Let me politely disagree. Setting MAXDOP...
October 16, 2014 at 2:39 am
In order to start a distributed transaction, you need to configure the Distributed Transaction Coordinator (DTC).
See here for instructions: http://support.microsoft.com/kb/2027550/en-us
October 16, 2014 at 1:52 am
If you want a snapshot of the database at a given time, transactional replication is not for you.
If you want data to be in sync with the publisher, it might...
October 15, 2014 at 9:31 am
Steve Jones - SSC Editor (10/15/2014)
We do not grant rights for users. Only roles. Use roles. Please. Roles.
Pretty please.
And the Gui is a mess. Use...
October 15, 2014 at 9:28 am
pharmkittie (10/15/2014)
...she has the personality of a ferret on double espresso...
😀
Really, trust me... wipe the machine, you'll thank me later.
October 15, 2014 at 9:28 am
I would wipe the machine completely.
October 15, 2014 at 7:23 am
COLLATE DATABASE_DEFAULT is the only way to make it work with all possible collations. The other way is an explicit collation name, but the effect is the same as DATABASE_DEFAULT.
Other...
October 15, 2014 at 7:11 am
Copy only won't work, you'll end up with holes in your log chain.
See http://spaghettidba.com/2014/01/22/copy_only-backups-and-log-shipping/. It's log shipping, but the idea is the same.
As far as arguments to convince them:
Mirroring is...
October 15, 2014 at 7:06 am
John Mitchell-245523 (10/15/2014)
October 15, 2014 at 5:12 am
What do you mean "main file"?
Snapshot replication may be what you're looking for.
October 14, 2014 at 3:39 pm
Viewing 15 posts - 1,126 through 1,140 (of 5,394 total)