Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Member Profile for dwain.c Expand / Collapse
Contact Information Personal Information
Username: dwain.c
Public Email: No information available.
  Send this member a private message...
  Send this member an email message...
  Add member to my buddy / ignore list!
MSN IM: No information available.
Yahoo IM: No information available.
AIM IM: No information available.
ICQ#: No information available.
Twitter Profile:
Facebook Profile: No information available.
Google+ Profile: No information available.
LinkedIn Profile:
Other social media: No information available.
Birthday: No information available.
Location: No information available.
Occupation: No information available.
Interests: No information available.
Biography: No information available.
Tools: Show all posts by this member...
  Find all topics this member has participated within...
User Details Additional Information
User Status: (Offline)
Member Group: General Forum Members
Joined: 9/12/2011 10:10:11 PM (6,428 visits since)
Local Time: 11/29/2015 3:49:13 AM
Last Login: 10/27/2015 7:35:39 PM
Total Points: 3,977 point out of 1,710,778 total points. (.23% of total)
Average Points: Averaging 2.59 points daily since registration
User Level: Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame
Post Signature:
My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
My temporal SQL musings: Calendar Tables, an Easter SQL, Time Slots and Self-maintaining, Contiguous Effective Dates in Temporal Tables