Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,956 through 50,970 (of 59,098 total)

RE: User Defined Function - Passing and Processing a Table

So use Robert's function as part of a derived table, join it, and pivot it.
It really would help if the OP would post exactly what output is expected from 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)

April 28, 2008 at 6:33 am

#807705
RE: Where can I find this in BOL?

Never mind...
Master.sys.dm_Exec_SQL_Text is a system table-valued function... I thought it was a system view.
:blush:
--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)

April 28, 2008 at 6:14 am

#807698
RE: Updating the rows with Identity values

Why bother? If you want to update a table with an IDENTITY column, then just do it.
If you're trying to create a query that returns a numbered list, then...
--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)

April 27, 2008 at 9:01 am

#807557
RE: Performance Problem

Some have tried to come up with a formula... I've not been very successful at it because it really isn't database size dependent. It's impacted more by what 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)

April 26, 2008 at 11:30 pm

#807541
RE: Performance Problem

You bet... let us know how you make out on this problem.
--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)

April 26, 2008 at 10:57 pm

#807538
RE: Identity Columns

As with so many types of testing, you must also test your "made up" questions as well. This question actually has two correct answers... made up or not... 😉
--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)

April 26, 2008 at 12:09 pm

#807515
RE: Need Query help

It orders by data_id assuming that you want to know the next one. Your example data was not in order by data_id, but I think you may have meant...
--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)

April 26, 2008 at 11:45 am

#807514
RE: Restrict DBO user

Lynn (4/24/2008)
I can't put these tables in a separate db because the application will break.
Oh, yes you can... put the tables in a different DB and either make "surrogate views"...
--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)

April 26, 2008 at 11:31 am

#807513
RE: Updating the rows with Identity values

Just alter the table to add the ID column making sure that it has the IDENTITY property included.
--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)

April 26, 2008 at 11:28 am

#807512
RE: Performance Problem

The first 3 things I'd do is...
1. Update to sp2 and apply the latest cumulitive update (#7, I believe).
2. Turn off autoshrink. If it keeps growing, 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)

April 26, 2008 at 11:27 am

#807511
RE: DTS - loading mixed data types from text file.

Thanks for the feedback, Gene, and good luck on your efforts! Let us know if anything comes up... maybe give us some feedback on what you ended up 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)

April 26, 2008 at 11:08 am

#807510
RE: The Exceptional DBA: Soft Skills

You've summarized the soft skills very nicely, Tony. And, I absolutely agree, David Poole's well thought out statement of "if people will voluntarily use you as the first point...
--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)

April 26, 2008 at 10:49 am

#807508
RE: DTS - loading mixed data types from text file.

intvfan (4/26/2008)
I still would love to have the log not grow!!! I am loading millions of rows in several tables.
I would love to BULK load. Do you bulk...
--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)

April 26, 2008 at 9:12 am

#807505
RE: Date String

You don't need to worry about DateFirst with the following...
[font="Courier New"] SELECT LEFT(DATENAME(dw,GETDATE()),3)
+ ', ' + CONVERT(VARCHAR,GETDATE(),106)[/font]
--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)

April 25, 2008 at 8:41 pm

#807475
RE: Cursor ends when I don't want it too

Have you got a server called "FindUsers"??? That's where the error is on my machine...
--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)

April 25, 2008 at 8:36 pm

#807474

Viewing 15 posts - 50,956 through 50,970 (of 59,098 total)