Viewing 15 posts - 7,186 through 7,200 (of 18,926 total)
Clustering and load balancing.
Have 1000 servers. Take 1 of them down for maintenance and noone will ever know.
The same can be done with only 2 servers assuming 1 server...
February 8, 2011 at 7:28 am
That's exactly why DBCC CLEANTABLE was created.
Look it up in BOL before using it.
February 8, 2011 at 7:25 am
Yes you can skip the checkdb it if you don't care about that database and its data.
For reindex see this script : http://sqlfool.com/2010/04/index-defrag-script-v4-0/%5B/url%5D
I'd never run checkdb unattended with auto repair....
February 8, 2011 at 7:24 am
PaulB-TheOneAndOnly (2/7/2011)
Oracle documentation is free so, when in doubt RTFM 😉
And I thought BOL was huge!!! :w00t:
February 7, 2011 at 11:00 am
February 7, 2011 at 9:14 am
GSquared (2/7/2011)
GilaMonster (2/7/2011)
SuperDBA-207096 (2/7/2011)
February 7, 2011 at 8:46 am
rockingadmin (2/7/2011)
i want to concatenate rows based on group of values in sqlserver 2000. from sqlserver 2005, we can use it in many ways like XPATH,CTE...
February 7, 2011 at 6:33 am
mw112009 (2/4/2011)
I just ran the script against another database to see how it worked.
This is not the real database that is giving me...
February 4, 2011 at 11:03 am
mw112009 (2/4/2011)
mw112009 (2/4/2011)
3550.19 304.26 ...
February 4, 2011 at 10:57 am
mw112009 (2/4/2011)
File Size Used Unused Type DBFileName
======================================
3550.19295.853254.34LogNextGen_Log
207.13176.9430.19DataNextGen_System_Data
4911.504505.19406.31DataNextGen_Core_Data_1
5235.694431.13804.56DataNextGen_Index_1
13904.519409.114495.40*** Total...
February 4, 2011 at 10:52 am
How about you run it against ANY other db to see how it works?
February 4, 2011 at 10:44 am
Go read the articles and then come back if you have questions.
February 4, 2011 at 10:20 am
So I have 20K tables and I can do it.
You need to get the data for each table and then order by rowcount and / or size to see what...
February 4, 2011 at 9:30 am
Well yes and know. The log can grow during the delete. Let's say you delete a table with 10 GB of data pages, then the log will grow...
February 4, 2011 at 8:41 am
mw112009 (2/4/2011)
3.) Can you please explain why you need to switch recovery modes ( What is the advantage )
The transactions don't need to be log in most dev environements... save...
February 4, 2011 at 8:27 am
Viewing 15 posts - 7,186 through 7,200 (of 18,926 total)