Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,271 through 18,285 (of 59,070 total)

RE: How to Split a a single Date into potentially hundreds of new date Values

I can give you a pretty easy example that will be easy for you to incorporate and that doesn't use any RBAR. My question is, what's in the "[STG_JobHistory].[Duration_SEC]...
--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)

February 26, 2016 at 4:02 pm

#1861586
RE: CAST tinyint to nvarchar

Orlando Colamatteo (2/26/2016)
Steve Jones - SSC Editor (2/26/2016)
BOL does note this will return an error, but the "E" in the chart is very misleading. I'd say this is one 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)

February 26, 2016 at 10:21 am

#1861471
RE: How to query a Denormalised table

richardsonkane75 (2/26/2016)
The data is present in the same table so there is no need for any joins, hence the selects are very fast.
A single table with all the required data...
--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)

February 26, 2016 at 10:18 am

#1861469
RE: Public Data Sets

Steve Jones - SSC Editor (2/26/2016)
ThomasRushton (2/26/2016)
I rather like the UK Electoral Commission's data sets on voting.
Added, and if you'd like to show how to get data from here and...
--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)

February 26, 2016 at 8:54 am

#1861428
RE: Can a SQL Agent successfully run a job step that deletes that job?

Yes... you can make a "self-deleting" job. When you're setting up, look under "Notifications" for the "Automatically Delete Job" check box.
--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)

February 26, 2016 at 8:48 am

#1861425
RE: Public Data Sets

Here's an interesting site by NANPA, the North American Numbering Plan Association. Lot of different things concerning telephony, specifically about NPA/NXX (area code/exchange), etc.
https://www.nationalnanpa.com/reports/reports_cocodes.html
Most interesting, fun to play with,...
--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)

February 26, 2016 at 7:12 am

#1861384
RE: CAST tinyint to nvarchar

Ed Wagner (2/26/2016)
gareth.davison (2/26/2016)
According to CAST and CONVERT, an E should be returned, but that is not the case.
Below the table where it states that "E" will be returned there...
--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)

February 26, 2016 at 6:51 am

#1861379
RE: Find and Remove Duplicate Records SQL Server

patrickmcginnis59 10839 (2/3/2016)
Jeff Moden (2/2/2016)
andy_111 (1/31/2016)
Not really useful article.
Not really a useful comment, either. Please explain why you think it's not useful.
I have to agree with andy_111's sentiment, he...
--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)

February 25, 2016 at 8:34 pm

#1861316
RE: Converting VARCHAR to BIGINT

Luis Cazares (2/25/2016)
If by any chance you're working with SQL Server 2012 or later, you can use TRY_CAST or TRY_CONVERT.
Have you compared it for performance?
--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)

February 25, 2016 at 8:28 pm

#1861315
RE: SQL backup best practices

Lwestcott 17148 (2/25/2016)
I'm a newbie to SQL server and I'm not sure if I'm posting this correctly so please let me know if I have it wrong.
What is 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)

February 25, 2016 at 2:25 pm

#1861259
RE: Audit Trigger firing twice

deadtrees (2/25/2016)
@jeff
Fair enough, but this was a 'database that proved to be too useful' scenario. As a result it's getting picked up to get turned into an enterprise application...
--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)

February 25, 2016 at 1:48 pm

#1861246
RE: Are the posted questions getting worse?

Grant Fritchey (2/24/2016)
Jeff Moden (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
SQLRNNR (2/24/2016)
GilaMonster (2/24/2016)
jasona.work (2/24/2016)
http://www.sqlservercentral.com/Forums/Topic1763775-3412-1.aspx
/Me leans back, grabs bucket of popcorn
Sure sounds like Gail answered the original question, yet for some reason the OP decided...
--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)

February 25, 2016 at 1:41 pm

#1861243
RE: A Good Use for Hadoop

Steve Jones - SSC Editor (2/25/2016)
Jeff Moden (2/25/2016)
Apparently, all that predictive analysis with a PB per day didn't do squat for Netflix. Their stock dropped from a high 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)

February 25, 2016 at 1:32 pm

#1861240
RE: Audit Trigger firing twice

deadtrees (2/25/2016)
I found some great Audit trigger code on the interwebs ...
No sir... that's some of the worst audit code ever. It's one of those damned "generic" triggers 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)

February 25, 2016 at 10:54 am

#1861176
RE: string question

astrid 69000 (2/25/2016)
yes, i do, cause it was similar to what i had and i was missing what length to count.
i do check 😉
thanks again 🙂
You bet and thank you...
--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)

February 25, 2016 at 10:47 am

#1861168

Viewing 15 posts - 18,271 through 18,285 (of 59,070 total)