Viewing 15 posts - 1,576 through 1,590 (of 2,356 total)
If you decide to use an availability group, you may need Enterprise edition. Standard edition only supports one database in an AG, so if you have more then one database...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 23, 2017 at 8:09 am
Re-visiting this thread, based upon doing some more evaluating of various hardware and VM's
How many SCSI controllers are configured in this machine? And, what type are they?
We...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 16, 2017 at 2:15 pm
What do you need to do?
If you want a stand-by copy of the database for DR, and are using log shipping, then the database will indeed be...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 15, 2017 at 11:49 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 12, 2017 at 8:14 am
No. Changing the data on the subscriber is not an uncommon requirement.
The issues you may face would be that transactions from the publisher would fail. Identity fields are good...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 7, 2017 at 8:59 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 5, 2017 at 10:20 am
Without the actual schema, and some sample data, it's a bit difficult to figure out exactly what may be going on.
I created a single column table with a...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 29, 2017 at 9:43 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 28, 2017 at 12:48 pm
SELECT DISTINCT *
INTO #TempTable
FROM OriginalTable
TRUNCATE OriginalTable
INSERT INTO OriginalTable
SELECT * FROM #TempTable
Not knowing the structure of the table, but you may need...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 28, 2017 at 8:34 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 28, 2017 at 7:55 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 24, 2017 at 5:45 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 23, 2017 at 12:03 pm
Well, that seems to have done the trick. Thanks!
As soon as I read it, I realized that I never added this to the GPO.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 23, 2017 at 12:00 pm
I'm curious about the time it take for the query to complete if it is run in SQL Management Studio. I think the place to start is to make sure...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 22, 2017 at 11:06 am
Do you understand why it worked? And why Luis's code worked and mine didn't?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 20, 2017 at 11:23 am
Viewing 15 posts - 1,576 through 1,590 (of 2,356 total)