Viewing 15 posts - 361 through 375 (of 4,745 total)
SCOM and biztalk are not the same thing. I have never seen a recommendation to to set maxdop to 1 for SCOM, so I would not do that.
SCOM is an...
January 17, 2014 at 8:26 am
if you use shrinkfile rather than shrinkdatabase you can specify whatever size you want. Limitation is amount of data in data file and whatever the size of your first 2...
January 17, 2014 at 3:13 am
without auditing set up then no, but that action would be in the default trace under eventclass object:altered, object type DB.
It does not tell you exactly what was done, but...
January 16, 2014 at 9:59 am
Express12 (1/16/2014)
January 16, 2014 at 5:20 am
MysteryJimbo (1/16/2014)
Express12 (1/15/2014)
We realize that if we failover to the D/R data center, our SQL server name in our connection strings will need to change.
Not necessarily. You can add...
January 16, 2014 at 5:13 am
shrinking of the log file does not affect index fragmentation, only data file shrinking does that.
Shrinking of the log file is usually bad as it then has to grow again...
January 16, 2014 at 5:07 am
Initial size in SSMS is somewhat of a misleading term. for a user database it changes in SSMS when the file size changes, for tempdb it does not.
The DB only...
January 16, 2014 at 5:01 am
as this has had no replies I must assume that either
a) it is a solution looking for a problem
b) not enough people are on SQL2012 for long enough to...
January 10, 2014 at 4:14 am
I had this situation a few years back on a database (2005 standard) that has now reduced dramatically in size but at its peak was over a terabyte, mostly consisting...
January 10, 2014 at 3:40 am
surprised indexdefrag even works
how much log does the reorganise use? the DB should at least checkpoint when the log gets to 70% full. Does dbcc opentran show the reorganise as...
January 9, 2014 at 10:20 am
because the distributor does not contain the actual data. Distributor and publisher are often the same server as well.
January 9, 2014 at 10:06 am
ricardo_chicas (1/9/2014)
January 9, 2014 at 10:04 am
I'd be loathe to drop a PK constraint on an active system and the OP specified this is a 24/7 system so downtime is an issue.
January 9, 2014 at 9:41 am
recommended way is
distributor
publisher
subscriber
disable replication jobs whilst applying to distributor
replication will automatically be suspended when doing the publisher and subscriber
January 9, 2014 at 9:18 am
Viewing 15 posts - 361 through 375 (of 4,745 total)