Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,736 through 9,750 (of 59,099 total)

RE: nvarchar to smalldatetime

UCDA2019 - Wednesday, March 6, 2019 5:14 AM
Researching into the unambiguous dates and asking fellow colleagues are they aware of which dates...
--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 7, 2019 at 7:02 am

#2023802
RE: The Extra Table

David Burrows - Thursday, March 7, 2019 2:14 AM
patrickmcginnis59 10839 - Wednesday, March 6, 2019 2:52 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 7, 2019 at 6:53 am

#2023800
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

eliassal - Thursday, March 7, 2019 3:19 AM
Jeff, can you please explain why you use Cross join as follows

--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 7, 2019 at 6:39 am

#2023797
RE: The Extra Table

patrickmcginnis59 10839 - Wednesday, March 6, 2019 2:52 PM
Sean Lange - Wednesday, March 6, 2019 2:27 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 6, 2019 at 3:00 pm

#2023734
RE: The Extra Table

Sean Lange - Tuesday, March 5, 2019 7:06 AM
Nice and straight forward. 22% of the people got this wrong at the time...
--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 6, 2019 at 2:09 pm

#2023726
RE: How does a cursor affect the optimizer (and the execution plan) ?

Gamleur84 - Wednesday, March 6, 2019 1:37 AM
Hi,
This is Part 2 of Slow in the Application, Fast in SSMS. How...
--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 6, 2019 at 9:42 am

#2023689
RE: Overlapping Date Ranges

shel 29143 - Tuesday, March 5, 2019 8:17 AM
That is EXACTLY what I was looking for! Thank you so much and for...
--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 5, 2019 at 12:56 pm

#2023603
RE: Turn on Scalar Permissions

loretta.antonino - Monday, March 4, 2019 7:53 PM
We lost the whole server with the hack and all of the backups with 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 5, 2019 at 12:19 pm

#2023598
RE: Week of 1st day of Year

omelo - Monday, March 4, 2019 10:44 AM
Jeff Moden - Monday, March 4, 2019 10:37 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 4, 2019 at 10:47 am

#2023463
RE: Week of 1st day of Year

The following formula will do it for you.
(DATEPART(dy,DATEADD(dd,-53684,DATEDIFF(dd,-53684,@SomeDate)/7*7+6))-1)/7+1
1. It finds the first Sunday on or previous to the given date (-53684 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)

March 4, 2019 at 10:37 am

#2023461
RE: Are the posted questions getting worse?

Beatrix Kiddo - Monday, March 4, 2019 5:03 AM
Sorry for your loss, Jeff. What a tough time many people are having right...
--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 4, 2019 at 6:59 am

#2023428
RE: get failed job per hour

It's pretty simple to find such overlapping ranges. Have a gander at the following link to learn how... just change the point of reference from months to hours.
http://www.sqlservercentral.com/articles/T-SQL/105968/
--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 4, 2019 at 6:01 am

#2023422
RE: Week of 1st day of Year

omelo - Saturday, March 2, 2019 9:10 AM
Hi, This post is old but it is related to the question I have.
I'm using ...
--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 4, 2019 at 5:58 am

#2023421
RE: Compare Two Row in the table and find what columns are changed based on idno and date

I have to admit to being strongly confused because your test data doesn't match your desired output.
For example, here's your desired output... I've pointed to two rows for...
--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 2, 2019 at 8:20 am

#2023374
RE: DBA left and they shut off his AD account

DataAnalyst011 - Friday, March 1, 2019 11:29 AM
You all are a life-saver. Thank you so much for all the advice. I've switch...
--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 1, 2019 at 5:15 pm

#2023360

Viewing 15 posts - 9,736 through 9,750 (of 59,099 total)