Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,446 through 53,460 (of 59,072 total)

RE: Adding a dynamic incremental column

What is the primary key of the table? Please include the datatype...
--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 21, 2007 at 12:46 pm

#762297
RE: CURSOR v WHILE for beginners

In terms of the original script, I unfortunately haven't noticed any significant difference worth writing home about in terms of execution time after changing it from a cursor to 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)

December 21, 2007 at 12:41 pm

#762292
RE: Delete and Insert Blocking

The problem is that you never give the system time to "breath"... sure, it only takes about 3 seconds to delete 100,000 rows provided you don't have Delete Triggers on...
--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 21, 2007 at 11:35 am

#762242
RE: Log growth problem

Adam Angelini (12/20/2007)
A quick follow up. I used one of the built in reports to find when this was happening. I right clicked the DB and went to reports/disk usage....
--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 21, 2007 at 11:10 am

#762229
RE: Table name from variable in select statement

JohnG (12/21/2007)
Rather than casting/converting all of the WHERE clause values into the dynamic SQL query string you should be using the system stored procedure sp_executesql vs. just plain EXECUTE. ...
--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 21, 2007 at 11:08 am

#762225
RE: DBA Roles

It was kind'a real life spoof... for some of us, though, it's closer to the truth than I care to think 😀
Glad it made some laugh 😉
--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 21, 2007 at 11:06 am

#762223
RE: How to select from the linked oracle server?

You bet... 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)

December 21, 2007 at 10:59 am

#762221
RE: Get data from select query before completing the execution

jitumevada (12/21/2007)
I have one select query. Which is returning 1000 rows.It takes 20 min. But I dont want all rows simultaneously.
Is it possible that select query return row to screen...
--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 21, 2007 at 10:48 am

#762214
RE: How to select from the linked oracle server?

Everything in the FROM clause MUST be all upper case...
--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 21, 2007 at 10:43 am

#762210
RE: Pivot? Function? Complex results required

Heh... I'm the new guy to 2k5 and even I know that you don't need a CLR to solve this bad-whammer with some very simple and fast 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)

December 21, 2007 at 10:30 am

#762207
RE: Odd Identity Question

Thanks, Mark... only way I can get it to work for more than 1 row is to have a second column to hold, well, a NULL...
CREATE TABLE dbo.MyTable
...
--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 21, 2007 at 9:57 am

#762198
RE: Odd Identity Question

Mark,
Any idea how to insert more than 1 value without a loop? Insert/Select doesn't seem to do it...
--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 21, 2007 at 9:26 am

#762183
RE: Isnull function

karthikeyan (12/21/2007)
Jeff,
WHERE ISNULL(SomeColumn, ' ') <> ' '
Actually there is nothing wrong with this statement.But it is not required.
The logic of this sql code is :
if 'Somecolumn' has 'NULL'...
--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 21, 2007 at 9:18 am

#762176
RE: Finding Current Month's First Day& Last Day

karthikeyan (12/21/2007)
Thanks.But,is it possible to get lastmonth's lastdate without using localvariables ?
I mean i want to find last month's last date only ? I don't required the current month's first,last...
--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 21, 2007 at 9:12 am

#762168
RE: Find Number of Character Repeated

Jason Selburg (12/21/2007)
karthikeyan (12/21/2007)
Can you tell me where exactly you can apply spt_values table?
I mean In which situations you go to spt_values.can you list out some examples ?
I thought...
--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 21, 2007 at 8:57 am

#762162

Viewing 15 posts - 53,446 through 53,460 (of 59,072 total)