Viewing 15 posts - 4,381 through 4,395 (of 9,253 total)
runal_jagtap (1/23/2013)
TableNameIndexNameIndexTypePartitionNoNumRowsInTypeNumPagesTotKBsUsedKBsDataKBsTestHEAPHEAP11024112IN_ROW_DATA4465357203539235384
😉
January 23, 2013 at 7:49 am
Execute the following against your database and substitute the table name in the WHERE predicate and post the results back please
SELECTOBJECT_NAME(i.object_id) AS TableName
, ISNULL(i.name, 'HEAP') AS IndexName
, i.type_desc AS IndexType
,...
January 23, 2013 at 7:43 am
Sean cavanagh (1/23/2013)
Perry,Thanks for your response. I will definitely look into your guide for creating a virtual sandpit.
Do, you'll find it extremely useful 😉
The help states the following as you...
January 23, 2013 at 7:34 am
foxxo (1/23/2013)
Also, you need to install the 2nd instance from the 1st node, then fail it over.
Actually, no you don't!
chandrakant_gaurav (1/23/2013)
January 23, 2013 at 5:35 am
SQL* (1/23/2013)
hi all,I'm learning these HA/DR things.
"Failover clustering with Database Mirroring"
What does it means?
Clustering: Two nodes being synchronized. (Physically & SQL Server level)
Mirroring: Primary & Secondary (Standby server).
Not quite...
January 23, 2013 at 5:28 am
Or empty and remove files in the current file group 😉
January 22, 2013 at 2:30 pm
Raghavender (1/22/2013)
I need to move only some tables to other data file which is on same file group.Not the whole data file.
That's not how it works, objects can only be...
January 22, 2013 at 1:34 pm
jasona.work (1/21/2013)
Each individual blade in the system, is a "stand-alone" server which only shares power and connectivity with the other blades in an enclosure.
Correct, they share power cooling and...
January 21, 2013 at 4:22 pm
You can use dbcc shrinkfile passing in the emptyfile parameter, this will empty data from the file to other files in the same file group only. You would then need...
January 21, 2013 at 1:56 pm
Failure of the public network will cause a failover of the sql server instance. You have a spare node so take the problem node out of sevice and repair the...
January 21, 2013 at 1:52 pm
Sean cavanagh (1/21/2013)
Helpful folks,I'm in an odd situation where, in my new job, I don't have a test cluster in which I can experiment.
No excuse, you can build a...
January 21, 2013 at 9:28 am
kpwimberger (1/17/2013)
January 21, 2013 at 8:35 am
MyDoggieJessie (1/20/2013)
January 21, 2013 at 5:42 am
You'll have references to the LOG folder and this is controlled by a startup parameter which sits in the registry, make sure the errorlog path is set and the default...
January 21, 2013 at 5:33 am
Viewing 15 posts - 4,381 through 4,395 (of 9,253 total)