Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,396 through 40,410 (of 59,072 total)

RE: Performance with Bulk update

brainy (12/30/2009)
Thanks jeff..
I will consider your suggestions.. I will try that. I am also thinking on setting fill factor.. as I am updating table several times which leads 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)

December 30, 2009 at 12:52 pm

#1097639
RE: Problem using EXEC within SELECT CASE statement

AndrewSQLDBA (12/30/2009)
I have never had any issues with SSIS. Maybe it is time for a new server.
Andrew SQLDBA
Heh... unlike most, I've never had an issue with SSIS because the other...
--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)

December 30, 2009 at 12:42 pm

#1097633
RE: Can TSQL 2005 do this : ToBase64string

I just looked up and read some of the articles and scripts for this Base64 "encryption". My suggestion would be... don't bother. It's an easy hack from what...
--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)

December 30, 2009 at 12:33 pm

#1097622
RE: convert to regular time

Pratap Prabhu (12/29/2009)
drop the convert(datetime from the code and run. See what filter condition needs to be added to the case/where,(it has to be one or more records in your...
--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)

December 30, 2009 at 12:10 pm

#1097610
RE: Problem using EXEC within SELECT CASE statement

AndrewSQLDBA (12/30/2009)
That is just bad news waiting to happen.
Heh... that's funny... I was just going to say the same thing about using SSIS. 😉
--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)

December 30, 2009 at 11:55 am

#1097598
RE: Can TSQL 2005 do this : ToBase64string

It depends... is the ToBase64String function something that you wrote or not? If it is, post it and someone may be able to come up something.
As an alternative, 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)

December 30, 2009 at 11:53 am

#1097596
RE: Normalize data using Pivot WITHOUT using Aggregate function

Justin James (12/29/2009)
There is not. I was thinking of using ROW_NUMBER(), but was unsure how to partition by each block of 6 rows.
I see you've already got that... simple integer...
--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)

December 30, 2009 at 11:47 am

#1097593
RE: Normalize data using Pivot WITHOUT using Aggregate function

Justin James (12/29/2009)
Please see my original post for code to copy/paste.
Tell ya what, Justin... please see the first link in my signature line below. 😉
--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)

December 30, 2009 at 11:45 am

#1097590
RE: Performance with Bulk update

Auto update of stats being on is no guarantee that stats will be updated. IIRC, something like 20% of the table needs to be modified or new before an...
--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)

December 30, 2009 at 11:38 am

#1097588
RE: Master.dbo.SysColumns

Yep... not a misprint.
What was worse was when I tried to add a clustered index. 😉
--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)

December 30, 2009 at 11:22 am

#1097584
RE: The Year in Review - 2009

No one mentioned things like the upgraded and properly working SQL Code windows on this sight. Posting and copying code was a real PITA for quite a while but...
--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)

December 30, 2009 at 10:15 am

#1097552
RE: Performance with Bulk update

You may be causing massive page splits on the clustered index and massive extent splits on the non-clustered indexes if they are not in the same "order" as the data...
--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)

December 30, 2009 at 9:43 am

#1097532
RE: Master.dbo.SysColumns

corey_nunnery (12/29/2009)
I was reading the article on the "Numbers" or "Tally" table (http://www.sqlservercentral.com/articles/T-SQL/62867/) and see this used in a query. I tried to do some research on what exactly...
--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)

December 30, 2009 at 9:29 am

#1097523
RE: Query Issue with Date Between Spanning 2 Years

To answer for Dave, yes... there are a couple of reasons but the big one is "accuracy". Using BETWEEN includes both end points and if time is ever induced...
--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)

December 30, 2009 at 9:20 am

#1097518
RE: Cummulative Totals By Dynamic Month Range

tm3 (12/30/2009)
Jeff, if you have a better approach, I am all ears at this point. I have been struggling with this procedure for about 4 days now. 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)

December 30, 2009 at 9:17 am

#1097516

Viewing 15 posts - 40,396 through 40,410 (of 59,072 total)