Viewing 15 posts - 6,016 through 6,030 (of 9,244 total)
sqlfriends (2/6/2012)
I got it, thanks all
Great, set the max memory and post back if you need any further help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 3:20 pm
sqlfriends (2/6/2012)
Does it mean SQL server itself (buffer pool) has not enough memory, or it means OS doesnot have enough memory?
No it doesn't
sqlfriends (2/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 2:47 pm
sqlfriends (2/6/2012)
[The first thing that you need to do is set the max server memory to a sensible value that will ensure SQL does not try to starve the OS....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 1:34 pm
rajg (2/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 1:05 pm
Case sensitivity is not the way to go. Based on the data provided the OP would only be able to insert 2 duplicate records, what if they want to insert...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 9:07 am
duplicate
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 9:06 am
The PK constraint across the airline_cd column will require unique values. You could drop the PK constraint, but I think you would be better off designing the table and it's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 5:06 am
Shivrudra (1/17/2012)
How many IP address include in 2 node active -passive cluster .....
i answered Five ........2 for private network
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2012 at 9:33 am
ananda.murugesan (2/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2012 at 3:34 am
SkyBox (1/25/2012)
coded into VB6
God that shows how behind the times they are, have you also explained that Ronald Reagan is no longer president 😀
SkyBox (1/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2012 at 3:24 am
beejug1983 (2/1/2012)
Hi,Does quorum in Mirroring works as a quorum in Clustering. Please describe how quorum works in mirroring.
Thanks
If anything the quorum in database mirroring rather more matches the new clustering...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2012 at 3:15 am
hayden_jones (1/23/2012)
What I'm still not clear on is the starting of the instance with the NET START command. Usually, I bring SQL up and down from the Cluster Administrator.
leave...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2012 at 2:32 am
SQL_Giant (1/31/2012)
To achieve seemless failover, you would have to implement Database mirroring
Mirroring does not guarantee to provide seamless failover, in fact, a mirror session can take sometime to failover depending...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2012 at 9:46 am
yes, it is possible. Are you using the mirroring GUI or T-SQL?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2012 at 9:24 am
sohairzaki (2/4/2012)
The transaction log file is continually growing.
I read that if i backed up the transaction log say every 15 minutes this will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2012 at 8:51 am
Viewing 15 posts - 6,016 through 6,030 (of 9,244 total)