Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,366 through 34,380 (of 59,099 total)

RE: Recursive query for a Bill of Materials table

david.moule (4/5/2011)
Hi Jeff,
I can't see any spam in my junk mail... or anything in my PM box....
Is the email address you provided for this site a good one? ...
--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)

April 5, 2011 at 5:02 pm

#1307764
RE: Query Performance Tuning

Ninja's_RGR'us (4/5/2011)
Jeff Moden (4/5/2011)
Ninja's_RGR'us (4/4/2011)
It's actually "worse" than that. If you want a garanteed index seek, the predicate needs to return 0.3% OR LESS of the data 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)

April 5, 2011 at 4:55 pm

#1307763
RE: Gadgets

The Navy COULD and SHOULD use it. They just believe that they have OTTO fuel under control (and they don't).
Open cycle turbines would work but only if you closed...
--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)

April 5, 2011 at 4:48 pm

#1307761
RE: SQL Server running incredibly slow since Friday...

UMG Developer (4/5/2011)
Jeff Moden (4/5/2011)
forsqlserver (4/4/2011)
Looping Myself...
Please explain.
My guess is they are used to being added for immediate notifications when replying to a thread, so they added a reply 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)

April 5, 2011 at 4:44 pm

#1307760
RE: Query Performance Tuning

Ninja's_RGR'us (4/4/2011)
It's actually "worse" than that. If you want a garanteed index seek, the predicate needs to return 0.3% OR LESS of the data in the table.
Have you got...
--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)

April 5, 2011 at 7:18 am

#1307427
RE: Gadgets

maneeshi_trivedi (4/5/2011)
This is for Jeff Moden.
Could you kindly update us on the current status of this wonderful (Moden) fuel that your dad had formulated back in 2000?
For example,...
--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)

April 5, 2011 at 6:57 am

#1307413
RE: SQL Server running incredibly slow since Friday...

forsqlserver (4/4/2011)
Looping Myself...
Please explain.
--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)

April 5, 2011 at 6:35 am

#1307398
RE: Passing multiple parameters using REPLACE function in the query is throwing error.

This will be a whole lot easier to troubleshoot if you print the contents of the two variables that hold the dynamic SQL.
--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)

April 4, 2011 at 11:26 pm

#1307301
RE: Want to display dynamic number of tables in output?

dragonpms (4/3/2011)
ok ,lets i explain my requirement....
ALTER PROC Multiple_Instance_Value
(
@compnay_ID INT,
@Instance_ID NVARCHAR(MAX)
)
AS
BEGIN
SELECT instance_id,address,company_name,status FROM cmytbl
WHERE company_ID =@company_ID AND instance_id = @instance_id
END
for exemple we passing the input parameter as
EXEC Multiple_Instance_Value @company_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)

April 4, 2011 at 11:17 pm

#1307299
RE: SQL Server running incredibly slow since Friday...

MyDoggieJessie (4/4/2011)
First off, I've not had this issue before with this server...at least not until this past Friday afternoon.
90% of the time, all you have to do is find out...
--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)

April 4, 2011 at 11:09 pm

#1307297
RE: The Value of Data

I guess I'll be the rogue here and say that paying for information doesn't guarantee the quality of the information.
--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)

April 4, 2011 at 11:02 pm

#1307293
RE: a way to emulate =PRODUCT() from Excel?

{edit} Sorry... wrong 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)

April 4, 2011 at 10:39 pm

#1307292
RE: Execution Plan for Newbies

I strongly second the recommendation for Grant's fine book. It's an easy read and Grant clearly explains just about everything you ever wanted to know about execution plans so...
--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)

April 4, 2011 at 10:31 pm

#1307289
RE: Creating a job that monitors a nightly ETL process

shannonjk (4/4/2011)
Thank you for the response, and sorry for the delay in replying to this.
The problem is that there are 4 files my ETL gathers from an access database....
--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)

April 4, 2011 at 10:26 pm

#1307287
RE: Update Multiple Rows

CELKO (4/4/2011)
Please post real DDL. Learn to use ISO-11179 rules for the data element names, avoid needless dialect and use ISO-8601 temporal formats, codes and so forth. People cannot read...
--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)

April 4, 2011 at 10:21 pm

#1307284

Viewing 15 posts - 34,366 through 34,380 (of 59,099 total)