Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,491 through 44,505 (of 59,101 total)

RE: updating CLR UDFs / Procedures strategy: contributions needed.

Giovanni (3/21/2009)
Jeff,
you were perfectly correct with the file extension issue. I was missing the "reverse" approach with T-SQL and that lead us to think of using CLR to 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)

March 22, 2009 at 8:13 am

#964127
RE: is possible thro a single query

S (3/22/2009)
Hi,
Thanks for the reply and interest. 🙂
Kindly find attached files containing data in .xls file,.txt file(with data in pipe delimited format) and table structure in .txt file.
Thanks,
Sree
Heh... you either...
--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 22, 2009 at 8:02 am

#964124
RE: T-Sql rant

Lynn Pettis (3/21/2009)
We also need the proper "business" scenario. Could be something based on our past experience or something similiar. I guess we should come up with some...
--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 22, 2009 at 7:56 am

#964123
RE: Regarding Level and its Description

Ashok (3/19/2009)
Thanks GSquared,
Exactly thats what I'm looking for :-).
And Steve, I suggest you 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 21, 2009 at 8:40 pm

#964059
RE: Just testing the new code window... please disregard

Steve Jones - Editor (3/21/2009)
Yikes, looks like a lot of stuff to fix. We'll go through some of this next week.
I actually did this because Phil sent me an email...
--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 21, 2009 at 7:13 pm

#964053
RE: Slow performing select statement on large table

Matt (3/21/2009)
Alrighty, I've put in code to sop the parameter sniffing and that alone seems to have had a positive effect, I've also scheduled in a job to run 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 21, 2009 at 6:47 pm

#964047
RE: Do DBAs Still Read Techincal Books?

I fear programmers will miss the big picture that a top-quality book often provides
There're a couple of problems with that statment... first, there are disappointingly few programmers and a lot...
--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 21, 2009 at 6:24 pm

#964046
RE: I want to display the rowdata with columnnames is there any posibility

Heh... this is a pretty simple problem and I'd try to help but you keep posting data in that absolutely useless JPG format. I'm not going to copy from...
--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 21, 2009 at 5:44 pm

#964042
RE: is possible thro a single query

Jeff Moden (3/20/2009)
ramu.valleti (3/20/2009)
what do you mean by "single query".?
You can use sub queries to achieve this.
Regards,
Ramu
Cool... let's see it, Ramu.
Ramu... you there? I'd still like to see 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)

March 21, 2009 at 5:37 pm

#964041
RE: is possible thro a single query

S (3/20/2009)
Hi,
Thanks for the reply.
I should have expressed it clearly or more correctly.
Is it possible to achieve it with out using multiple statements (exclude subqueries as they are part...
--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 21, 2009 at 5:36 pm

#964040
RE: Finding all Parents

There are three problems with recursive CTE's being used to supposedly resolve hierarchies...
1. Recursive CTE's are slower than cursors and a fair bit slower than a good "Fire Hose"...
--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 21, 2009 at 5:33 pm

#964037
RE: Shrinking Database file

Ummm.... just a couple of things to clear up here, folks. First, DBCC ShrinkFile does not now nor has it ever nor will it ever cause fragmentation. It'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)

March 21, 2009 at 5:09 pm

#964034
RE: Slow performing select statement on large table

No... the cache I'm talking about is in the memory of the SQL Server.
And, no... indexes don't take care of themselves. Now that you've identified that you're not running...
--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 21, 2009 at 4:54 pm

#964033
RE: T-Sql rant

Sounds like a plan... like you, I'm a bit busy this weekend but I'll get things going on this soon. We should also explore some of 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)

March 21, 2009 at 4:44 pm

#964032
RE: derived table performance tune in Group By

Sorry... I believe that one of two things has happened here... either that the two of you guys on the interview left something out of the code you posted, or...
--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 21, 2009 at 4:30 pm

#964030

Viewing 15 posts - 44,491 through 44,505 (of 59,101 total)