Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,996 through 26,010 (of 59,099 total)

RE: Are the posted questions getting worse?

ChrisM@Work (9/5/2013)
Sean Lange (9/4/2013)
Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my actual...
--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)

September 5, 2013 at 6:09 pm

#1647898
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (9/5/2013)
http://www.liveleak.com/view?i=424_1378224156
Let's stick Jeff in this interview 😉
BWAAA-HAAAA!!!! Don't forget... I take porkchops to interviews, as well. And I don't just get even, 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)

September 5, 2013 at 6:04 pm

#1647897
RE: Forum Etiquette: How to post data/code on a forum to get the best help

erikd (7/14/2013)
Just a quick note on sample data generation, (forgive me) without reading all 18 pages of this thread.
I altered what you posted to run like this, because if there's...
--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)

September 5, 2013 at 5:36 pm

#1647893
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Steven Willis (9/5/2013)
Great article Jeff. Perhaps you could add the point that when inserting code into the "Code" IFCode tags that tabs should be converted to spaces before pasting in...
--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)

September 5, 2013 at 5:30 pm

#1647892
RE: how to validate records

I strongly recommend that you read the article at the first "Helpful Link" in my signature line below.
--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)

September 4, 2013 at 3:42 pm

#1647517
RE: Update on differences in table types (temp/var/user)

Steve Jones - SSC Editor (9/4/2013)
I'd like a short piece that explains the differences between temp tables, table variables, regular tables, user defined table types.
When to use each.
What would you...
--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)

September 4, 2013 at 3:40 pm

#1647516
RE: T-SQL: compare strings

Steve Jones - SSC Editor (9/4/2013)
If you had this:
create table A
( id int
);
go
create table b
( mychar varchar(20)
);
go
insert a select 12345
insert a select 23456
insert b select '0012345'
insert b select '00012345'
Show 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)

September 4, 2013 at 3:35 pm

#1647514
RE: Scalar function Performance

Steve Jones - SSC Editor (9/4/2013)
a few examples that show why scalar function performance can be an issue.
I think you already have one of these... http://www.sqlservercentral.com/articles/T-SQL/91724/
--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)

September 4, 2013 at 3:33 pm

#1647513
RE: format of decimal

sqlfriends (9/4/2013)
I have a SSIS package, of attendance data. most of them is a whole number like absent days 5 days, or 100 days in a semester. But some 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)

September 4, 2013 at 3:24 pm

#1647510
RE: Fastest way to read a 600MB table (in memory)

noeld (9/3/2013)
Well?
Does anybody have the inside on TDS that I am looking for?
I appologize for not being able to help here. I've not had the need to transfer...
--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)

September 4, 2013 at 6:25 am

#1647268
RE: Variable Default Values to a Stored Procedure (SQL Spackle)

dwain.c (9/3/2013)
Jeff Moden (9/3/2013)
venoym (9/3/2013)
In order to bridge the gap between Mr. Hugo's excellent comments and other comments about multiple columns, I've seen systems that used a type specific column...
--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)

September 4, 2013 at 6:19 am

#1647265
RE: Variable Default Values to a Stored Procedure (SQL Spackle)

venoym (9/3/2013)
In order to bridge the gap between Mr. Hugo's excellent comments and other comments about multiple columns, I've seen systems that used a type specific column in their normalized...
--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)

September 3, 2013 at 2:29 pm

#1647147
RE: What is RBAR? How can I avoid it?

bjesmith2 (1/26/2009)
Jeff,
All of your responses were excellent! I was astonished by the number of replys to what I thought would be an afterthought question for most of you. I truly...
--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)

September 2, 2013 at 10:06 pm

#1646850
RE: Please help with a Trigger

abdel_mesbah (9/2/2013)
Hi there,
thank you for the reply and didnt mean the kind of as I dont know what I want 🙂
thats what I am capturing at the moment
Maincase
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)

September 2, 2013 at 8:55 pm

#1646846
RE: sql query

dwain.c (9/2/2013)
Jeff Moden (9/2/2013)
Same goes for another atypical method (the "Multi-Pass" update) that a chap by the name of "Hugo" wrote.
My curiosity has been piqued. Would this be Hugo...
--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)

September 2, 2013 at 8:40 pm

#1646844

Viewing 15 posts - 25,996 through 26,010 (of 59,099 total)