Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,901 through 42,915 (of 59,102 total)

RE: how to reduce tempdb size in production in ms sql

Unless there were some "run away" query that blew TempDB to an insane size, don't shrink TempDB... it's just gonna grow again.
--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)

July 20, 2009 at 9:21 am

#1027060
RE: split field into numbers and join to table

I was just wondering if you are able to change the tables so that you don't have a CSV column at all. But, if you're happy, I'm happy. ...
--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)

July 20, 2009 at 9:16 am

#1027048
RE: Using UDF parameter in select statement of UDF

That's the one, Lynn... it has a RowCount for each object ID and, I believe, that row count is always up to snuff.
If you read BOL about the system...
--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)

July 20, 2009 at 9:14 am

#1027042
RE: how to search in sql by using like operator

Just to be sure... the "Magic" isn't in the CTE... it's in the Tally table and can be used in SQL Server 2000 just as effectively.
--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)

July 20, 2009 at 6:36 am

#1026897
RE: Table design

If it's possible to have 1 comment per assessment, or not, you can easily get away with not having a comment table. If you can have more than one...
--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)

July 20, 2009 at 1:04 am

#1026774
RE: FORMAT output to two Deciaml Places

Since you're formatting data, let's throw in right-justification, as well...
STR(ISNULL(SUM(QuantityOutstanding),0),10,2) AS Quantity
The key is that this type of formatting should be left up to the GUI, if you have one,...
--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)

July 20, 2009 at 12:59 am

#1026767
RE: Using UDF parameter in select statement of UDF

Ummmm.... now that I think about it, there's some new (new in 2k5) system view that actually gives you the correct number of rows for any given table without having...
--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)

July 20, 2009 at 12:53 am

#1026765
RE: Using UDF parameter in select statement of UDF

AShehzad (7/20/2009)
Thanks for reply, Moden. Actually this example UDF was to convey my problem. I was looking to create some UDFs for various tasks and was required to use dynamic...
--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)

July 20, 2009 at 12:51 am

#1026764
RE: Table design

Vinoo (7/19/2009)
GilaMonster (7/18/2009)
Did you change the names to obfuscate things, or are the columns really called that?
How does that matter to solve the problem? you can have any name 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)

July 20, 2009 at 12:47 am

#1026761
RE: show column data as rows

Maybe it's just a bit late for me but I'm thinking you're going to have to explain the mapping on that one just a wee bit more than you have....
--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)

July 20, 2009 at 12:42 am

#1026759
RE: Using UDF parameter in select statement of UDF

AShehzad (7/19/2009)
I am required to use select statement by parameter provided in UDF. Table name is provided as parameter and it is required to use in select statement in UDF....
--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)

July 20, 2009 at 12:37 am

#1026756
RE: Returning Multiple Columns - T SQL

Shuaib (6/25/2009)
Hi
I have a comma delimited values and I want to split this values into mulitple columns. Can someone share the idea / scripts?
Ex
Input
@v-2 = 'A,B,C'
Output
Col1 ...
--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)

July 20, 2009 at 12:10 am

#1026753
RE: Returning Multiple Columns - T SQL

ab5sr (6/25/2009)
I'd look at the split method in .Net to create an array for this. Otherwise you might get stuck with some cheesy TSQL string manipulation.
I know this is 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)

July 20, 2009 at 12:06 am

#1026751
RE: Creating millions of records in one go

ps (6/22/2009)
Well, Jeff's queries are like that, Rocket speed execution. 😀
:blush: Thanks, Pradeep. :blush: That's an awfully nice compliment especially coming from someone like 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)

July 20, 2009 at 12:02 am

#1026748
RE: sp_MSForeachdb to exclude master DB. doesnt seem to work

So I say to the doctor, "Doc, when I hold my arm up like this, it hurts." Doctor says, "So don't do that."
Being that this is SQL Server 2000...
--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)

July 19, 2009 at 11:56 pm

#1026747

Viewing 15 posts - 42,901 through 42,915 (of 59,102 total)