Viewing 15 posts - 24,031 through 24,045 (of 49,552 total)
Please read through this - Managing Transaction Logs[/url]
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
August 22, 2011 at 9:52 am
SanDroid (8/22/2011)
Table and Index stats updates are fully Logged and can happen nightly.They also create a very Large tran log backup.
Unlikely. The stats updates just change the statistics, not the...
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
August 22, 2011 at 9:34 am
virgilrucsandescu (8/22/2011)
You would loose your money Sir, because I moved very carefully all the jobs before the full backup.
Which means that the next transaction log backup after the full...
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
August 22, 2011 at 9:13 am
Perry Whittle (8/22/2011)
GilaMonster (8/22/2011)
that is part of the buffer pool and is constrained by max memory.is that correct?
Yes.
Although part of the same overall memory pool that is constrained by...
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
August 22, 2011 at 9:10 am
What a coincidence that both of the people helping out offer such a service... 😀 😉
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
August 22, 2011 at 8:01 am
dopydb (8/22/2011)
but i think the best message i can take from this is 'NO BS!' 😉
Absolutely.
I suspect a lot of candidates that I used to interview thought that I didn't...
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
August 22, 2011 at 7:18 am
Please note: 3 year old thread.
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
August 22, 2011 at 7:13 am
I've got several where the candidate tried BS. It's sad.
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
August 22, 2011 at 6:32 am
Check the SQL error log
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
August 22, 2011 at 5:46 am
dopydb (8/22/2011)
end of the day i could read 1000 potential questions but not get asked one of them! i was just looking for typically what to expect
Depend on the interviewer.
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
August 22, 2011 at 5:45 am
Especially in limited mode...
Is the query blocked by anything?
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
August 22, 2011 at 4:21 am
californication2704 (8/21/2011)
so.. i would like to generate a query who will give to me a view of every single interaction with start and end time with the others data...
Yes, I...
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
August 22, 2011 at 4:07 am
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
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
August 22, 2011 at 3:24 am
p.s. Why set processor and IO affinity? Most of the time they're best left at default values.
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
August 22, 2011 at 3:23 am
No, it's not the plan cache, that is part of the buffer pool and is constrained by max memory.
SQL will take memory outside of buffer pool for things like CLR,...
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
August 22, 2011 at 3:17 am
Viewing 15 posts - 24,031 through 24,045 (of 49,552 total)