Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,436 through 54,450 (of 59,072 total)

RE: Adding workdays

Yep... mine definetly fails for different languages... that's why I said you need to modify it for other languages. 😀
Ken's DATEFIRST solution would fix 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)

October 23, 2007 at 7:40 am

#744529
RE: Pivot Table Help Needed

mrpolecat (10/23/2007)
Just for S&G I removed your index completely and it didn't change performance time. Still 20 seconds. Here is the table I am using to test 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)

October 23, 2007 at 7:29 am

#744517
RE: Pivot Table Help Needed

rog pike (10/23/2007)
RAC will never be amongst the fastest solutions. It is a simple tradoff, performance for functionality. RAC does not build a single SELECT statement to execute against 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)

October 23, 2007 at 7:15 am

#744505
RE: Pivot Table Help Needed

mrpolecat (10/23/2007)
Peter Larsson (10/23/2007)
I also lack the oppurtunity to call the SP twice in a row.
I get an error "index already exists".
I thnk it would make sense to move 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)

October 23, 2007 at 7:10 am

#744499
RE: Pivot Table Help Needed

Peter Larsson (10/23/2007)
I also lack the oppurtunity to call the SP twice in a row.
I get an error "index already exists".
I'll check it out, Peter... thanks for the feedback.
--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)

October 23, 2007 at 7:07 am

#744495
RE: Pivot Table Help Needed

Sandy (10/23/2007)
Hey Jeff :),
Great Standard of Code,
I really feel its the way need to be done.
but i have a small issue here,
when i am trying to copy your code...
--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)

October 23, 2007 at 7:03 am

#744490
RE: Pivot Table Help Needed

Peter Larsson (10/23/2007)
Jeff, excellent code but I think you should start using QUOTENAME function for those having brackets, spaces or even single quotes in their table/column names.
Yep... that would work,...
--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)

October 23, 2007 at 7:03 am

#744488
RE: Pivot Table Help Needed

Fixed that... thanks for the observation... I always hate coverting working code into instructional code... I mess it up almost every time :hehe:
--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)

October 23, 2007 at 12:08 am

#744326
RE: Saving binay data to disk via TSQL???

Now you know why I don't let images and other blobs into may databases... too much of a hassle. I just store the names of files in the database...
--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)

October 22, 2007 at 11:56 pm

#744324
RE: System Performance - High CPU utilization--> SQLSRV.exe

I know... I'm a sick man... I usually have a primary key and an alternate key... except for a relatively static state or country reference table, I don't like natural...
--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)

October 22, 2007 at 11:39 pm

#744323
RE: Pivot Table Help Needed

If making RAC open source would stop your spamming, I'd be happy about that. 😛 And, your insults are a great way to drum up business :w00t:
Just curious... 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)

October 22, 2007 at 11:22 pm

#744320
RE: best way to find nulls? where [MyColumn] is null

WHERE = NULL will not work unless you make a pretty uncommon (some consider it "dangerous") change to the ANSI NULL settings of the server. NULL is not "nothing"...
--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)

October 22, 2007 at 9:58 pm

#744312
RE: Conversion failed when converting datetime from character string.

Look again... you're not getting what you think you're getting... run this small demo to see why...
[font="Courier New"]DECLARE @Params VARCHAR(100)
SET @Params = 'abcdefghij[ImportDate=12345678901234567890'
SELECT SUBSTRING(@Params,PATINDEX('%[ImportDate=%', @Params)+13,19)[/font]
...did you...
--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)

October 22, 2007 at 9:50 pm

#744310
RE: TSQL query with stored procedure

I'm curious... what did you need this for?
--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)

October 22, 2007 at 9:24 pm

#744308
RE: Trying to populate a file group

Not sure what you're using to do the move, but can you split the job? Trying to move ore even UPDATE more than 1 or 2 million rows at...
--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)

October 22, 2007 at 9:17 pm

#744307

Viewing 15 posts - 54,436 through 54,450 (of 59,072 total)