Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,841 through 21,855 (of 59,072 total)

RE: Help With Trying to Import File Names into a Table

Eirikur Eiriksson (1/17/2015)
Jeff Moden (1/16/2015)
Samuel Vella (1/16/2015)
Jeff Moden (1/15/2015)
No problem. Thank you very much for your efforts.
I have to admit that when it comes to SSIS, I get totally...
--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)

January 17, 2015 at 7:31 am

#1770951
RE: Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

h.tobisch (1/16/2015)
PLEASE, could you, just in one sentence, tell the essence of what you are doing ?
Short circuit a query using a SARGable predicate to take advantage of the index...
--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)

January 16, 2015 at 7:39 pm

#1770934
RE: Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

Hi Dwain,
Great article, as usual. It spawned some pretty good discussion, as well. Well done and thanks for taking the time to write something like this.
I did find...
--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)

January 16, 2015 at 7:38 pm

#1770933
RE: How to ignore "String or binary data would be truncated"

<Head-Desk> I'm obviously sleeping. I total missed the fact that the history table has an active IDENTITY column in it. The column offset by using SELECT *...
--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)

January 16, 2015 at 7:08 pm

#1770932
RE: Tipping point for a numbers table vs inline tally

sqldriver (1/16/2015)
Well, it looks like jokers and deuces are wild here.
Heh... nah. King with the axe and one-eyed jacks. 😉
--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)

January 16, 2015 at 7:03 pm

#1770931
RE: Are the posted questions getting worse?

Lynn Pettis (1/16/2015)
Sometimes trying to get answers from people is like pulling chicken teeth.
Heh... do like I do. I avoid the barnyard if I can. I don't try...
--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)

January 16, 2015 at 5:43 pm

#1770927
RE: How to ignore "String or binary data would be truncated"

To be sure, the point I'm trying to make is that this error happens for a reason. You say there are a lot of columns in this table... 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)

January 16, 2015 at 5:01 pm

#1770921
RE: Export SQL Data to CSV using Batch Scripting

venkyzrocks (1/16/2015)
Hi,
Here's the issue I'm having.
1. the bcp output doesn't include headers
So, make some using a separate SELECT UNION ALL
2. the sql is too long to be included in...
--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)

January 16, 2015 at 1:34 pm

#1770891
RE: Tipping point for a numbers table vs inline tally

Eirikur Eiriksson (1/16/2015)
Jeff Moden (1/16/2015)
sqldriver (1/16/2015)
You guessed right on the seconds 🙂
"Lawyers" and their "billable hours"; we should all be so lucky.
Oh my word! That's bloody well insane. :hehe:...
--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)

January 16, 2015 at 1:23 pm

#1770888
RE: How to ignore "String or binary data would be truncated"

halifaxdal (1/16/2015)
Jeff Moden (1/16/2015)
halifaxdal (1/16/2015)
no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.
based on...
--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)

January 16, 2015 at 11:42 am

#1770848
RE: How to ignore "String or binary data would be truncated"

halifaxdal (1/16/2015)
no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this issue.
based on your table, only...
--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)

January 16, 2015 at 10:04 am

#1770815
RE: Create a script to search for a missing word or a phrase

T.Ashish (1/16/2015)
Hi all,
We compulsorily use NOLOCK in our scripts on reporting DB and development generally forget putting NOLOCKS or schema names with tables.
Can anybody guide me in creating 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)

January 16, 2015 at 9:51 am

#1770810
RE: Help With Trying to Import File Names into a Table

Samuel Vella (1/16/2015)
Jeff Moden (1/15/2015)
No problem. Thank you very much for your efforts.
I have to admit that when it comes to SSIS, I get totally lost because I don't...
--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)

January 16, 2015 at 9:47 am

#1770808
RE: Help With Trying to Import File Names into a Table

Lempster (1/16/2015)
Jeff Moden (1/15/2015)
Shifting gears on this same subject, let's have some fun and do a cooperative exploratory on a very typical spreadsheet import problem.
I've attached a spreadsheet (Sample Spreadsheet...
--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)

January 16, 2015 at 9:35 am

#1770803
RE: Help With Trying to Import File Names into a Table

Samuel Vella (1/16/2015)
On the subject of T-SQL vs SSIS
SSIS shines when you have a lot of data outside of a database which needs manipulation before you load it into tables....
--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)

January 16, 2015 at 9:30 am

#1770801

Viewing 15 posts - 21,841 through 21,855 (of 59,072 total)