Viewing 15 posts - 5,311 through 5,325 (of 9,253 total)
Can you post the complete column output from sys.dm_db_index_physical_stats using a detailed scan for the index in question
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...
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
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...
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...
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
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...
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...
July 16, 2012 at 1:10 pm
check the windows application log, there must be something in there.
Try starting the service manually and check the app log to
July 16, 2012 at 1:02 pm
JJ-469859 (7/16/2012)
July 16, 2012 at 11:10 am
Perry Whittle (7/13/2012)
What information do you require?
??
July 16, 2012 at 9:16 am
ananda.murugesan (7/16/2012)
With 650 GB database size run these two commands, should take more time to finish. how to reduce the time during completion of these two commands.
Short of deleting all...
July 16, 2012 at 7:01 am
did you actually instal SQL Server 2008 database engine or just client tools, without knowing the options you selected its impossible to say, doesn't look like 2008 instance is installed.
July 16, 2012 at 5:47 am
You understand this?
Perry Whittle (7/16/2012)
July 16, 2012 at 5:38 am
Shabnam Gupta (5/17/2012)
so you have to open the master key to create a certificate?
What does the following query return?
select name, is_master_key_encrypted_by_server from sys.databases
where database_id = 1
July 16, 2012 at 5:03 am
Viewing 15 posts - 5,311 through 5,325 (of 9,253 total)