Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,426 through 37,440 (of 59,072 total)

RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

David Portas (7/31/2010)
Tom.Thomson (7/29/2010)
If anyone attempts to use SQL's single null to indicate why data is missing they are being very stupid. Codd explicitly required NULL (and later 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)

August 1, 2010 at 2:06 pm

#1200786
RE: Need urgent help

shishirbabel (7/30/2010)
We have an e-commerce website with hundreds of products . Need new functionality added to the website where after every 24 hours products will be automatically rotated in [font="Arial...
--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)

August 1, 2010 at 1:50 pm

#1200782
RE: Hi i am a sql dba.In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.

sql dba kittu (7/31/2010)
In my organizastion i am only the who will take care sql servers.2 servers are going to production within 2 days.
My bad uck they didn't provide me...
--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)

August 1, 2010 at 1:34 pm

#1200780
RE: TSQL LAB 2 - Writing Conditional WHERE Clauses

Ok... after reading this a second time, I have to ask... what about performance? Under optimal conditions (ie. correct indexes on the table), which method(s) will actually be 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)

August 1, 2010 at 12:59 pm

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

LutzM (8/1/2010)
A few things to notice:
You should start a new thread in the SSIS forum if you're looking for a SSIS solution.
Also, please read and follow the advice given 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)

August 1, 2010 at 12:08 pm

#1200773
RE: Deterministic UDF slower than Non-Deterministic?

dant12 (7/31/2010)
wow Jeff, thats a nice load of replaces lol. ill test it first thing on monday and post the results against the old T-SQL and the CLR functions. Thanks...
--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)

August 1, 2010 at 12:00 pm

#1200772
RE: Calendar Tables

Looking at the "Tally" table code that someone else wrote, I can certainly see why it's so slow. No chance of the clustered index being used there!
Thanks for 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 31, 2010 at 8:27 pm

#1200716
RE: The Rich Rewards of Tuning SQL

I know this is an old post but I had to say "Hear Here!" to it. Great post Tony. Phil is absolutely correct about how even the worst...
--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 31, 2010 at 7:56 pm

#1200714
RE: Deterministic UDF slower than Non-Deterministic?

Try this, Thiango... it may even give your .Net code a run for it's money. It's 32 to 64 times faster than the T-SQL Function you wrote. If...
--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 31, 2010 at 1:53 pm

#1200683
RE: Unzip files from Stored Procedure using 7zip

Agreed... especially on the environment thing. We had the joy of doing cross-domain across servers through a fire wall on SOX compliant systems on one side and "open" systems...
--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 30, 2010 at 9:08 am

#1200422
RE: how to update millions of records quickly........

Bhuvnesh (7/30/2010)
Jeff Moden (7/29/2010)
Bhuvnesh (7/28/2010)
Jeff Moden (7/28/2010)
you'd need a loop for that.
or may be batch approach can make work smoother
The loop would control "batches". That being said, what...
--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 30, 2010 at 9:03 am

#1200419
RE: Fall 2010 Speaking Opportunities

Steve Jones - Editor (7/30/2010)
The Colorado event is in South Denver, #52
http://www.sqlsaturday.com/52/eventhome.aspx
Thanks, Steve... doesn't look like there's any shortage of speakers for that 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)

July 30, 2010 at 9:02 am

#1200416
RE: "Real" copy of Codd's 12 (13) Rules for RDBMS

Heh... I guess it depends on what one's definition of "set based" is. Either way, I sure appreciate your feedback.
--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 30, 2010 at 8:50 am

#1200403
RE: Fall 2010 Speaking Opportunities

You spoke of a Denver event and I don't see that on the list anywhere.
--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 29, 2010 at 11:39 pm

#1200133
RE: Unzip files from Stored Procedure using 7zip

You should submit this as an article, Jeff.
--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 29, 2010 at 11:12 pm

#1200125

Viewing 15 posts - 37,426 through 37,440 (of 59,072 total)