Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,071 through 50,085 (of 59,091 total)

RE: Eliminating Cursors

Chris.Strolia-Davis (6/13/2008)
while (select count(*) from @table) > 0
begin
select top 1 'do something', @id=id from @table
delete from @table where id=@id
...
--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)

June 13, 2008 at 10:22 am

#828649
RE: Eliminating Cursors

dugsmith (6/13/2008)
thereby not having to wait for the cursor to be deallocated to release its locks.
"Firehose" cursors do not keep the same types of locks... in fact, they're pretty much...
--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)

June 13, 2008 at 10:06 am

#828642
RE: Eliminating Cursors

abhay.kulkarni (6/13/2008)
Creating a table variable is in the memory, not in the tempdb and hence much more efficient.
Absolutely NOT true... please see Q4/A4 in the following URL. In fact,...
--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)

June 13, 2008 at 9:50 am

#828633
RE: Include Column Headers From SSMS

Which service pack are you 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)

June 13, 2008 at 7:40 am

#828487
RE: CSV data import/export via a stored procedure?

Michael Earl (6/12/2008)
OpenQuery will allow you to do this.
Do you have example code of how to use OpenQuery to export to a CSV File?
--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)

June 12, 2008 at 9:13 pm

#828215
RE: Using VBA to pull SQL data into Excel?

Why not use "Get External Data"? Much easier... look it up in Excel Help.
--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)

June 12, 2008 at 9:09 pm

#828214
RE: Cannot bulk load. Invalid column number in the format file

8.0
5
1 SQLCHAR 0 8 "|" ...
--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)

June 12, 2008 at 9:06 pm

#828212
RE: Which situation we go for CLR?

Heh... I'd have to say just about never... with the exception of RegEx, there's not much that can't be done using some form of set based programming in SQL Server...
--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)

June 12, 2008 at 8:17 pm

#828204
RE: Find the Difference between two tables, listing the column values that differ

Try calling the following function from within the trigger. You would pass the name of the table to @TableName and the value of COLUMNS_UPDATED ( ) to @BinaryColNums. ...
--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)

June 12, 2008 at 8:11 pm

#828202
RE: CTEs and Trees

Tech_Newbie (6/12/2008)
help please.
I have the following situation:
I want to populate two related tables
Person (PersonID, PersonName, PersonLName)
PersonAddress(PersonAddressID, PersonID, PersonAddr, PersonCity, PersonState, PersonZip, County)
from a table which contains all 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)

June 12, 2008 at 7:34 pm

#828198
RE: Linking to the Previous Row

Like I said on the other article discussion, this isn't the right place and you haven't told us what version of SQL Server you are using... take a look at...
--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)

June 12, 2008 at 7:32 pm

#828197
RE: CTE Performance

This is probably the wrong place to ask for such help... and we'd really need to know which version of SQL Server you're using. It would probably be better...
--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)

June 12, 2008 at 7:29 pm

#828195
RE: Tuning help

jananik (6/5/2008)
While trying to retrieve records with a max query it takes around 4 minutes (appr. 20 lakh records)
That's 2,000,000 rows that you're returning to the screen... don't measure how...
--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)

June 12, 2008 at 7:21 pm

#828192
RE: Serial date returns different dates in SLServer vs Excel?

I'd like to know why people use Date Serials in such a fashion to begin with. 😉
--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)

June 12, 2008 at 7:17 pm

#828191
RE: Job Market

shivsen (6/11/2008)
Just want to know How is the Job market now for SQL Server 2000 DBA in US. I'm hearing from friends that the Job market is slowing down.
Thanks,
shivsen
How's 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)

June 12, 2008 at 6:55 pm

#828186

Viewing 15 posts - 50,071 through 50,085 (of 59,091 total)