Viewing 15 posts - 21,706 through 21,720 (of 49,552 total)
A full day downtime is allowed? Wow, that's a lot of down time. No one's going to complain if the DB is down for 24 hours?
The reason for a filegroup...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 3:22 am
Divine Flame (12/15/2011)
I suggested him to put this SQL script inside a SQL Agent Job rather than windows scheduled task.
On SQL Express edition?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 3:15 am
Before I answer this, what's your maximum downtime and what edition of SQL are you running? How long does it take to restore that monthly full, the latest diff and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 1:52 am
Divine Flame (12/15/2011)
GilaMonster (12/15/2011)
Divine Flame (12/15/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 1:46 am
Divine Flame (12/15/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 12:50 am
What's the exact error that you're getting?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 12:49 am
Google down?
http://www.google.com/search?q=numa+%22SQL+Server%22
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 12:40 am
sqldba2k8 (12/15/2011)
I am working in developement platform.now i want to move admin side.thats why i attending interviews.
That's good. Be sure to tell interviewers that, if you lie about your experience...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 12:36 am
sqldba2k8 (12/14/2011)
Yesterday i attended the interview on sqldba position.they are asking these questions.please answer to these questions.
If I answer them, do I get the job?
1)what is your Daily work after...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 12:33 am
Jeff Moden (12/14/2011)
with a touch of the "Halloween Effect" (essentially, a cursor within a cursor behind the scenes).
????
Something you've named 'halloween effect'? Because what's normally referred to as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2011 at 12:27 am
btw, if I've understood you properly
DELETE FROM ContactGroupMember
WHERE NOT EXISTS (SELECT 1 FROM #FinalResults AS FR WHERE ContactGroupMember.ContactGroupId = FR.ContactGroupID AND ContactGroupMember.ContactId = fr.OwnerID)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2011 at 3:49 pm
To add to that, DISTINCT in an IN subquery is neither necessary nor desired. SQL ignores duplicates in an IN, regardless of DISTINCT or no DISTINCT.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2011 at 3:46 pm
Try running it with a maxdop hint OPTION (MAXDOP 1) and see how that changes things.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2011 at 3:45 pm
Lexa (12/14/2011)
GilaMonster (12/14/2011)
sroumel (12/14/2011)
Maybe it doesn't matter,rebuild index triggers update statistics and then the plan recompiles
Rebuild doesn't trigger update stats, it does the update as part of the index...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2011 at 3:23 pm
GSquared (12/14/2011)
(Sorry. I consider English a toy. Periodically, I break it and need to get my parents to buy a new one. Or something like that.)
I have...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 14, 2011 at 3:20 pm
Viewing 15 posts - 21,706 through 21,720 (of 49,552 total)