Viewing 15 posts - 2,416 through 2,430 (of 9,241 total)
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
Hadrian (2/3/2015)
So in conclusion without password we cannot restore our encrypted database?Thanks very much,
Hadrian
Take a new backup of the certificate on the ServerA giving it a password you know.
Then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 8:44 am
if you only have 2 nodes then you need to add a witness whether it be a disk or file share witness.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 8:39 am
SQL!$@w$0ME (2/1/2015)
We have a 2 node clustered instance(SQL 2014) with 26 databases and we would like to enable alwayson for one of the databases for reporting (only one secondary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 8:38 am
Viewing 15 posts - 2,416 through 2,430 (of 9,241 total)