Viewing 15 posts - 2,416 through 2,430 (of 9,244 total)
gwellbrock (2/5/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2015 at 8:37 am
gwellbrock (2/4/2015)
The database takes 4 hours to backup after tuning extensively(I hate TDE!!)
Yep, unfortunately TDE negates backup compression 😉
gwellbrock (2/4/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2015 at 3:45 am
Adam Bean (2/4/2015)
Hey all,Experimenting in a local lab with an always on setup and have some questions. The setup is pretty easy. 3 node cluster with a file share witness.
If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2015 at 3:11 am
a page has 8096 bytes of usable space
you have an overhead if fully populated of around 98 bytes per row.
It's not exact as each row may not be fully populated
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2015 at 9:56 am
Jampandu (2/4/2015)
I have a table like below,
CREATE TABLE Student
(
Id BIGINT not null
,Name NCHAR(20) not Null
,Branch NVARCHAR (64) null
)
The table contains : 100000 rows .
Can you please...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2015 at 9:17 am
Hadrian (2/4/2015)
Thanks Perry,Is just for test(managers asked to try this operation) .Please could you me an argument why?
It is not supported by Microsoft. The master database is unique...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2015 at 9:00 am
what are the connections doing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2015 at 6:20 am
do not restore the master database from one instance to another, you have been warned!!!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2015 at 6:18 am
Hadrian (2/3/2015)
TDE could not be turn off.
Did you receive any error message??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 4:27 pm
Let's start with the following
How many databases in the group?
How many secondarys, are they readable?
Are they synchronous or asynchronous mode?
Whart sql server version is in use on the replicas?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 4:22 pm
Yes it possible. The link I provided and other articles linked within it detail this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 4:11 pm
Joy Smith San (2/3/2015)
If I add an NDF file on this second drive, will SQL server start writing into this new NDF *** soon its added ?
Are you creating the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 9:46 am
it seems clear that you do not understand the situation you are dealing with, I would highly recommend you seek help before you render the database inaccessible, you likely won't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 9:32 am
Ste_P (2/2/2015)
Which forum would you have expected this post to go in? :ermm:
Ste_P (1/20/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 9:30 am
AndrewSQLDBA (2/2/2015)
I need to fail over the Active side to the now New Node that was just created
I want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 9:28 am
Viewing 15 posts - 2,416 through 2,430 (of 9,244 total)