Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,956 through 14,970 (of 59,097 total)

RE: Calls Incoming / Oiutgoing and Missed in one Fact table?

Yes. A "fact table" is a duplication of data that must be separately maintained. It would probably be better to create what is known as a "Partitioned View" and reference that...
--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)

June 1, 2017 at 6:03 pm

#1944990
RE: Split column value to rows.

I see a claim of working against 1.7 million rows. What does the data actually look like and what is the structure of the table that you're using for the...
--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)

June 1, 2017 at 5:39 pm

#1944987
RE: GREATEST and LEAST function

SQLArnold - Thursday, June 1, 2017 9:03 AM
dmartin 38210 , I am a huge...
--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)

June 1, 2017 at 11:26 am

#1944946
RE: Searching for text

mick burden - Tuesday, May 30, 2017 6:37 PM
Thanks Ed for that snippet, I can see many uses for it, unfortunately it's...
--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)

June 1, 2017 at 8:35 am

#1944909
RE: Adding Minutes to DATETIME2

GilaMonster - Thursday, May 21, 2009 3:50 AM
Ian Scarlett (5/21/2009)
Why it doesn't work with a datetime2 must be down to the underlying datatypes Microsoft are using internally.
Datetime is...
--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)

May 31, 2017 at 7:46 pm

#1944846
RE: Performance degraded after migrating to 2016 from 2012

sarang1183 - Friday, May 19, 2017 8:59 AM
GilaMonster - Friday, May 19, 2017 6:44 AM
--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)

May 30, 2017 at 3:02 pm

#1944638
RE: Need replacement t-sql to obtain SHOWCONTIG values

Express12 - Tuesday, May 30, 2017 8:04 AM
This older query still executes fine as it refers to the "compatibility view" called sysindexes...
--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)

May 30, 2017 at 2:16 pm

#1944626
RE: Time dimension key as HHMM (text) or HMM (int)

Personally, I wouldn't use either. Use a TIME datatype. It'll save you on a huge number of conversion problems and implicit casts in the future.
--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)

May 30, 2017 at 12:17 pm

#1944605
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Monday, May 29, 2017 8:10 AM
GilaMonster - Monday, May 29, 2017 8:05 AM
--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)

May 30, 2017 at 11:09 am

#1944594
RE: High Fragmentation - No Indices

I absolutely agree with Gail on ignoring the "fragmentation" you're seeing. Without writing a whole article about it here (Brent Ozar has several, which is where I got the idea...
--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)

May 30, 2017 at 9:10 am

#1944581
RE: Need some help with some "XML Hell" please.

This will likely be the 2nd to the last update on this wonderful community effort. Thank all of you again for the great help and ideas.
I've converted the...
--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)

May 30, 2017 at 8:50 am

#1944580
RE: Need some help with some "XML Hell" please.

Eirikur Eiriksson - Monday, May 29, 2017 2:59 PM
Ed Wagner - Monday, May 29, 2017 2:40 PM
--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)

May 30, 2017 at 8:20 am

#1944578
RE: Need some help with some "XML Hell" please.

That's a great idea, Eirikur. Simple and will have a major impact by probably reducing the amount of work that actually needs to be done to hundreds instead of tens of...
--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)

May 29, 2017 at 7:44 am

#1944487
RE: Need some help with some "XML Hell" please.

There's only one term that comes to mind after all the incredible tutelage I've received on this thread and what it has resulted in and that would be UNBELIEVABLE!
--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)

May 28, 2017 at 4:24 pm

#1944450
RE: Need some help with some "XML Hell" please.

Going for the brass ring... here's a progress report.
The following code does the "temp table" optimization that Eirikur suggested. It examined 84,817 execution plans, eliminated about 6% of...
--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)

May 28, 2017 at 3:10 pm

#1944448

Viewing 15 posts - 14,956 through 14,970 (of 59,097 total)