Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,301 through 48,315 (of 59,099 total)

RE: Missing Indexes in SQL Server 2005

Great info! I gotta try it. Thanks.
--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)

September 15, 2008 at 11:28 pm

#872133
RE: Create string from table

Cool! I'd guessed wrong. ColumnC in the orginal code wasn't prefixed by a table alias and I'd guessed it was in Table1. Thanks.
--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)

September 15, 2008 at 11:25 pm

#872131
RE: Splitting a String in SQL - Help Please!

Ummm... all those bloody REPLACE's are gonna be slow. I just thought of another way using our friends the Tally table and the "quirky update". It'll take me...
--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)

September 15, 2008 at 11:21 pm

#872130
RE: Splitting a String in SQL - Help Please!

Heh... yeah, I wouldn't want to take a call in the middle of a cold one, either.
Split functions always work, especially on a single delimiter. Obviously, your stuff has...
--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)

September 15, 2008 at 11:00 pm

#872128
RE: Splitting a String in SQL - Help Please!

BTW... as you already know, the rows you originally posted import just fine because they are, despite appearances, properly formatted CSV's. The delimiters also line up and could be...
--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)

September 15, 2008 at 10:37 pm

#872123
RE: Splitting a String in SQL - Help Please!

You want the rows you posted to be split instead of imported?
--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)

September 15, 2008 at 10:31 pm

#872121
RE: Splitting a String in SQL - Help Please!

Heh... understood... and I frequently do the same thing if the file is crap...
... but that's not what you asked.
--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)

September 15, 2008 at 9:22 pm

#872110
RE: Create string from table

Dave (9/15/2008)
Hi John - I could, but would that really be useful here? Useful enough to warrant creating a table full of fake data? Or do you think that the...
--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)

September 15, 2008 at 9:19 pm

#872109
RE: Are there equivalents in Oracle Sql ?

I found the URL I was thinking about.
http://sqlblog.com/blogs/hugo_kornelis/archive/2008/03/10/lets-deprecate-update-from.aspx
I disagree with just about everything he says there. 😉
--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)

September 15, 2008 at 8:30 pm

#872103
RE: Splitting a String in SQL - Help Please!

Sorry for the delay...
Absolutely the easiest way to read a "properly formed" CSV file is using OpenRowSet. If the file is called "ImportTest.csv" and it's stored in "C:\Temp", 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)

September 15, 2008 at 8:23 pm

#872101
RE: A Lack of SQL

Pam Brisjar (9/15/2008)
Hey Jeff - Just wanted to say I've been using your RBAR acronym in my interviews. It really gets the point across.
Glad it helps, Pam. Thanks...
--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)

September 15, 2008 at 6:17 pm

#872095
RE: Off IF...ELSE Behavior

Think of spt_Values as a "config" table for SQL Server. I just happen to know that there's a set of sequential numbers from 0 to 2047 in SQL Server...
--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)

September 15, 2008 at 6:07 pm

#872093
RE: Developers' access to dev SQL Server

Marios Philippopoulos (9/14/2008)
Jeff Moden (9/14/2008)
Depends on what type of DBA you have (see previous post). And, again, it doesn't matter if you limit the people on the Dev box...
--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)

September 15, 2008 at 5:59 pm

#872091
RE: Calculating Work Days

dulanjan (9/15/2008)
i just cut and paste from your code. (dont worry i left your name on there :D)
so yeah if you put in any consecutive saturday and sunday you get...
--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)

September 15, 2008 at 5:57 pm

#872089
RE: Are there equivalents in Oracle Sql ?

jmuldoon (9/15/2008)
Heh... imagine this... there are some folks that think the FROM clause in an UPDATE is a bad thing.
I would be interested in hearing any argument(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)

September 15, 2008 at 5:49 pm

#872087

Viewing 15 posts - 48,301 through 48,315 (of 59,099 total)