Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,811 through 51,825 (of 59,091 total)

RE: I got burned today at a SQL Server Interview!

Heh... AC only if you were off station and the R-12's actually worked. We all know that Lithbro never worked in warm water off the Philipines... we spent 60...
--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)

March 13, 2008 at 8:47 pm

#789417
RE: Stripping out double quotes (") in bulk insert

I bought the pro copy of WINZIP... it comes with the command line version. It's only $39 US (maybe less now). No, it's not free... but it is...
--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)

March 13, 2008 at 8:29 pm

#789414
RE: How do I BULK INSERT only one or some of the fields in the row?

Sure, you could write a VBS script, a smidgen of C# or bit of Java code, or any other number of options. ALL of them will be slower than...
--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)

March 13, 2008 at 8:26 pm

#789412
RE: Application Slow

Never too late for good info... thanks for the link.
One of the things I've found is that even when you use that method to "disable" parameter sniffing, SQL Server can...
--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)

March 13, 2008 at 8:19 pm

#789408
RE: Cursor in SQl Server

Temp table and While loop is going to be almost as slow as a cursor when it comes to RBAR. The only advantage is the lack of locking 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)

March 13, 2008 at 8:08 pm

#789406
RE: Can a temporary table created with an execute statement survive that statement?

Matt Miller (3/13/2008)
Jeff Moden (3/13/2008)
They have the advantage of a "continuing scope" when compared to multiple EXEC's. You can do a lot of things to a temp table 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)

March 13, 2008 at 7:59 pm

#789403
RE: Equals verses

You're not trying to return the output to the screen are you? And, according to Matt's fine testing, ID<'X' is the fastest. I don't think a NCI will...
--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)

March 13, 2008 at 7:53 pm

#789400
RE: Export CSV and Column Headers

cziebert (3/13/2008)
Thanks Jeff, appreciate the help.
Sincerely,
Z
And I appreciate the feedback. Thanks, Z.
--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)

March 13, 2008 at 7:49 pm

#789397
RE: I got burned today at a SQL Server Interview!

Grant Fritchey (3/13/2008)
That's why they call us glowy bubble-heads....
Heh... I knew I liked you for some reason... I was the Sr. Ping Jockey forward of frame 52 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)

March 13, 2008 at 7:41 pm

#789394
RE: I got burned today at a SQL Server Interview!

Matt Miller (3/13/2008)
... military service is one of the LEAST pathetic reason.
I absolutely agree!
--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)

March 13, 2008 at 7:38 pm

#789393
RE: SELECT certain number of rows

How about an indexed view? Possibly a sorted index view. Yeah, I know, might require a TOP with an ORDER BY in a view which is normally 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)

March 13, 2008 at 7:29 pm

#789388
RE: Tools for undertaking data transformations from multiple locations

BCP or a Proc run by CmdShell with a BULK INSERT in it. Both can be scheduled by the Windows Task Scheduler.
--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)

March 13, 2008 at 11:03 am

#789216
RE: Equals verses

p.s. A thousand rows isn't really enough to show the timing difference on something like this. Try it on a million rows more than once.
--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)

March 13, 2008 at 10:56 am

#789212
RE: Equals verses

If your numbers look like "A123456" and "X123457" and you want just the "A" rows AND you want it to scream...
WHERE LEFT(somecol,1) = 'A'
Substring takes a comparitively long time compared...
--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)

March 13, 2008 at 10:54 am

#789210
RE: Export CSV and Column Headers

Try this...
SELECT d.Csv
FROM (
SELECT 'client_num,client_name,matter_num,matter_name' AS Csv,1 AS SortOrder
...
--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)

March 13, 2008 at 10:42 am

#789200

Viewing 15 posts - 51,811 through 51,825 (of 59,091 total)