Viewing 15 posts - 4,366 through 4,380 (of 9,241 total)
ChrisM@home (1/24/2013)
How about EXCEPT?
+1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2013 at 5:02 pm
I would use the sys.database_files catalog and compare that against sys.master_files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2013 at 9:27 am
SQL* (1/24/2013)
Hi,Thanks,
But can you tell me any scenarios where we can use Clustering/Mirroring together.
I'll keep this brief as there are already a wealth of articles and white papers on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2013 at 6:34 am
If you have availability groups set up and working why on earth do you want to use Log Shipping?
This details how to migrate from Log Shipping to AO groups, this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2013 at 1:29 am
and all that's easier than a quick check in the dbo.sysjobhistory table??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2013 at 11:01 am
NJDave (1/23/2013)
I am installing SQL Server 2008 R2 Enterprise on a 2 node cluster and reached the instance configuration in the wizard. There is a field to complete labeled "SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2013 at 9:22 am
selectj.name
, convert(smalldatetime, convert(varchar(20), max(jh.run_date)))
, CASE jh.run_status
WHEN 0 THEN 'Failed'
WHEN 1 THEN 'Success'
WHEN 2 THEN 'Retry'
WHEN 3 THEN 'Cancelled'
END AS Run_Status
from msdb.dbo.sysjobs j
inner join msdb.dbo.sysjobhistory jh on
j.job_id = jh.job_id
where j.name =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2013 at 8:59 am
runal_jagtap (1/23/2013)
TableNameIndexNameIndexTypePartitionNoNumRowsInTypeNumPagesTotKBsUsedKBsDataKBsTestHEAPHEAP11024112IN_ROW_DATA4465357203539235384
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 23, 2013 at 5:28 am
Of course!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2013 at 3:11 pm
Or empty and remove files in the current file group 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 22, 2013 at 1:34 pm
Viewing 15 posts - 4,366 through 4,380 (of 9,241 total)