Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,196 through 45,210 (of 59,101 total)

RE: Query Tune

Mike Levan (2/14/2009)
Guys...what do u mean by that.
" this probloem deos not apply to sql 7 or later"
It means that the myth of SELECT/INTO locking sysobjects so it can't be...
--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)

February 14, 2009 at 11:59 am

#944130
RE: how to split following string

bkDBA (2/13/2009)
Jeff, I hear a non-RBAR solution coming... anyway, thanks for the awesome presentation last night at the SEMSUG at Microsoft!
I had a RBAR "discussion" 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)

February 14, 2009 at 11:50 am

#944128
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

gvsriramakrishna,
You must really like pork chops... 😉
--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)

February 14, 2009 at 11:46 am

#944125
RE: Find all rows in a VARCHAR that can't be cast into an INT

Shawn Therrien (2/9/2009)
SELECT * FROM TestScores WHERE Score <> '0' AND ISNUMERIC(Score) = 0
Worked perfectly.
Thank you sir. Always a good day when I learn how to do away 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)

February 14, 2009 at 11:34 am

#944123
RE: Convert Interger Time to 00:00:00

Vivien Xing (2/13/2009)
My test shows 50% : 50% execution plan cost for these 2 codes.
create table mytest (mytime int)
insert mytest values (91700)
insert mytest values (212000)
insert mytest values (90200)
insert...
--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)

February 14, 2009 at 11:21 am

#944121
RE: 1-M join, concat all records

Then, I think Andrew's solution may be the best. If it was a text file input, you could simply do a BCP out using a simple SELECT and use...
--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)

February 14, 2009 at 10:20 am

#944106
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Wait a minute... is the goal to have every team play every other team twice (once at home and once away)? If so, just go get a bowling schedule...
--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)

February 14, 2009 at 10:16 am

#944104
RE: Query Tune

Andrew Reilly (2/13/2009)
But Jeff
NOTE: This problem does not apply to SQL Server 7.0 and later.
Heh... that's what I said... it's NOT a problem anymore.
--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)

February 14, 2009 at 10:06 am

#944101
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

True in both cases. Thanks for the feedback, Sam.
--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)

February 14, 2009 at 10:04 am

#944099
RE: Query output to txt file & columnheader headers

T2000 (2/13/2009)
Hey J, thanks for the reply anyway. If you can disable the dashes, I can do some more searches on this.
Grtz,
T.
Cast the output as VARCHAR(DesiredColumnWidthHere).
--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)

February 14, 2009 at 10:00 am

#944098
RE: convert int to varchar and concatenate

Scope_Identity() will be null until you actually do an INSERT.
--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)

February 14, 2009 at 9:58 am

#944096
RE: System Tables Locks

TRACEY (2/13/2009)
Sorry Mode X Lock Type is KEY, STATUS GRANT
SQL 2005
If the DBID for those locks is "2"... don't worry about it... that's TempDB.
--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)

February 14, 2009 at 9:48 am

#944094
RE: Passing a Table to a Stored Procedure

Mick Dugan (2/13/2009)
This is pretty neat, but what I've REALLY been looking for for ages is the ability to pass an entire .Net dataset to a proc. Of course,...
--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)

February 14, 2009 at 7:54 am

#944081
RE: Extended -SP

All of the xp/sp's kinda suck for the amount of information they give... try this...
CREATE PROCEDURE dbo.GetDirDetails
/**************************************************************************************************
Purpose:
Replacement code for the sp_GetFileDetails proc that was available 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)

February 14, 2009 at 7:47 am

#944080
RE: Group cumulative data

Your example result line has no date on it and, maybe I'm being a bit thick, but I can't actually figure out what you want from your description. 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)

February 14, 2009 at 7:40 am

#944079

Viewing 15 posts - 45,196 through 45,210 (of 59,101 total)