Viewing 15 posts - 2,536 through 2,550 (of 9,244 total)
dmc-608719 (1/7/2015)
http://msdn.microsoft.com/en-us/library/bb934049(v=sql.110).aspx
Before proceeding with these steps I wanted to look a little more at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2015 at 2:39 pm
sounds like what they're looking for is Oracle RAC
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2015 at 7:41 am
if you have access to dns clean up the dns records too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2015 at 10:37 am
UconnDBA (1/5/2015)
Basing that on all our other database backups, in 2012 and 2008r2, compressing to a file less than 30% of the database size. I did try running the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2015 at 6:10 am
to be clear, latches occur on physical disk pages and inmemory pages
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2015 at 6:05 am
sej2008 (1/4/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2015 at 5:47 am
with a decent pipe between sites i've copied over the network overnight, that was from UK to Arizona.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 2:26 pm
multiple IP addresses on different subnets but not VNNs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 1:36 pm
you add the primary, the est should be taken care of
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 10:30 am
Failover cluster manager in Windows 2008 and 2012 is pretty much exactly the same bar a few small tweaks.
Do you even have a clustered instance of SQL server running?
Start by...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 9:56 am
dbaduck (1/5/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 8:10 am
check for any type of LOB columns, as these do not compress well, if at all.
This should help identify any large columns
select object_name(c.object_id) as tablename,
c.name as columnname
from sys.all_columns c inner...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2015 at 8:03 am
sej2008 (1/2/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2015 at 12:09 pm
create a role for your clustered sql server instance and into the role put the required shared disks for the sql instance and a shared disk for the DTC.
Right click...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2015 at 3:24 am
pradeep.k 50453 (1/1/2015)
We are configured the logshipping around 80 gb database.log file growth up to 60 gb .want to shrink the ldf files.what is the best way to shrink file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 1, 2015 at 6:24 am
Viewing 15 posts - 2,536 through 2,550 (of 9,244 total)