Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,521 through 20,535 (of 59,072 total)

RE: loading and reformatting text file data into into SQL table

oliver.morris (5/29/2015)
Hi and many thanks for your help in advance. I am looking for a way to convert the following format into a sql table. For those of you familar...
--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, 2015 at 1:21 pm

#1801825
RE: Running totals with OVER clause

Also, the TABLOCKX hint is valuable even on Temp Tables. It prevents the need for any lock escalation, which can take a bit of extra time depending on other...
--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, 2015 at 11:55 am

#1801824
RE: Running totals with OVER clause

Jason A. Long (5/30/2015)
I both agree and disagree with your comments... I do agree that the vast majority of real world cases do require partitioning, existing indexes may or may...
--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, 2015 at 11:53 am

#1801823
RE: get time difference of char datatype column value.

pspkshah (5/29/2015)
thanks, I have just made slite change in that, in place of minute, I take hour.
You really do need to heed Sean's warning on this. Do the DATEDIFF...
--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, 2015 at 11:47 am

#1801822
RE: Running totals with OVER clause

TheSQLGuru (5/30/2015)
Jason, I don't think we can call your test apples-to-apples, at least not "real-world" anyway. At least 95% of the real-world running totals cases I have ever seen are...
--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, 2015 at 9:04 am

#1801815
RE: Advanced ranking function

Nah... I think it's because you're a relative newbie to SSC and anything with an outside link is getting squashed. Of course, that didn't work on that bloody super-busy...
--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, 2015 at 12:26 am

#1801794
RE: Native Audits

Steve Jones - SSC Editor (5/22/2015)
phegedusich (5/22/2015)
One problem with SQL Audit: it's exposed to the sysadmin. This doesn't fly with our Audit department, so we use Guardium instead.
I agree 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)

May 29, 2015 at 10:00 pm

#1801793
RE: Advanced ranking function

I'll also asked then if there were a way to hide you from the automatic spam-delete and to restore your other previously deleted posts.
--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, 2015 at 9:47 pm

#1801791
RE: Advanced ranking function

Jason A. Long (5/29/2015)
Great... More missing posts... :crazy:
If anyone w/ admin privileges can find my last post on this thread (index test w/ results), please de-spam it... Because, I'm not...
--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, 2015 at 9:42 pm

#1801790
RE: Storing a Binary File in a Database

I was just taking exception to the "Far better than" statement. Coming from such an intelligent and well known person, people might actually believe that rather than "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)

May 29, 2015 at 3:37 pm

#1801757
RE: Generating Dates at Runtime

sarath.tata (5/29/2015)
Just in case somebody wants
DECLARE @StartDate DATE
DECLARE @EndDate DATE
DECLARE @RotationDays INT
SET @StartDate = '01/01/2015'
SET @EndDate = '12/31/2015'
SET @RotationDays = 4
;WITH result AS
(
SELECT DATEADD(DAY, (ROW_NUMBER()...
--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, 2015 at 9:43 am

#1801633
RE: get time difference of char datatype column value.

pspkshah (5/29/2015)
Hello friends,
how can I get time difference of the following record please help,
STARTTIME ENDTIME
3:30 PM 4:30PM
7:30 PM 8:30PM
I have tried it by below query,
SELECT CONVERT(TIME,STARTTIME,108) - CONVERT(TIME,ENDTIME,108)...
--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, 2015 at 8:35 am

#1801599
RE: Problems importing CSV files using SSIS.

Rob de Vos (5/29/2015)
I have added a Powershell step that removes the extra " chars.
I use the | symbol as field seperator which is a regex special char, so 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 29, 2015 at 7:57 am

#1801585
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

Thanks, lshanahan. That's one of the nicer compliments I've ever had on the subject. I appreciate 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)

May 29, 2015 at 12:07 am

#1801472
RE: Storing a Binary File in a Database

Solomon Rutzky (5/28/2015)
_{Now be vewy, vewy qwiet, and let's see if he takes the bait.}
I hope that adds some clarity. Take care, Solomon..
More than you know.
--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, 2015 at 11:36 pm

#1801467

Viewing 15 posts - 20,521 through 20,535 (of 59,072 total)