Viewing 15 posts - 5,026 through 5,040 (of 9,244 total)
Kwisatz78 (9/13/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 6:20 am
Perry Whittle (9/13/2012)
and certainly shouldn't be used for a geo spacial cluster configuration.
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 4:06 am
Kwisatz78 (9/13/2012)
The primary node contains both the data and quorum disks
So you're using Node and disk majority quorum type?
Kwisatz78 (9/13/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 3:58 am
Kwisatz78 (9/13/2012)
Sorry I am not sure I followed what you have said. If I remove voting from one of the nodes is this not the same as removing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 3:40 am
Sqlism (9/12/2012)
Hope this link helps youhttp://sqlism.blogspot.com/2012/08/finding-port-number-for-particular-sql.html
Finding the Port Number for a particular SQL Server Instance
DECLARE @tcp_port nvarchar(5)
EXEC xp_regread
@rootkey = ‘HKEY_LOCAL_MACHINE’,
@key = ‘SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\SUPERSOCKETNETLIB\TCP’,
@value_name = ‘TcpPort’,
@value = @tcp_port OUTPUT
select @tcp_port
This is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 2:55 am
Kwisatz78 (9/13/2012)
We currently have a geo cluster which spans 2 datacentres which are close together. Not having a 3rd location and as we are wanting to use availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 2:38 am
SQLSACT (9/13/2012)
What I'm struggling to grasp is why does SQL Server still worry with the Index if all the pages that it needs is already in memory.Thanks
The index key...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 13, 2012 at 2:07 am
Nater (9/12/2012)
2 drives in RAID1 for backups
2 drives in RAID1 for logs
4...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 11:21 pm
wannabe dba (9/12/2012)
I have a sql 2008 r2 enterprise box which is running on windows 2008 R2 enterprise and the business wants to separate some of the databases from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 2:43 pm
Nater (9/12/2012)
Thank you so much for your response!!! Thank you so much for mentioning backups . . . cant believe i forgot to mention that. We will definitely...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 12:55 pm
What about backups, you have no provision for these??
Nater (9/12/2012)
What I was thinking was . . . and please correct me and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 10:53 am
Jpotucek (9/12/2012)
one last point for clarification?? :blush:
tut tut tut, any more of this and you'll be incurring fees 😀
Jpotucek (9/12/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 8:40 am
george sibbald (9/12/2012)
I'll moonlight and undercut these guys by 10% 🙂edit: cash only
:hehe:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 5:21 am
TheSQLGuru (9/12/2012)
I happen to know of just such a consultancy, btw. 😎
😉 thanks for recommending me Kevin 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 4:57 am
it needs to account for network latency so yes change it to whatever you require
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 12, 2012 at 4:52 am
Viewing 15 posts - 5,026 through 5,040 (of 9,244 total)