Viewing 15 posts - 3,931 through 3,945 (of 9,253 total)
I prefer this
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.index_id as IndexID
, i.type_desc AS IndexType
, p.partition_number AS PartitionNo
, p.rows AS NumRows
, au.type_desc AS InType
, au.total_pages AS NumPages
, au.total_pages * 8...
October 16, 2013 at 7:57 am
mssqlsrv (10/16/2013)
3. Transfer data from datafile 'A' to specific data file in other file group.
data is only transferred between files in the same filegroup using the emptyfile parameter
October 16, 2013 at 7:34 am
when configuring the secondary and you specify the primary server\instance specify the dedicated NIC IP
October 16, 2013 at 7:33 am
george sibbald (10/16/2013)
Perry, can you confirm my post is visible please?🙂
Ananda, if it is, see my post
your post is visible :hehe:
October 16, 2013 at 4:36 am
Calling the index physical stats dmv in a cursor could have serious ramifications on a large database, you should bear this in mind.
Query sys.partitions and sys.allocation_units for details of index...
October 15, 2013 at 3:54 pm
Ted Zatopek (10/15/2013)
we could be operating at the DR site for an extended period of time.
Rare, but possible i suppose. Failover to DR should be considered a short term...
October 15, 2013 at 3:25 pm
Ted Zatopek (10/15/2013)
October 15, 2013 at 12:44 pm
Ted Zatopek (10/15/2013)
It sounds like what I could do then is have one geographically "stretched" cluster that includes all 4 nodes.
Correct, that's what i said above 😉
Ted Zatopek...
October 15, 2013 at 9:20 am
No you can't do that. You will need to geographically expand your cluster across the 4 nodes in both sites. This does of course bring with it the usual infrastructure...
October 15, 2013 at 6:41 am
are you asking how to failover to the mirror database?
October 15, 2013 at 6:27 am
Have you checked the cluster events to see if you have any issues reported there?
October 15, 2013 at 4:07 am
check the information in the application log when the service fails to start
October 14, 2013 at 5:34 am
alexander.karls (10/14/2013)
so, what trace number should i use, there are so many
none, just want to check if you have any enabled.
October 14, 2013 at 5:29 am
Hi
doesnt seem to support mounted volumes, will you be addressing this?
October 14, 2013 at 2:52 am
Viewing 15 posts - 3,931 through 3,945 (of 9,253 total)