Viewing 15 posts - 5,071 through 5,085 (of 9,244 total)
Post it anyway with your solution as it may help others in the same situation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 2:57 am
to add hours to days use the DATEADD function
today
select getdate()
today + 3 hours
select dateadd(hh, 3, getdate())
today - 3 hours
select dateadd(hh, -3, getdate())
today + 3 hours 1 week in the future
select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 2:11 am
MissTippsInOz (9/6/2012)
Old post revival!! Just wondered how you managed to get this one resolved as I've a similar situation.Thanks
post full details into a new thread for more help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:58 am
Follow these steps
enable and start LS copy...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:53 am
You'll typically install a new instance for a database when there are different security requirements or performance requirements.
Some applications such as Blackberry ES are best off ring fenced due...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:48 am
sierra4 (9/6/2012)
there were SAN issues on the server where E: and F: became unavailable.
we realized this when the log backups were failing.
now that the drives are back online this is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:42 am
Just out of interet why is hyperv installed, are you hosting VMs on this box too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 3:50 pm
ramyours2003 (9/6/2012)
what is preffered node in sql cluster ?
The preferred node setting will attempt to locate the clustered sql instance group on a particular node or nodes. There is also...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 9:38 am
sjimmo (9/6/2012)
Freeing the buffers and cache will make EVERYTHING in SQL Server run slower.
Not quite everything. When you checkpoint a database and then run DBCC DROPCLEANBUFFERS it will only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 8:15 am
ananda.murugesan (9/6/2012)
Mr. Perry Whittle, one final question1. What is the best pratices & procedure restarted both server principal & Mirror? if restart required.
Depends, are you rebooting both at sametime or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 4:03 am
CHECKPOINT is a per database operation so you may need to run for multiple databases being attempting to free cache
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 2:42 am
It is generally taboo to ask a salary range at first interview, it portrays to the prospective employer you're just in it for the cash. Once at a second interview\offer...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:54 am
To manually fail to the mirror you need to execute
ALTER DATABASE <database name> SET PARTNER FAILOVER
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:41 am
lower the max memory and then raise it again
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:19 am
ananda.murugesan (9/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:17 am
Viewing 15 posts - 5,071 through 5,085 (of 9,244 total)