Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,021 through 52,035 (of 59,102 total)

RE: Varchar(max) problem in SQL server 2005

chris.compton (3/7/2008)
I would be interested in hearing about a re-test of the VarChar(7000) vs. VarChar(Max). (which I don't have time to do or I would)
It is my understanding that...
--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 7, 2008 at 8:15 pm

#787005
RE: Creating assembly

The assembly (dll) just calculates the companies holidays.
Curious... did you know that a T-SQL function will likely run just as fast here and a properly formed Calendar table will out...
--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 7, 2008 at 4:13 pm

#786975
RE: Where are stored the stored procedures?

I missed that in Adam's post (too much of a hurry). He's absolutely correct.
Only problem is, this is an SQL Server 2k post... Adam's solution uses VARCHAR(MAX) which isn'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)

March 7, 2008 at 4:07 pm

#786973
RE: Can I Do a Select *FROM StoredProcedure ??

All right smarty....He's pointing at the BOL entry for OPENQUERY...
Heh... truth be told, I didn't even look once he said it was in Spanish.
--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 7, 2008 at 4:02 pm

#786969
RE: CSV file format export and leading zeroes.

Ray White (3/7/2008)
I would like to retain a leading zero on decimal output.
IE I would like 0.4567 vs .4567; The only way I can think of doing this is to...
--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 7, 2008 at 3:57 pm

#786968
RE: SELECT Statement Question

robertafricker (3/7/2008)
Hi Jeff,
Thanks for weighing in re: Lynn's rewrite. Now, it makes more
sense to me, that hanging "IN" was throwing me off!
I'll be sending through some far meatier examples...
--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 7, 2008 at 3:50 pm

#786963
RE: Where are stored the stored procedures?

...or... if you just want the names of the objects so you can go look at them...
--===== Find name of proc, view, function, etc containing text in DDL
SELECT DISTINCT...
--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 7, 2008 at 3:26 pm

#786958
RE: How to get Client Records from a database

If it's a one time thing only... why not change the text window to use tabbed delimiters and tell it to save to a file?
--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 7, 2008 at 3:17 pm

#786951
RE: Creating assembly

Heh... it's the SQL gods telling you that you should solve the problems in T-SQL instead of writing a CLR 😀
--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 7, 2008 at 3:14 pm

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

ScottPletcher (3/7/2008)
Well, I guess it's nice to see that there are still places where low standards prevail and former govt employees can find actual work.
Low standards? Former Govt employees?...
--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 7, 2008 at 3:10 pm

#786946
RE: How do I replace data in column A with the data from column B?

Sure, you can use LEFT 10 to do that... but stop just for a minute... you've not told us why you want to overwrite the ID with the Description. ...
--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 7, 2008 at 3:00 pm

#786940
RE: Adding the time to a Date(DateTime)

It sounds to me like the DateDebut column is a VARCHAR column and could be in the dd/mm/yyyy format instead of the format you're expecting of mm/dd/yyyy.
--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 7, 2008 at 2:48 pm

#786932
RE: How do I replace data in column A with the data from column B?

Hold the phone... how do you know that the only things that start with VA are VA- as in Virginia... never do an update of this nature without first doing...
--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 7, 2008 at 2:43 pm

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

Wow this thread reminds me of my last interview. I was asked what is the fastest way to clear a table.
BWA-HA-HA-HA!!! Oh, the poor fools that last asked 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)

March 7, 2008 at 2:22 pm

#786917
RE: Openrowset Bulk Insert

The reason why you have to do it with Dynamic SQL is because it will not allow you to do formulas in the query. The Query must be "hard...
--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 7, 2008 at 1:15 pm

#786882

Viewing 15 posts - 52,021 through 52,035 (of 59,102 total)