Today's Random Word!

• Grumpy DBA

  SSChampion

  Points: 12368

  More actions

  July 22, 2016 at 9:00 am

  #1891600

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

• Luis Cazares

  SSC Guru

  Points: 183698

  More actions

  July 22, 2016 at 9:05 am

  #1891603

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Ed Wagner

  SSC Guru

  Points: 287024

  More actions

  July 22, 2016 at 9:08 am

  #1891605

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• crookj

  SSChampion

  Points: 14055

  More actions

  July 22, 2016 at 9:31 am

  #1891614

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

• whereisSQL?

  SSCarpal Tunnel

  Points: 4908

  More actions

  July 22, 2016 at 9:35 am

  #1891618

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

• djj

  SSCoach

  Points: 18831

  More actions

  July 22, 2016 at 9:47 am

  #1891622

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

• Ed Wagner

  SSC Guru

  Points: 287024

  More actions

  July 22, 2016 at 10:56 am

  #1891640

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Hugo Kornelis

  SSC Guru

  Points: 64780

  More actions

  July 22, 2016 at 11:01 am

  #1891641

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  ---

  Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
  Visit my SQL Server blog: https://sqlserverfast.com/blog/
  SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
  

• Ed Wagner

  SSC Guru

  Points: 287024

  More actions

  July 22, 2016 at 11:06 am

  #1891644

  Hugo Kornelis (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  Freedom

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• EL Jerry

  SSCertifiable

  Points: 7061

  More actions

  July 24, 2016 at 12:19 pm

  #1891724

  Ed Wagner (7/22/2016)

  ---

  Hugo Kornelis (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  Freedom

  William (Wallace)

  "El" Jerry.

  "A watt of Ottawa" - Gerardo Galvan

  To better understand your help request, please follow these best practices.[/url]

• Jeff Moden

  SSC Guru

  Points: 1003863

  More actions

  July 24, 2016 at 12:45 pm

  #1891728

  Hugo Kornelis (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  Semantically, you ALWAYS have the right to be free but sometimes you have to fight to be able to exercise that right. 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• TomThomson

  SSC Guru

  Points: 104773

  More actions

  July 24, 2016 at 6:49 pm

  #1891749

  Jeff Moden (7/24/2016)

  ---

  Hugo Kornelis (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  Semantically, you ALWAYS have the right to be free but sometimes you have to fight to be able to exercise that right. 😉

  Semantically (and socially) you also always have the right to be expensive, and sometimes you have to fight to excercise that right (the alternative is to work for peauts). :hehe:

  Tom
  

• djj

  SSCoach

  Points: 18831

  More actions

  July 26, 2016 at 5:49 am

  #1892012

  TomThomson (7/24/2016)

  ---

  Jeff Moden (7/24/2016)

  ---

  Hugo Kornelis (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  Semantically, you ALWAYS have the right to be free but sometimes you have to fight to be able to exercise that right. 😉

  Semantically (and socially) you also always have the right to be expensive, and sometimes you have to fight to excercise that right (the alternative is to work for peauts). :hehe:

  Walnut

• Luis Cazares

  SSC Guru

  Points: 183698

  More actions

  July 26, 2016 at 6:20 am

  #1892017

  djj (7/26/2016)

  ---

  TomThomson (7/24/2016)

  ---

  Jeff Moden (7/24/2016)

  ---

  Hugo Kornelis (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  Semantically, you ALWAYS have the right to be free but sometimes you have to fight to be able to exercise that right. 😉

  Semantically (and socially) you also always have the right to be expensive, and sometimes you have to fight to excercise that right (the alternative is to work for peauts). :hehe:

  Walnut

  Squirrel

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Y.B.

  SSChampion

  Points: 11642

  More actions

  July 26, 2016 at 8:03 am

  #1892051

  Luis Cazares (7/26/2016)

  ---

  djj (7/26/2016)

  ---

  TomThomson (7/24/2016)

  ---

  Jeff Moden (7/24/2016)

  ---

  Hugo Kornelis (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  djj (7/22/2016)

  ---

  whereisSQL? (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  Grumpy DBA (7/22/2016)

  ---

  Revenant (7/22/2016)

  ---

  Ed Wagner (7/22/2016)

  ---

  Luis Cazares (7/22/2016)

  ---

  crookj (7/22/2016)

  ---

  Red

  Blue

  Sky

  Rainbow

  Pot o' gold

  leprechaun

  Irish

  Pub

  Brawl

  Fisticuff

  Fight

  That will give you the right to be free

  Semantically, you ALWAYS have the right to be free but sometimes you have to fight to be able to exercise that right. 😉

  Semantically (and socially) you also always have the right to be expensive, and sometimes you have to fight to excercise that right (the alternative is to work for peauts). :hehe:

  Walnut

  Squirrel

  Dog

  ---

  SELECT quote FROM brain WHERE original = 1
  0 rows returned