Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,451 through 15,465 (of 59,101 total)

RE: Find out consecutive date difference by comparing with master table

jcelko212 32090 - Monday, March 13, 2017 10:24 AM
You also got the display format for dates wrong; the only format allowed in...
--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)

March 13, 2017 at 4:10 pm

#1932969
RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Monday, March 13, 2017 11:17 AM
Jeff Moden - Saturday, March 11, 2017 8:42 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)

March 13, 2017 at 3:50 pm

#1932965
RE: Need Correct Index for slow query

Do NOT convert your TEXT columns to NVARCHAR(MAX). It's a waste of disk space, memory, and IO because NVARCHAR uses two characters per byte instead of just one. You would...
--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)

March 12, 2017 at 11:56 am

#1932841
RE: Encapsulating complex logic without using a scalar UDF

jcelko212 32090 - Thursday, March 9, 2017 3:35 PM
You are treating a UDF the way you would have written code in COBOL,...
--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)

March 11, 2017 at 8:42 pm

#1932821
RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Friday, March 10, 2017 2:26 PM
Jeff Moden - Monday, March 6, 2017 8:46 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)

March 11, 2017 at 7:28 am

#1932813
RE: Need SQL query to get hierarchical structure of Employees

acmedeepak - Thursday, March 9, 2017 9:19 AM
I have a table with two columns:
Employee, Superior with their names in it.
Now, 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)

March 10, 2017 at 6:50 pm

#1932807
RE: SQL Server 2016 DBA Training

Thanks, Daniel. I'll look into it.
--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)

March 10, 2017 at 10:49 am

#1932770
RE: How to overcome the identity column "jump 1000" issue

Sean Lange - Friday, March 10, 2017 9:13 AM
ScottPletcher - Friday, March 10, 2017 9:02 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)

March 10, 2017 at 10:44 am

#1932769
RE: need help writing the codes for this

sergehermane - Thursday, March 9, 2017 7:29 PM
1 - Write a query witch returns the following columns:
2 - a- OrderID
...
--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)

March 9, 2017 at 9:08 pm

#1932641
RE: Today's Random Word!

ZZartin - Thursday, March 9, 2017 2:58 PM
Ed Wagner - Thursday, March 9, 2017 1:26 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)

March 9, 2017 at 9:03 pm

#1932639
RE: Are the posted questions getting worse?

SQLRNNR - Thursday, March 9, 2017 11:31 AM
Hugo Kornelis - Thursday, March 9, 2017 1: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)

March 9, 2017 at 8:16 pm

#1932637
RE: SQL Server 2016 DBA Training

daniel.dolan - Thursday, March 9, 2017 7:07 AM
I recently took a 1 week bootcamp with Certification Camps in Sarasota, FL. All inclusive...
--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)

March 9, 2017 at 7:53 pm

#1932634
RE: How to overcome the identity column "jump 1000" issue

Yep... me too, Scott. Decades of experience. Just, apparently, different experience and that's the key here. "It Depends".
--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)

March 9, 2017 at 7:51 pm

#1932633
RE: How to overcome the identity column "jump 1000" issue

ScottPletcher - Thursday, March 9, 2017 11:53 AM
More than 50% of the time, identity is the wrong clustering key, because there's another...
--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)

March 9, 2017 at 4:17 pm

#1932626
RE: Create Indexes on Computed Columns

nsadams87xx - Tuesday, March 7, 2017 11:47 AM
Once Persisted, won't this also start causing fragmentation in the index if the values change?
Fragmentation...
--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)

March 8, 2017 at 8:33 pm

#1932448

Viewing 15 posts - 15,451 through 15,465 (of 59,101 total)