Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,061 through 48,075 (of 59,102 total)

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

Heh... I can show you a query plan for two queries... one comes up with 100% of the batch size and the other 0%... when you run the queries, 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)

September 29, 2008 at 2:24 pm

#878616
RE: Hungarian notation convention

Jackal (9/29/2008)
Hi all,
Jane, thanks for posting your article, one things I did notice was;
"Stored procedures should be named by function and the object they work on. Standard prefix like ‘p’,...
--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 29, 2008 at 2:18 pm

#878613
RE: Need a way to speed up processing using cursor

Heh... I think we have another set-based convert on our hands. Well done!:D
--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 28, 2008 at 8:59 pm

#878239
RE: the effect of clicking auto update statistics on and off quickly in succession

Liam Willis (9/22/2008)
Hi George
This is a very busy database and we took the decision a couple of years ago to switch off the auto update statistics as it was affecting...
--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 28, 2008 at 8:54 pm

#878238
RE: Simple Cursor taking close to 4 minutes how can I fasten this up

Sounds like you've successfully made a believer out of someone, Matt. 🙂 Now, all we have to do is convert the other bazillion folks who think there is any...
--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 28, 2008 at 8:49 pm

#878236
RE: Can I use a Tally table to do this?

jcrawf02 (9/26/2008)
Normally, that would solve my problem, but I can't create a function. Only temp objects.
Are you creating a stored procedure or just a script? I need to know...
--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 28, 2008 at 8:28 pm

#878234
RE: SELECT * vs SELECT k1, k2...

Except in rare cases like a pass-through view (like a synonym), SELECT * will frequently (usually) make it impossible to do index seeks.
--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 28, 2008 at 7:24 pm

#878231
RE: Stored Procedure Not Returning Values

In other words, start by doing an OUTER JOIN on the homes table with all the other tables. Then, wittle from there.
--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 28, 2008 at 7:16 pm

#878230
RE: CustomRollupColumn and aggregates

You'd get better help quicker if you'd follow the methods in the article in the link in my signature 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 28, 2008 at 7:10 pm

#878229
RE: NEED HELP in CREATING NEW DATABASE

cuteprabakar (9/27/2008)
Dear All, I need help TO design DB that will contain the following tables. I am using ASP in the frontend
USERS
[userid] [int] NOT NULL,
[password] [int] NOT NULL,
[Fullname] [nvarchar] (50)...
--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 28, 2008 at 7:08 pm

#878228
RE: 'Your Response' bar could use more detail

Not sure if it's possible, but it would also be really cool if we could have discussions on SQL Server about articles not on SQL Server. In other words,...
--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 28, 2008 at 6:56 pm

#878227
RE: Outakes-please eliminate

Keller (9/28/2008)
Please don't ever eliminate the outtakes. "The human side of Steve Jones" is my favorite part of every editorial! 🙂 (Besides the valuable content, of course!)
I'll...
--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 28, 2008 at 6:54 pm

#878226
RE: cursor

The OP must like porkchops...
--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 28, 2008 at 6:51 pm

#878225
RE: array in sql server

Not sure what you mean, but if you want to pass an array to SQL, then the following article will help... covers passing of 1, 2, and 3 dimensional arrays...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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 28, 2008 at 6:45 pm

#878223
RE: Issue with stored procedure...

Matt Miller (9/27/2008)
Jeff Moden (9/27/2008)
Heh... thanks for posting your solution. Sometimes the problem just boils down to "must look eye." 🙂
Any more references like these and you're going...
--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 28, 2008 at 6:40 pm

#878222

Viewing 15 posts - 48,061 through 48,075 (of 59,102 total)