Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,136 through 36,150 (of 59,067 total)

RE: Are the posted questions getting worse?

Grant Fritchey (11/2/2010)
For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three...
--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)

November 2, 2010 at 10:57 am

#1245550
RE: Are the posted questions getting worse?

GSquared (11/2/2010)
I remember being 10 and thinking high school seniors were "adults"!
Heh... they should all leave home while they still think they are. 😛
--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)

November 2, 2010 at 10:53 am

#1245545
RE: Writing Nearly Codeless Apps: Part 4

wbrianwhite (11/2/2010)
Jeff Moden (11/1/2010)
Hi Brian... I know who David Ziffer is... he wrote the article. I've probably missed it in one of your posts on this thread but who...
--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)

November 2, 2010 at 10:50 am

#1245543
RE: Datetime tricks

SwePeso (11/1/2010)
Seems like a lot of math calculations there...
See this http://weblogs.sqlteam.com/peterl/archive/2010/09/08/fast-easter-day-function.aspx
I love it when people can simplify that much. Well done.
--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)

November 2, 2010 at 7:21 am

#1245340
RE: PARSING a Concatenated string into columns

Ah... one more thing. It would also appear that this is trully "flat file" stuff with a fixed column length for each "field". Would that also be true?
--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)

November 2, 2010 at 7:15 am

#1245335
RE: PARSING a Concatenated string into columns

SQL33 (11/1/2010)
A real puzzler for me.... I don't know how I'd create a test table for someone to play with from this.. but here's my question. The text...
--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)

November 2, 2010 at 7:14 am

#1245333
RE: Is it time to shrink my log file?

WayneS (11/1/2010)
Jeff Moden (11/1/2010)
ps. (10/29/2010)
You have already gone through the places where i would have gone to search for that answer:-P. I would probably do what Kimberly says. like shrinking...
--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)

November 2, 2010 at 7:00 am

#1245324
RE: Most efficient method of getting min values for a set

Craig Farrell (11/1/2010)
jamesniesewand (11/1/2010)
Personally I felt I was missing something with CTEs, and that "felt" like a Eureka moment for me (I've only just moved up to 2008 from 2000,...
--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)

November 1, 2010 at 10:48 pm

#1245195
RE: Multiple Comma Separated Help

jscot91 (11/1/2010)
Hi all. Please advise how i can solve these two problems. Thanks. in advance.
1)My source field has datatype (Text) and my destination table, Field, Datatype is (Varchar(30), I tried...
--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)

November 1, 2010 at 10:31 pm

#1245193
RE: The transaction log for database 'tempdb' is full.

Scott Thornton-407727 (11/1/2010)
HI Jeff,
As it happens, there is a cross join; eg For each of my hospitals I join a date period table which would result in ( for...
--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)

November 1, 2010 at 10:28 pm

#1245192
RE: REAL Sample Data available for free - better than fake!

I, for one, really appreciate the lists of data you've published. My problem, though, has frequently been that it takes way too much time to find a database from...
--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)

November 1, 2010 at 9:12 pm

#1245183
RE: Life Without a Net

What I'm even more concerned about is lost learning due to the fact that certain programs and formats are no longer available. Imagine, for instance, if someday in 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)

November 1, 2010 at 8:53 pm

#1245181
RE: The transaction log for database 'tempdb' is full.

Scott Thornton-407727 (11/1/2010)
Hi,
Well the result of the DBCC command is:
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
however at the time the stored...
--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)

November 1, 2010 at 8:42 pm

#1245180
RE: Is it time to shrink my log file?

ps. (10/29/2010)
You have already gone through the places where i would have gone to search for that answer:-P. I would probably do what Kimberly says. like shrinking it for once...
--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)

November 1, 2010 at 8:39 pm

#1245178
RE: Is it time to shrink my log file?

I just went through this on a server that's relatively new to me. You [font="Arial Black"]don't[/font] have to set to single use mode to shrink the log 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)

November 1, 2010 at 8:38 pm

#1245177

Viewing 15 posts - 36,136 through 36,150 (of 59,067 total)