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: https://twitter.com/DwainCSQL
Facebook Profile: No information available.
Google+ Profile: No information available.
LinkedIn Profile: http://www.linkedin.com/pub/dwain-camps/63/93b/472
Other social media: No information available.
Homepage: http://dwaincsql.com/about/
Blog: http://DwainCSQL.com/
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: (Online)
Member Group: General Forum Members
Joined: 9/12/2011 10:10:11 PM (5,400 visits since)
Local Time: 12/23/2014 12:32:44 AM
Last Login: Today @ 5:12:31 PM
Total Points: 3,443 point out of 1,620,992 total points. (.21% of total)
Average Points: Averaging 2.88 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
Avatar:
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!