Viewing 15 posts - 9,031 through 9,045 (of 49,571 total)
Sorry, am only leaving JHB Wednesday evening. ETA for Birmingham is, I believe, about 10AM Thursday.
Besides, Aaron didn't put conditions on the free coffee...
May 16, 2014 at 2:18 pm
Stefan Krzywicki (5/16/2014)
GilaMonster (5/16/2014)
Grant Fritchey (5/15/2014)
Ed Wagner (5/15/2014)
SQLRNNR (5/14/2014)
Luis Cazares (5/14/2014)
I'm afraid, "he-who-shall-not-be-named" is back in the forums.I hope that I can behave well enough.
Who? Tom Marvolo Riddle?
You know,...
May 16, 2014 at 1:21 pm
KTurkes (5/16/2014)
I have very little knowledge about AlwaysOn, and according to our SAP on MSSQL docs it should be in a MSCS environment.
Perhaps it's worth getting someone involved in...
May 16, 2014 at 12:55 pm
rodjkidd (5/16/2014)
The SQL Bits tradition is to bag pack Wednesday evening, then drink, and eat, and drink some more!
That sounds like a suitably British way of working
May 16, 2014 at 12:40 pm
Grant Fritchey (5/15/2014)
Ed Wagner (5/15/2014)
SQLRNNR (5/14/2014)
Luis Cazares (5/14/2014)
I'm afraid, "he-who-shall-not-be-named" is back in the forums.I hope that I can behave well enough.
Who? Tom Marvolo Riddle?
You know, I think that...
May 16, 2014 at 12:35 pm
KTurkes (5/16/2014)
So compared to async mirroring sync mirroring's only disadvantage is performance impact?
Pretty much, yes.
May 16, 2014 at 12:31 pm
KTurkes (5/16/2014)
GilaMonster (5/16/2014)
KTurkes (5/16/2014)
if I know correctly even one synchronized mirror fails all applications will stop until it is restored.
No, that would completely defeat the point of mirroring as a...
May 16, 2014 at 12:18 pm
KTurkes (5/16/2014)
if I know correctly even one synchronized mirror fails all applications will stop until it is restored.
No, that would completely defeat the point of mirroring as a High Availability...
May 16, 2014 at 12:09 pm
Time to give your legal dept (and maybe HR) a call, then investigate. I hope you have some auditing in place.
May 16, 2014 at 11:40 am
No, SQL won't by itself suddenly write data from 3 months ago. If you're seeing inserts happen, something or someone is running those inserts.
May 16, 2014 at 11:09 am
0 is fine for min server memory.
As for locked pages... https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/
p.s. Don't use Task manager to check SQL Server's memory.
May 16, 2014 at 8:05 am
DECLARE @dt DATETIME;
SET @dt = GETDATE();
SELECT DATENAME(month,@dt), YEAR(@dt)
May 16, 2014 at 6:33 am
Speaking Friday and Saturday (and apparently getting free coffee while there :w00t:)
May 16, 2014 at 3:26 am
Eirikur Eiriksson (5/15/2014)
Question for Gail, on a 2005 platform, which solution of these two would you prefer and why?
Constraint. Less overhead, less chance of it getting altered later by...
May 16, 2014 at 12:48 am
Minnu (5/15/2014)
while monitoring the same in sql profiler duration is showing as '80506' milliseconds, i.e '1 min 34 seconds'
80506 ms is not 1 min 34 sec.
It's 80.5 seconds. 60 seconds...
May 15, 2014 at 5:01 am
Viewing 15 posts - 9,031 through 9,045 (of 49,571 total)