Today's Random Word!

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 14, 2015 at 5:27 am

  #1770069

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

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

• Neil Burton

  SSC-Insane

  Points: 23000

  More actions

  January 14, 2015 at 5:56 am

  #1770075

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  ---

  On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
  —Charles Babbage, Passages from the Life of a Philosopher

  How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

• djj

  SSCoach

  Points: 18831

  More actions

  January 14, 2015 at 6:27 am

  #1770084

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 14, 2015 at 8:42 am

  #1770147

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

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

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  January 14, 2015 at 1:49 pm

  #1770246

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• steve the dba

  SSCrazy

  Points: 2929

  More actions

  January 14, 2015 at 2:51 pm

  #1770263

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

• richard.strauch@infoshare-is.com

  Mr or Mrs. 500

  Points: 554

  More actions

  January 15, 2015 at 2:11 am

  #1770350

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

• Neil Burton

  SSC-Insane

  Points: 23000

  More actions

  January 15, 2015 at 2:25 am

  #1770356

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  ---

  On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
  —Charles Babbage, Passages from the Life of a Philosopher

  How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  January 15, 2015 at 2:28 am

  #1770357

  BWFC (1/15/2015)

  ---

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  Swap

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 15, 2015 at 5:30 am

  #1770419

  ChrisM@Work (1/15/2015)

  ---

  BWFC (1/15/2015)

  ---

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  Swap

  Meet

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

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  January 15, 2015 at 5:41 am

  #1770421

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  BWFC (1/15/2015)

  ---

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  Swap

  Meet

  Potato

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 15, 2015 at 5:41 am

  #1770422

  ChrisM@Work (1/15/2015)

  ---

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  BWFC (1/15/2015)

  ---

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  Swap

  Meet

  Potato

  Gravy

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

• Neil Burton

  SSC-Insane

  Points: 23000

  More actions

  January 15, 2015 at 5:44 am

  #1770424

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  BWFC (1/15/2015)

  ---

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  Swap

  Meet

  Potato

  Gravy

  Train

  ---

  On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
  —Charles Babbage, Passages from the Life of a Philosopher

  How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 15, 2015 at 5:48 am

  #1770425

  BWFC (1/15/2015)

  ---

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  BWFC (1/15/2015)

  ---

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  Swap

  Meet

  Potato

  Gravy

  Train

  Robbery

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

• djj

  SSCoach

  Points: 18831

  More actions

  January 15, 2015 at 6:25 am

  #1770437

  Ed Wagner (1/15/2015)

  ---

  BWFC (1/15/2015)

  ---

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  Ed Wagner (1/15/2015)

  ---

  ChrisM@Work (1/15/2015)

  ---

  BWFC (1/15/2015)

  ---

  richxs (1/15/2015)

  ---

  Giraffe DBA (1/14/2015)

  ---

  SQLRNNR (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  djj (1/14/2015)

  ---

  BWFC (1/14/2015)

  ---

  Ed Wagner (1/14/2015)

  ---

  Stuart Davies (1/14/2015)

  ---

  TomThomson (1/13/2015)

  ---

  Ed Wagner (1/13/2015)

  ---

  SQLRNNR (1/13/2015)

  ---

  regex

  Pattern

  Match

  Point

  Edge

  Bono

  Sonny

  Cher

  Babe (i've got you ...)

  Ruth

  Sultan

  Swing

  Swap

  Meet

  Potato

  Gravy

  Train

  Robbery

  Abscond