Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,906 through 13,920 (of 59,101 total)

RE: Parse Data from a Field Containing Multiple Values using CROSS APPLY

Stan,
The string splitter that you have use is a "String Nibbler". Because it uses a WHILE loop, it's quite slow even for relatively small stuff. As previously suggested, please see...
--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)

October 30, 2017 at 8:00 am

#1965767
RE: Parse Data from a Field Containing Multiple Values using CROSS APPLY

vl1969-734655 - Monday, October 30, 2017 5:54 AM
I kind of have an issue with this statement .
By definition, a flat file...
--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)

October 30, 2017 at 7:41 am

#1965762
RE: Parse Data from a Field Containing Multiple Values using CROSS APPLY

SFlucke - Monday, October 30, 2017 2:27 AM
Hi, Stan!
Quite a not so rare problem - and up from SQL Server 2016/ databases...
--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)

October 30, 2017 at 7:26 am

#1965761
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Sunday, October 29, 2017 5:41 PM
I don't know how you do it or what you see that 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)

October 29, 2017 at 7:50 pm

#1965712

RE: Fun with Dates

RoNoS - Friday, October 27, 2017 2:02 AM

But why:

        

        
            
            
                        

            





Jason A. Long - Sunday, October 29, 2017 3:15 AM


Okay... where to begin???

First... I haven't been putting this off... the exact opposite actually....





--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)


                    

        
            October 29, 2017 at 12:21 pm
            #1965702

RE: Handling string column with dates

Thom A - Saturday, October 28, 2017 3:17 PM

Jeff Moden - Saturday, October 28, 2017 2:53 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)

October 28, 2017 at 5:19 pm

#1965686
RE: What else can take up space in a database besides tables

Heh... Right now I'm thinking, "Check-valve".

--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)

October 28, 2017 at 3:53 pm

#1965685
RE: Help in analyzing deadlock and index recommendation - all definitions included

Santhoshkumar KB - Friday, October 13, 2017 7:38 AM

Interestingly all the deadlocks (around 70+) from past 2 days are showing
ridlock fileid=4...

--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)

October 28, 2017 at 3:44 pm

#1965684
RE: select top(100) percent

Lynn Pettis - Friday, October 20, 2017 3:03 PM

sgmunson - Friday, October 20, 2017 2:02 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)

October 28, 2017 at 3:07 pm

#1965682
RE: Handling string column with dates

GrassHopper - Friday, October 20, 2017 2:49 PM

Thom A - Friday, October 20, 2017 12:21 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)

October 28, 2017 at 2:53 pm

#1965681
RE: Which is the end?

I still think it hilarious (I laughed almost hysterically when I first heard of it) , in a dreadful sort of way, that they took the time to create a function...

--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)

October 28, 2017 at 2:10 pm

#1965680
RE: Bulk load architecture

sqlenthu 89358 - Friday, October 27, 2017 2:06 AM

I think I will have to get bulk admin administrator role for my...

--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)

October 28, 2017 at 11:13 am

#1965679
RE: Bulk load architecture

Phil Parkin - Friday, October 27, 2017 5:57 AM

Jeff Moden - Thursday, October 26, 2017 9:09 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)

October 28, 2017 at 11:07 am

#1965678
RE: SQL versus program

patrickmcginnis59 10839 - Friday, October 27, 2017 6:44 AM

Jeff Moden - Thursday, October 26, 2017 8:08 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)

October 28, 2017 at 10:52 am

#1965676

Viewing 15 posts - 13,906 through 13,920 (of 59,101 total)