Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,011 through 41,025 (of 59,069 total)

RE: Large Number of Tables (1,090,000)

Actually, I'd run like hell.
--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)

November 23, 2009 at 11:15 pm

#1083294
RE: any one no where to place these 3 below statements in a CURSOR to find get info on the cursor

Dave Ballantyne (11/23/2009)
Something like this ?
Nicely done Dave. 🙂 I'll just bet that the OP's bosses will remain unswayed, though, because they probably can't figure out how it equates...
--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)

November 23, 2009 at 11:00 pm

#1083285
RE: Documentation on db work

You really should try Googling for stuff like this.
--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)

November 23, 2009 at 10:44 pm

#1083275
RE: Lengthy procedure vs Split procedure

ManoharV (11/23/2009)
Hi All,
Will there be any differences in terms of execution if i write complex functionality in single procedure or can i split them into multiple procedures.
Nope......
--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)

November 23, 2009 at 10:32 pm

#1083269
RE: Creating simple dynamic sql

You don't need dynamic sql for this...
a. SELECT * FROM Movies WHERE MovieID = @MovieID
b. SELECT * FROM Movies WHERE MovieName = @MovieName
The only time you need really need dynamic...
--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)

November 23, 2009 at 10:22 pm

#1083265
RE: why there is need of integration service?

why integration services are required ?
BWAAA-HAAAA!!!! I keep asking myself the same question. 😉
--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)

November 23, 2009 at 10:16 pm

#1083262
RE: Exporting Data to CSV file

becklery (11/22/2009)
Hi.
I think you can refer to the url below:
http://www.dotnetspider.com/resources/701-Export-Data-CSV-Excel.aspx
Heh... not exactly a T-SQL 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)

November 23, 2009 at 10:13 pm

#1083260
RE: Exporting Data to CSV file

sqlbuddy123 (11/23/2009)
Hi,
Again I got a small problem. Actually in the output .csv file 70% of rows are good but 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)

November 23, 2009 at 10:10 pm

#1083259
RE: CSV Files

Jus,
I do imports in a manner similar to what you code does. I just keep running into DBA's that don't know how to protect their system and still allow...
--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)

November 23, 2009 at 10:06 pm

#1083256
RE: Reading CSV file a line at a time using uftReadfileAsTable

smithsp17 (11/23/2009)
Hi,
I have CSV files which I'd like to load into a table using the function uftReadfileAsTable. (http://xpns.net/Examples/uftReadFileAsTable.txt). I've been able to read the first line, but am...
--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)

November 23, 2009 at 9:45 pm

#1083252
RE: Update HELP

cm62597 (11/23/2009)
I have phone numbers store in my database....I am trying to create a test database that makes all the phone numbers random instead of the real ones. How...
--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)

November 23, 2009 at 9:37 pm

#1083245
RE: Update HELP

BWAA-HAAA!!!!! C'mon guys... the cited function requires that you feed it a random number and you guys say "generate a 10 digit random number". But both of those...
--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)

November 23, 2009 at 9:21 pm

#1083241
RE: How can I improve this query or make it more consistent in execution times?

GOOGLE for "Parameter Sniffing SQL Server". I believe that's your problem.
--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)

November 23, 2009 at 9:14 pm

#1083239
RE: Conversion failure with stored procedure?

It's not the code... it's the data. You need to find out which VARCHAR data isn't valid in that column. Start with using ISDATE and go from there.
I...
--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)

November 23, 2009 at 9:09 pm

#1083237
RE: How do I compute for the total of the value in Alias vladd1, vladd2, vladd3, vladd4 or any alternative using declare statement ?

Heh... I just can't resist...
Since all of the following...
SELECT LEN(' '),
LEN(' '),
...
--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)

November 23, 2009 at 8:45 pm

#1083231

Viewing 15 posts - 41,011 through 41,025 (of 59,069 total)