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...
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...
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...
August 15, 2017 at 11:49 am
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...
July 7, 2017 at 8:59 am
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...
June 29, 2017 at 9:43 am
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...
June 28, 2017 at 8:34 am
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.
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...
June 22, 2017 at 11:06 am
Do you understand why it worked? And why Luis's code worked and mine didn't?
June 20, 2017 at 11:23 am
Viewing 15 posts - 1,576 through 1,590 (of 2,356 total)