Viewing 15 posts - 5,296 through 5,310 (of 9,241 total)
Lynn Pettis (7/17/2012)
If you rebuild the NCIs first then the CI, you force rebuilds on the NCIs because of changes to the CI.
pooyan_pdm (7/17/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2012 at 12:41 am
Paul Randal details indexes in this article
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2012 at 6:18 pm
Brandie Tarvin (7/18/2012)
Look, I've seen the Rise of the Planet of the Apes remake. I know how the world REALLY ends
I've seen it to and the end of the world...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2012 at 9:56 am
WW III
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2012 at 8:16 am
ravisamigo (7/16/2012)
We have configured 2 jobs for db full backups and both jobs having the same number of databases
[ i.e JOB 1 - Total size of all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2012 at 6:48 am
boxta (7/17/2012)
we have a DW environment right now on 2008 R2. We have 16+ drives in direct attached storage to our server. We created RAID...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2012 at 5:29 am
pooyan_pdm (7/17/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 4:39 pm
Can you post the complete column output from sys.dm_db_index_physical_stats using a detailed scan for the index in question
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 4:24 pm
Nicholas Cain (7/17/2012)
Question is why would you cluster on virtual hardware? (other than for cheap QA & validation)I'm interested to know what this is providing you.
Ordinarily you'd be right, but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 2:46 pm
tmagney (7/17/2012)
Can I just go into vSphere and power down a node or disable a NIC?
Yes that is exactly what you'd do
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 12:24 pm
JJ-469859
Both primary and DR1 server primary, 1 server DR - use fileshare and revoke DR vote??? This one I am unsure about?
If you're going to revoke the DR node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 11:00 am
SQLSACT (7/17/2012)
How would I setup a script to copy files from a shared location on one server, to a shared location on another server?
The extension of the files would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 9:03 am
sqlnaive (7/17/2012)
Does rebuilding the performance counters affect the SQL databases ? Should thee be some kind of tests done post rebuld ?
It will require a reboot so plan for that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 9:01 am
Damian-167372 (7/11/2012)
i was thinking to completely un-install the sql instance and not to remove the node from the cluster
no, just run setup and remove the node (which uninstalls just...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2012 at 3:57 am
lawson2305 (7/16/2012)
I run a tran backup and shrink every day. I append the backup daily except...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2012 at 1:10 pm
Viewing 15 posts - 5,296 through 5,310 (of 9,241 total)