Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,066 through 43,080 (of 59,098 total)

RE: SQL brian teaser...

Jeff Moden (7/6/2009)
Where'd Digs go? He owes us a post with his solution...
Ok... it's been a couple of days. First things first... do you 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)

July 8, 2009 at 9:13 pm

#1022111
RE: SQL Split query

WayneS (7/6/2009)
Jeff,
I'm pretty sure I know what your Tally table test is doing... but what is the difference between your "XML" and "XML2" tests? Would you be able to post...
--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)

July 8, 2009 at 9:05 pm

#1022105
RE: The perfect database

It's a pretty good list... that's probably why the forum code listed it 3 times. 😛
Dev...make sure your developer have a list of best practices that won't kill your performance.
Avoid...
--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)

July 8, 2009 at 7:52 pm

#1022086
RE: Threw an exception... out of memory

It would be interesting to see the complete code examples in the test harness you used.
--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)

July 8, 2009 at 7:32 pm

#1022082
RE: Naming Conventions Standards

So what's the advantage to prefixing every table name with "tbl"? I see it as a disadvantage just because it requires more typing. If someone with even 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)

July 8, 2009 at 7:18 pm

#1022080
RE: pass values from table to a stored procedure

hi_abhay78 (7/7/2009)
add another column as flag (values 0 or 1) in the main table .
-> Create a cursor that inserts the values from you main table to the temp table...
--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)

July 8, 2009 at 6:39 pm

#1022072
RE: Create Group of Views with Columns in Upper Case

Garfi61416 (7/7/2009)
I have a client who has database tables with columns in lower case. I need them in upper case, and I can't ask them to change all 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)

July 8, 2009 at 6:35 pm

#1022068
RE: Help With a Cursor Please

Drew,
I am actually in the process of writing a book on the subject and thought I'd ask... why did you think you needed a cursor for this problem? I'm...
--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)

July 8, 2009 at 6:29 pm

#1022066
RE: 12 months period by paramter date

Lynn,
If someone runs this against something that also has a time element in the date, won't there be a problem because of the BETWEEN?
--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)

July 8, 2009 at 6:25 pm

#1022065
RE: Naming Conventions Standards

GSquared (7/8/2009)
Like I said, pick a standard and stick to it. In this case, that matters more than what the specifics of the standard are. The advantages/disadvantages 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)

July 8, 2009 at 2:46 pm

#1021933
RE: Naming Conventions Standards

roelofsleroux (7/8/2009)
- Most find it more readable and different object stand out from queries.
I'm sure you can produce a white paper on the multitude of opinion polls that substantiates...
--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)

July 8, 2009 at 2:42 pm

#1021932
RE: Saving Query results as CSV file in SQL Server 2005

mckinnj1 (7/7/2009)
I am trying to use a bcp in 2005 and the file is continually going out as Unicode when I am trying to define it (or at least i...
--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)

July 8, 2009 at 2:34 pm

#1021923
RE: write to text file using sql

ali.m.habib (7/8/2009)
Jeff Moden (7/7/2009)
I've never experienced BCP being slow at anything. Usually, it's the associated query that's slow. Please post both the BCP command and the query being...
--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)

July 8, 2009 at 6:31 am

#1021604
RE: write to text file using sql

Eswin (7/8/2009)
SET @bcpCommand = 'bcp " select '''+ @expFile +'''" queryout "'
SET @bcpCommand = @bcpCommand + @exptionFile + '" -T -c'
EXEC master..xp_cmdshell @bcpCommand
i don't think you can 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)

July 8, 2009 at 6:29 am

#1021603
RE: please help! Cursor or loop?

WayneS (7/7/2009)
Lamprey13 (7/7/2009)
This will probably work, but you cannot guarantee that it'll work based on the PK order.
Thanks for pointing that out... I've edited the post to include the necessary...
--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)

July 8, 2009 at 6:07 am

#1021586

Viewing 15 posts - 43,066 through 43,080 (of 59,098 total)