Jeff Moden

Forum Replies Created

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

RE: Calculating values for Primary Key

Just to establish some warm fuzzies that a concurrent update won't ever interfere with the correct calculation (unique sequential number) of the MatCodeID, I would add a WITH (TABLOCKX) to 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 3, 2017 at 9:08 am

#1945251
RE: Why Scalar Functions Can Be Costly

Mickey Stuewe - Sunday, January 3, 2016 11:24 PM
Comments posted to this topic are about the item Why Scalar Functions Can...
--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 3, 2017 at 8:48 am

#1945246
RE: Why Scalar Functions Can Be Costly

Alan.B - Monday, January 4, 2016 11:16 AM
Eirikur Eiriksson (1/4/2016)
Worse still are the multi-statement table-valued functions, in fact there is no excuse...
--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 3, 2017 at 8:44 am

#1945245
RE: Remove non-unicode characters from a column

Jacob Wilkins - Friday, June 2, 2017 12:11 PM
Jason A. Long - Friday, June 2, 2017 11:45...
--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 2, 2017 at 9:58 pm

#1945234
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

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