Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,701 through 38,715 (of 59,072 total)

RE: Which query method is best to use and when?

aaa-322853 (4/26/2010)
Ok great. I thought that might promote some discussion!
So lets start with Table Variables. Basicially never use these, regardless of the row size or application (unless it's a 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)

April 26, 2010 at 10:43 am

#1157735
RE: Which query method is best to use and when?

Holy moly... Guess I needed to read the entire graphic and the underlying text, huh?
Again, IMHO, using Global Temporary Tables is a form of "Death by SQL" because if two...
--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, 2010 at 7:18 am

#1157592
RE: Which query method is best to use and when?

Gahh.... I'd also recommend that if you need to reference data more than once from a subquery that you NOT use CTE's... Like Views, if you reference a CTE more...
--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, 2010 at 7:14 am

#1157586
RE: Which query method is best to use and when?

It's simply not a given that Table Variables are faster than Temp Tables and Table Variables are a whole lot more difficult to troubleshoot because their content don't persist even...
--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, 2010 at 7:11 am

#1157583
RE: Bulk Update from Text file

Actually, OPENROWSET requires the data to be fairly solid. True that it's more forgiving than BULK INSERT and BCP especially when it comes to how the first row of...
--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, 2010 at 7:03 am

#1157577
RE: Passing a Table to A Stored Procedure

Carlos Shoji-387174 (9/23/2007)
Very good article!
Is there any way to do a similar thing with SQL Server 2000?
Thanks.
Kind of... Please see the following article with the understanding that it's limited 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)

April 26, 2010 at 6:57 am

#1157573
RE: To reduce CPU cost being used by SORT

The following two items in your code above...
and a.root_claim_id < b.root_claim_id --original claim ID is less than the duplim ID
and a.claidate <= b.cl_date --original received before duplicate received
... probably consitute...
--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, 2010 at 6:51 am

#1157566
RE: How To Get Last Inserted Record Value In SQL Server

Vijay Sinha (4/25/2010)
How To Get Last Inserted Record Value In SQL Server
The table have no Primary key, identity, it have only one column "Name"(Column Name)
Without either a date column 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)

April 26, 2010 at 6:42 am

#1157562
RE: Are the posted questions getting worse?

chandrashekarthota (4/26/2010)
As a site administrator I request you to kindly ignore my Core member comments. I am
closing down my site for few weeks just because of plagiarism and I have
learned...
--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, 2010 at 6:23 am

#1157556
RE: Minimal Meetings

david.wright-948385 (4/26/2010)
Very true. It's worth pointing out the proportion of time spent on meetings from time to time.
Anyone else here find themselves keeping the meeting on track, identifying milestones,...
--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, 2010 at 6:14 am

#1157551
RE: Using OPENROWSET to import CSV files

ColdCoffee (4/24/2010)
Thanks, Jeff, for posting your approach.. As i dont have SSMS at home, i will check out your code tomorrow and let you know..
But i got a doubt...
--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, 2010 at 10:48 am

#1157409
RE: Substring Function in Where Clause

eseosaoregie (4/23/2010)
Thanks jeff. Will try it this weekend and let you know how it runs. Much appreciated
Since you PM'd me several times on the subject and half the weekend has...
--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 24, 2010 at 6:24 pm

#1157359
RE: dateDiff question

SQL_NuB (4/21/2010)
Jeff Moden (4/19/2010)
SQL_NuB (4/19/2010)
that is setup for the start date or end date begin on a weekend, I need to find out if the day between my two dates...
--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 24, 2010 at 6:20 pm

#1157358
RE: Speed improvement help needed for large xml queries

lmu92 (4/24/2010)
@jeff: it's not that I'm actually advertising XML, I'm sure not. 😉
I just had to get used to it in order to get those "man in the middle" out...
--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 24, 2010 at 5:45 pm

#1157357
RE: Using OPENROWSET to import CSV files

I put the OP's files in C:\Temp to have the following code run...
--DROP TABLE #Staging,#Header,#Data
--GO
--===== Supress auto display of rowcounts
SET NOCOUNT ON;
--===== Declare local variables
DECLARE @pFullPath...
--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 24, 2010 at 5:38 pm

#1157354

Viewing 15 posts - 38,701 through 38,715 (of 59,072 total)