Jeff Moden

Forum Replies Created

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

RE: Master thesis on Business Intelligence

amela.ajanovic90 (5/16/2014)
Thanks to everyone who filled out the questionnaire! I have posted on non technical sites as well, we have around 70 responses so far, but of course, the more...
--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 16, 2014 at 11:35 am

#1714271
RE: Cursors

Stefan Krzywicki (5/15/2014)
Absolutely Jeff. My problem is that we're a SQL shop and he admits SQL cursors are horrible. I don't have access to other systems to show they're horrible...
--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 7:16 pm

#1714067
RE: Bulk load data conversion error (truncation) ... I don't care if it truncates

J M-314995 (5/15/2014)
Right now I'm using SSMS but when I get everything put together, I'm going to throw the script into an SSIS package and put it on a schedule.
BULK...
--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:57 pm

#1714065
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

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