Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,201 through 22,215 (of 59,098 total)

RE: How to format unformated phone numbers Please...,

Oh, I definitely agree, Kevin. Sometimes you do have to play with the cards you're dealt. I do try to get the dealer to deal better cards, though.
So,...
--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)

December 21, 2014 at 2:15 pm

#1765893
RE: Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

Thanks, Gabe. 🙂
--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)

December 21, 2014 at 2:11 pm

#1765892
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (12/19/2014)
SQLRNNR (12/19/2014)
Steve Jones - SSC Editor (12/19/2014)
Merry Christmas and Happy Holidays, everyone.
I'll be gone after tomorrow, heading away for a week. Everyone behave.
Yay -...
--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)

December 21, 2014 at 1:21 pm

#1765891
RE: What To Do When the Import and Export Wizard Fails - Part II Exports

Divine Flame (12/18/2014)
Yakov Shlafman (12/18/2014)
Thanks for your input. What do you mean by saying Actual Information was lost? How do you like this saying: Make everything as simple as possible,...
--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)

December 18, 2014 at 8:32 am

#1765489
RE: Need Help Writing a SQL Query that can provide a 6 Month Forecast

Lee Polikoff (12/17/2014)
Background is that I am recreating charts in SSRS that were being created in Excel. The source data is residing in a SQL Server database. I'm having a...
--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)

December 17, 2014 at 1:55 pm

#1765283
RE: Calculating Last 5 Business Days and Next 5Days

jshuter (12/17/2014)
I understand the need to use SQL when doing SQL but a little looping wont kill ya 🙂
I know thousands of people that agree with you... they've all...
--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)

December 17, 2014 at 1:23 pm

#1765274
RE: Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

Phil Parkin (12/17/2014)
... though I would not categorise a CROSS JOIN as advanced.
Heh... you're also not a neophyte, Phil. All the "heavy hitters" take it for granted. ...
--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)

December 17, 2014 at 7:08 am

#1765168
RE: Designing a "Web" dashboard to monitor SQL Server Jobs

Brandie Tarvin (12/17/2014)
So I have it in my head to design a webpage that my team can pull up at month end and, at a glance, tell what jobs have...
--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)

December 17, 2014 at 6:59 am

#1765164
RE: Are the posted questions getting worse?

Koen Verbeeck (12/17/2014)
Brandie Tarvin (12/17/2014)
Brandie Tarvin (12/16/2014)
WHOO! #HappySnoopyDance
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8...
--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)

December 17, 2014 at 6:50 am

#1765162
RE: Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

From the Article:
CREATE TABLE Cust (Id int, CustName varchar(20));
CREATE TABLE Sales (Id int identity
...
--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)

December 17, 2014 at 1:56 am

#1765094
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/16/2014)
Jack Corbett (12/16/2014)
Stefan Krzywicki (12/16/2014)
Eirikur Eiriksson (12/16/2014)
Stefan Krzywicki (12/16/2014)
Eirikur Eiriksson (12/16/2014)
Jeff Moden (12/16/2014)
Steve Jones - SSC Editor (12/15/2014)
Jeff Moden (12/14/2014)
In the category of learning something new,...
--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)

December 16, 2014 at 5:38 pm

#1765063
RE: Are the posted questions getting worse?

Brandie Tarvin (12/16/2014)
WHOO! #HappySnoopyDance
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.
Current execution...
--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)

December 16, 2014 at 5:22 pm

#1765062
RE: SQL Server replace cursor that iterates through X Accounting DBs

Luis Cazares (12/15/2014)
There's a different method but with up to 200 databases the validations can become complex and the improvement is unnoticeable. This is one of those occasions where a...
--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)

December 16, 2014 at 8:06 am

#1764942
RE: Are the posted questions getting worse?

Gosh. I can't believe that the Hierarchies On Steroids #1 article made it to the "Bacon" list on the Tribal Awards. I wouldn't mind winning that one. ...
--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)

December 16, 2014 at 7:57 am

#1764939
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/15/2014)
Jeff Moden (12/14/2014)
In the category of learning something new, I just did some testing on the differences between ONLINE and OFFLINE index rebuilds because of a post I...
--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)

December 16, 2014 at 7:49 am

#1764935

Viewing 15 posts - 22,201 through 22,215 (of 59,098 total)