Viewing 15 posts - 526 through 540 (of 561 total)
chandan_jha18 (9/11/2012)
Mirroring solution will work fine to minimize the downtime but please make sure that you have exact versions of sql server with exact level of service pack.Thanks
Chandan
Good point.
But I...
September 11, 2012 at 9:35 am
Well,
I am not planning (and certainly, will not) to change a database that is not in suspect state and fully operational to "emergency mode" just to check.
What I will do(only...
September 11, 2012 at 7:57 am
Perry Whittle (9/10/2012)
September 10, 2012 at 2:15 pm
PiMané (9/7/2012)
It's a good practice to split the data and indexes into separate filegroups so the hardware can do multiple reads at the same time. Also partitioning a table with...
September 8, 2012 at 6:14 pm
More on the same,
Remember, Google is your friend! 😉
SQL Server 2008 failover cluster rolling patch and service pack process
September 8, 2012 at 5:57 pm
To patch (MS-SQL)
You failover or move the resources to other node, let's call it B. You run the service pack or whatever on Node A. At that point, A is...
September 8, 2012 at 5:53 pm
I do not believe it is possible for you to move the server objects (SSIS packages, customized jobs, etc) but you may re-create those (prior migration) and test. Actually,...
September 8, 2012 at 5:47 pm
Robert Davis (9/6/2012)
That would seem to be a failure creating the database snapshot that DBCC uses. You need to investigate why the database snapshot is failing.
Hi Robert,
You mean, the DBCC...
September 6, 2012 at 6:21 am
yu.he (9/5/2012)
You need to modify the system created Stored Proc sp_MSupd_MyTable in the subscriber database by remove the key columns from updating.Hope this will help.
Thanks,
Can you elaborate more, please ......
September 5, 2012 at 2:18 pm
john 50727 (8/20/2012)
In my opinion, the bigger question...
August 20, 2012 at 1:02 pm
By the way,
The table in question has a little bit more than 20 million rows. It's 2.7GB with 4GB in Indexes.
🙂
August 20, 2012 at 9:31 am
J Livingston SQL (8/20/2012)
sql-lover (8/20/2012)
MysteryJimbo (8/19/2012)
August 20, 2012 at 9:12 am
MysteryJimbo (8/19/2012)
August 20, 2012 at 9:00 am
-Performance
-Disk's space (the whole db is over 1TB now)
Reducing the table will allow me to save lot of space and RAM. The reports that take almost an hour, will run...
August 18, 2012 at 10:59 am
Hmmm...
I am not working today, but several GBs ... over of 10 millions rows, off top of my head.
I do not remember the numbers exactly, but it is...
August 18, 2012 at 10:37 am
Viewing 15 posts - 526 through 540 (of 561 total)