Viewing 15 posts - 2,611 through 2,625 (of 9,241 total)
Adam Bean (12/11/2014)
We're now starting to dissect performance between SELECT...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 11:10 am
are these all on the same servers?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 8:51 am
sej2008 (12/11/2014)
I require to restart my vm machine(i.e Node1) after installing Sql server 2012 ent edition.Now in that case my windows cluster would failover,
If node1 was the only node...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 8:41 am
Minaz Amin (12/11/2014)
--Empty files started
DBCC ShrinkFile(YEAR2015_FG,EmptyFile);
GO
--Removing files
Alter DATABASE ETL_MART REMOVE FILEGROUP YEAR2015_FG;
GO
-- Remove parition scheme depednecy
ALTER PARTITION SCHEME Yearly_Partition_Schemenew NEXT USED YEAR2015_FG
--Removing files group
Alter DATABASE ETL_MART...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 5:37 am
it's no good complaining about network issues when your validation report is full of network configuration errors. You'll need to get these sorted first and ensure the report is clean...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 2:38 am
quackhandle1975 (12/10/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 2:01 am
build yourself a virtual test system on your 8.1 machine 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2014 at 10:47 am
easy to test, but, affirm. The raiserror will be passed to the job step and fail, if this step is told to quit on failure the job will terminate
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2014 at 10:01 am
OS error 5 while attempting to open or create the physical file 'E:\MSSQL\Templog\templog.ldf' is pretty clear. Double check the path and ACLs on the folder and file level
What does this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2014 at 9:08 am
lsalih (12/10/2014)
The goal is to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2014 at 9:01 am
just move the DEV group to node 2
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2014 at 8:49 am
snomadj (12/10/2014)
a) when P is P
When the mirror and witness are down the principal is running exposed and as a result goes offline
snomadj (12/10/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2014 at 8:19 am
JoshDBGuy (12/9/2014)
Perry Whittle (12/9/2014)
JoshDBGuy (11/26/2014)
So will this also work,
if (select ars.rolefrom sys.dm_hadr_availability_replica_states ars
where ars.is_local = 1) = 2
begin
raiserror ('This is not the primary replica.',2,1)
end
Work from where, where will this be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 10, 2014 at 8:02 am
Never applied TDE to a mirror, cant see why this won't work though
You'll need to create a database master key on each instance if one doesn't already exist.
Once this is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2014 at 4:11 pm
the certificate is stored in the master database and can be used for all databases or you could have multiple server certs and use different ones to secure DEKs within...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2014 at 4:04 pm
Viewing 15 posts - 2,611 through 2,625 (of 9,241 total)