Viewing 15 posts - 11,116 through 11,130 (of 49,552 total)
Exactly.
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
October 31, 2013 at 10:55 am
Every job I've had in the last 10 years (including the one I'm starting at tomorrow) has been a personal referral. Not from someone looking at the alphabet soup of...
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
October 31, 2013 at 10:35 am
It's a pretty safe setting. Worst it can do is slightly increase the number of compiles if you happen to have ad-hoc queries that do get sent multiple times (identically)
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
October 31, 2013 at 10:27 am
Those two are redundant, you don't need both, but you do want to set the variable to something before concatenating. Otherwise it's NULL and NULL + Anything = NULL.
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
October 31, 2013 at 10:18 am
Ed Wagner (10/31/2013)
GilaMonster (10/31/2013)
Jeff Moden (10/31/2013)
GilaMonster (10/31/2013)
I'm unlikely to be around much during the week from now on (at...
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
October 31, 2013 at 9:00 am
djackson 22568 (10/31/2013)
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
October 31, 2013 at 8:49 am
krowley (10/31/2013)
Sigh , I hate the whole job hunting process and was sort of hoping a short cut at least existed. Not that I would have been able to take...
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
October 31, 2013 at 8:47 am
Jeff Moden (10/31/2013)
GilaMonster (10/31/2013)
I'm unlikely to be around much during the week from now on (at least for a...
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
October 31, 2013 at 8:38 am
If you want to change data, you use a procedure. Functions have a requirement of having no side effects.
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
October 31, 2013 at 8:35 am
krowley (10/31/2013)
MVP is an award for community contributions. That's it. It shouldn't guarantee a DBA job any more than spending time at Toastmasters should. It's about how much you share...
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
October 31, 2013 at 8:24 am
krowley (10/31/2013)
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
October 31, 2013 at 7:49 am
How have you identified that the log backup is the blocker? What is the lock type that it is holding? What is trying to get that lock?
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
October 31, 2013 at 7:35 am
Last day of freedom. Starting dev job tomorrow. Hopefully will go well...
I'm unlikely to be around much during the week from now on (at least for a while), so could...
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
October 31, 2013 at 7:33 am
tony28 (10/31/2013)
or do you think that is it problem ?...
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
October 31, 2013 at 7:33 am
Logical reads are reads done from memory. Not necessarily scans.
Slower queries isn't important to you? Really?
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
October 31, 2013 at 6:00 am
Viewing 15 posts - 11,116 through 11,130 (of 49,552 total)