Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,186 through 34,200 (of 59,099 total)

RE: Normalization

Welsh Corgi (4/23/2011)
It is customary to have an Address1 and Address2 Line when it is the same entity, for example Address Contains the Street Number and Name and Address two...
--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)

April 23, 2011 at 3:46 pm

#1315202
RE: Online Indexing

Jack Corbett (4/23/2011)
...you should not make blanket statements...
Heh... I've got a blanket statement... as always, "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)

April 23, 2011 at 3:13 pm

#1315194
RE: Is SSIS actually useful?

Steve Jones - SSC Editor (4/23/2011)
As a general rule, I don't allow it, especially for non-sysadmins.
As a general rule, I agree and I don't normally allow humans , regardless or...
--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)

April 23, 2011 at 2:51 pm

#1315193
RE: Is SSIS actually useful?

Edit: I should add, Jeff, I'm trying to prompt you into teacher mode a little on this. I'm not going to claim expertise on any of the older tools.. heck,...
--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)

April 23, 2011 at 2:36 pm

#1315191
RE: Is SSIS actually useful?

Craig Farrell (4/23/2011)
I was thinking more along the lines of fixed width files for the format files then column skips.
Files with fixed width fields are no more difficult with BCP/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)

April 23, 2011 at 2:14 pm

#1315188
RE: Recursive query for a Bill of Materials table

For more of a visual impact....
--===== Conditionally drop the test table to make reruns in SSMS easier.
-- (Note that this is NOT a part 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)

April 23, 2011 at 1:10 pm

#1315165
RE: Recursive query for a Bill of Materials table

Greg Snidow (4/22/2011)
Jeff/Dave - I've actually used the BOL example as a template for several procedures since this post began, and I am very interested in learning of the solution...
--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)

April 23, 2011 at 1:04 pm

#1315163
RE: Is SSIS actually useful?

Understood. But the "old school" ways do work quite nicely including such things as you mention like incrementing file names, etc, etc. And, there's usually no need for...
--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)

April 23, 2011 at 11:55 am

#1315151
RE: hierarchyid traversing the tree.

Heh... Yep. In fact, that's such a common request that I wrote an "SQL Spackle" article on the subject. Please see the following link...
http://www.sqlservercentral.com/articles/T-SQL/72503/
--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)

April 23, 2011 at 11:20 am

#1315147
RE: Running Total's CTE Challenge

Fraggle-805517 (4/22/2011)
Jeff Moden (4/22/2011)
Shifting gears, if you still need help with this, let me know and I'll see what I can do over the weekend.
Below is what I ended up...
--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)

April 23, 2011 at 12:20 am

#1315094
RE: "SET SCIENTIFIC NOTATION OFF"

r.vanlaake-1086273 (4/22/2011)
Not yet. I hoping to do some experiments with 64 bit ACE over this upcoming weekend. Thanks for the feedback on the 32 bit stuff. I'm glad they didn'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)

April 22, 2011 at 6:35 pm

#1315070
RE: Date function in sql server 2005

getalok_akg (4/22/2011)
Hi Alll,
We have requirement to calculate the last data of the corresponding week .
Let me explain you the scenario , we are having time table that update on daily...
--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)

April 22, 2011 at 6:10 pm

#1315068
RE: Is SSIS actually useful?

I guess I'll have to flip them back, then. I use BCP, SQLCmd, T-SQL and my old and dearly beloved ETL friend, xp_CmdShell especially when flat files for import...
--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)

April 22, 2011 at 5:14 pm

#1315063
RE: Impersonation in a Proc but not for the user running it

AlexSQLForums (4/22/2011)
Jeff Moden (4/22/2011)
Thanks for the response, Alex, but won't that simply disable the ability of the proxy to use xp_CmdShell at all levels?
So is this proxy user also 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)

April 22, 2011 at 4:53 pm

#1315060
RE: difference between sp and udf

It sounds like an interview or homework question but I'll cough up what I believe are the most important...
A Table Valued Function can be used in the FROM of 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)

April 22, 2011 at 10:51 am

#1314947

Viewing 15 posts - 34,186 through 34,200 (of 59,099 total)