Viewing 15 posts - 3,841 through 3,855 (of 9,244 total)
signal runner (12/15/2013)
Hi,I am hoping someone might be able to help me: Under a SQL 2012 Standard edition:
Standard edition itself does have AO support constraints as follows;
Alwayson Availability groups
Standard...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2013 at 7:07 am
ryan_xh (12/12/2013)
We have a single node sql 2008 cluster, now we want to add a new node to have a active\passive cluster. So for the new node, do we...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2013 at 2:43 pm
PHXHoward (12/6/2013)
With Windows 2012, a cluster will stay online with only one node standing. It has to do with dynamic weight adjustments.
Only if you have removed the voting from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2013 at 5:59 am
bobbums (12/9/2013)
You do know that some of us are maintaining databases created by other people, right?
Yes, as do I.
bobbums (12/6/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2013 at 5:56 am
although generally frowned upon, xp_cmdshell can get most info from the OS. Just ensure your script disables it again after calling it like so
exec sp_configure 'show advanced options', '1'
reconfigure
exec...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:23 am
dan-572483 (12/6/2013)
Then why would my simple recovery model databases not come online with copies of the original log files in the new location?
The first thing you should have done is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:15 am
dan-572483 (12/5/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:09 am
Denesh Naidoo (12/9/2013)
Currently we have a stand alone SQL Server 2008 R2 Ent server. We are planning to move this environment to a Cluster. Once the cluster is ready...the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:01 am
mandavli (12/8/2013)
yes user I am trying does have login credential has rights to other domain server.
The account has been added to sql server as a login?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 4:56 am
mssqlnoob (12/9/2013)
frankly speaking I still could not differentiate between READ COMMITTED SNAPSHOT AND SNAPSHOT ISOLATION
The main difference is that to use snapshot isolation the query must set the option
SET TRANSACTION...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 4:54 am
bobbums (12/6/2013)
In the article, your suggestion is to drop the PK and then re-add it.
This is correct as in this case the clustered index column is also the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 4:14 am
what errors are you receiving when you try to start the agent?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 11:27 am
PHXHoward (12/6/2013)
I wrote a long detailed reply but forgot to save to clipboard before hitting submit and it didn't go through. Oh well.
Would have been interested to see that!
PHXHoward...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 11:26 am
SQLSACT (12/6/2013)
I would recommend that you put a file share witness in place
I concur
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 4:54 am
ChiragNS (10/16/2008)
Would Create Index WITH Drop_Existing work for moving non-clustered indexes.
Yes it does.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 4:26 am
Viewing 15 posts - 3,841 through 3,855 (of 9,244 total)