Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,641 through 23,655 (of 59,099 total)

RE: Comma Separator Delimiter

Agreed. It's not going to matter with such short strings as those on this post. It was more of a tip just in case you need to do...
--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 15, 2014 at 6:35 pm

#1714063
RE: Comma Separator Delimiter

Luis Cazares (5/15/2014)
crmitchell (5/15/2014)
farooq.hbs (5/14/2014)
I found the solution..
LEFT([field], CHARINDEX(',', [field]) - 1)
:):):)
Thanks:-):-):-):-)
That will work if you are certain that your source string will ALWAYS contain at least one comma....
--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 15, 2014 at 5:31 pm

#1714060
RE: Cursors

Stefan Krzywicki (5/15/2014)
spaghettidba (5/15/2014)
Stefan Krzywicki (5/15/2014)
"The old mainframe database I used back in diggity six was blazing fast when using cursors! SQL Server is terrible!"
Hmmm, yeah.
I had the chance...
--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 15, 2014 at 5:29 pm

#1714057
RE: Cursors

spaghettidba (5/15/2014)
Stefan Krzywicki (5/15/2014)
"The old mainframe database I used back in diggity six was blazing fast when using cursors! SQL Server is terrible!"
Hmmm, yeah.
I had the chance to optimize...
--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 15, 2014 at 5:25 pm

#1714056
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Paul White (5/14/2014)
Is everyone running Jeff's original/updated test rig from the article to get these results?
If so, you might not be testing what you think you are. There is a...
--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 15, 2014 at 5:01 pm

#1714052
RE: Master thesis on Business Intelligence

I believe that a very import question has been left off the survery (or maybe I just didn't see it)... "To what extent is BI a part of your job?...
--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 14, 2014 at 7:51 pm

#1713669
RE: Can you create a partition on an existing Fact table?

skaggs.andrew (5/14/2014)
Hi All,
I have a Fact table that has been in use for 2 years now and I am getting to the point where the table is beginning to get...
--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 14, 2014 at 2:15 pm

#1713619
RE: Is there a better way to constuct this reverse Wildcard Select statement

mpdillon (5/14/2014)
Scott, Thanks for the confirmation.
Jeff, I tried the [0-9] and it worked. I am not sure if there is a performance gain. This query will not be used very...
--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 14, 2014 at 7:43 am

#1713467
RE: Can you use Lag to avoid recursive CTEs?

As to noticing that rCTEs produce a lot of reads, it's because it's "just" a loop that's nearly identical to reading the first row and then looping through all 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)

May 13, 2014 at 5:39 pm

#1713283
RE: Since Triggers are a contentious subject, can someone please tell me if mine is written correctly?

The problem with indexed views isn't during SELECT's. The problem with indexed views is with inserts to the underlying tables and the bigger the data gets, the longer 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 13, 2014 at 5:23 pm

#1713279
RE: Is there a better way to constuct this reverse Wildcard Select statement

mpdillon (5/13/2014)
I am trying to find all the patterns that match a specific item number. This is the reverse of what I usually do, find All the Item Numbers 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)

May 13, 2014 at 5:18 pm

#1713276
RE: Create Clustered Index on a Very Large Table (500 GB)

Jeff Moden (5/13/2014)
-A (5/12/2014)
Jeff Moden (5/12/2014)
-A (5/7/2014)
Thanks for the replays.
--Here is the answers to the follow up questions:
1) I have to create this Index online since it is huge 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)

May 13, 2014 at 5:08 pm

#1713274
RE: xp_cmdshell works and then doesn't work

Ed Wagner (5/13/2014)
JustOffal - I'm incredibly curious about this one, too. Please post the command and the output.
Jeff - You know I'm thinking of your presentation that isn't ready...
--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 13, 2014 at 5:03 pm

#1713273
RE: Create Clustered Index on a Very Large Table (500 GB)

Thanks, Kevin. Now THAT's an interesting bit of information. I can see it being a benefit to INSERT performance as well since a heap on a temporal audit...
--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 13, 2014 at 9:02 am

#1713112
RE: Partitioned Heap

Thanks for the reply, Howard. That's pretty much my opinion, as well, and I've also constructed my temporal audit tables in the same manner that you have. 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 13, 2014 at 8:40 am

#1713096

Viewing 15 posts - 23,641 through 23,655 (of 59,099 total)