Viewing 15 posts - 2,611 through 2,625 (of 9,244 total)
one will insert rows to an already allocated table and one will have to create the table and employ all the I\O processes around the page allocations, as well as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 11:22 am
can you post some of the errors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 11:15 am
no problem, thanks for posting back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 11:12 am
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
Viewing 15 posts - 2,611 through 2,625 (of 9,244 total)