Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,826 through 42,840 (of 59,102 total)

RE: differiniate quotes as data vs quotes as column identifier

Actually, there is an "automatic" method. It involves the use of a "text based" linked server. If you lookup "sp_AddLinkedServer" in BOL and then find the example with...
--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)

July 22, 2009 at 11:04 pm

#1028764
RE: Create CSV file using sp_send_dbmail with field delimiters

Ah.... very cool. Thanks for posting the test data. 🙂
I believe your problem is that you've simply included too many single quotes in QUOTENAME for the task at hand....
--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)

July 22, 2009 at 10:55 pm

#1028762
RE: Need some Cursor help...well I think it's a cursor I need

John Rowan (7/22/2009)
Yep, I didn't catch that part. Jeff's solution will give you the top 10 for each ID.
As a side note, any time my answers differ from Jeff's...
--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)

July 22, 2009 at 10:45 pm

#1028761
RE: sql query

One final question... would this be 2 or 3 occurances? If 2, why and which 2 would they be?
Emp_ID Start_Entry End_Entry...
--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)

July 22, 2009 at 10:38 pm

#1028760
RE: Index Fragmentation...

Why not just use DBCC SHOWCONTIG and save it in a table?
Also, most folks might be able to live with 30% fragmentation, but I can't... the tables I work with...
--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)

July 22, 2009 at 10:31 pm

#1028758
RE: CLR Fail to load

jqd2001 (7/22/2009)
Unless it has to do with effecient RegEx, I've not known that to be true. It would be interesting to try to solve your problem with a T-SQL...
--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)

July 22, 2009 at 10:25 pm

#1028755
RE: SQL View

frecal (7/22/2009)
Hi Jeff
that would be the correct way of recording it but probably over kill for what i am needing it for.
I am working on a data linkage project 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)

July 22, 2009 at 10:12 pm

#1028752
RE: how to degrade a database schema from 2005 to 200

Remove all of the WITH hints except for the Fill Factor.
I can't believe this isn't handled automatically when you tell it to gen the script as SQL Server 2000.
--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)

July 22, 2009 at 9:52 pm

#1028751
RE: Passing Stored Procedures "values" for IN

There are a whole lot of split functions... with extremely rare exception, if it uses a While Loop, it's slow. Don't even look at one that uses an XML...
--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)

July 22, 2009 at 9:48 pm

#1028750
RE: DBA's and Developers

There are two basic types of DBA's and they've both been described in this thread. Big corporation or small, these two types of DBA's can and do exist. ...
--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)

July 22, 2009 at 9:39 pm

#1028749
RE: Flat file to Table

John Rowan (7/22/2009)
OK, here's what I'd do:
Create a Data Flow with the following contents:
1. Flat File Source adapter to get your file info into the data flow.
2. Lookup Transform. ...
--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)

July 22, 2009 at 9:32 pm

#1028748
RE: Data Import

To the best of my knowledge, you can't. You can certainly use SSIS or DTS to transfer tables and data, but some of the datatypes won't be what you'd...
--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)

July 22, 2009 at 9:26 pm

#1028747
RE: Index scan hint

SQL Guy (7/22/2009)
Hi.
In my script, the execution plan chose index seek in one case, but I want to test it with scan without changing the index itself (because I have...
--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)

July 22, 2009 at 9:18 pm

#1028746
RE: Index scan hint

Lynn Pettis (7/22/2009)
Why? Seeks are faster than scans.
Heh... because "A developer must not guess... a developer must KNOW." 😉 It'll be a nice test.
--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)

July 22, 2009 at 9:17 pm

#1028745
RE: How do I change the structure of a table with data in it?

Folks are making it pretty hard on themselves for such a simple thing...
Just go to the DESIGN mode for the table and make whatever changes you need to. Obviously,...
--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)

July 22, 2009 at 9:15 pm

#1028744

Viewing 15 posts - 42,826 through 42,840 (of 59,102 total)