Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,231 through 43,245 (of 59,063 total)

RE: Common questions asked in SQL Server DBA Interview

Never mind... 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)

June 23, 2009 at 6:57 pm

#1014370
RE: Slack SQL Server

Tom.Thomson (6/23/2009)
the foreign key constraint - but that only works if the target is (a) unique and (b) the primary key.
I'm pretty sure that only half of that is 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)

June 23, 2009 at 6:24 pm

#1014360
RE: Help with SQL algorithm to process transactions

Eichpeel (6/23/2009)
"Any fool can write code that a computer can understand. Good programmers write
code that humans can understand." -Martin Fowler et al, Refactoring: Improving the Design of Existing Code, 1999...
--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)

June 23, 2009 at 4:21 pm

#1014336
RE: Help with SQL algorithm to process transactions

For this reason, I do not use these types of undocumented features
Look up UPDATE in BOL... the SET @variable = column = expression IS documented.
and also try to avoid...
--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)

June 23, 2009 at 4:16 pm

#1014331
RE: Help with SQL algorithm to process transactions

Paul White (6/23/2009)
Jeff,
Using my preferred measure of total_worker_time as reported by sys.dm_exec_query_stats:
Triangular join: 10,218,749µs (~10.2 sec)
Your method:
Receipts running total: 41,015µs (~0.04 sec)
Shipments running total: 240,234µs (~0.24 sec)
Final SELECT: 4,425,781µ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)

June 23, 2009 at 4:09 pm

#1014328
RE: Any Utility available to convert Sql Server Stored Procedures into user defined functions

suneel (6/22/2009)
Hi,
As I mentioned, we import the resultset of these SPs into Excel. But the columns that we display in each and every worksheet are dynamic. So, we are trying...
--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)

June 23, 2009 at 9:44 am

#1014052
RE: Help with SQL algorithm to process transactions

Carl, see attached. Didn't change your logic of how to create the FIFO, just the logic of doing the running totals. Basically, it cuts the time in half...
--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)

June 23, 2009 at 3:28 am

#1013805
RE: A great site like this - but for ORACLE.

Lynn Pettis (6/4/2009)
You could also give sswug.org a try, if you want to pay for membership. They seem to try and cover everything, not just MS SQL Server. ...
--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)

June 22, 2009 at 9:31 pm

#1013701
RE: A great site like this - but for ORACLE.

dmbaker (6/10/2009)
You forgot:
5) Access to the site will require a custom-built browser that is arcane, follows no known standards, and is difficult to install, requiring tweaking of hidden system files...
--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)

June 22, 2009 at 9:25 pm

#1013698
RE: need help transforming a table's column to rows

WayneS (6/22/2009)
Jeff Moden (6/20/2009)
Heh... they kind of did :hehe: ... take a look at the NUMBER column of Master.dbo.spt_Values where the TYPE = 'P'. I don't believe they ever...
--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)

June 22, 2009 at 4:21 pm

#1013631
RE: Common questions asked in SQL Server DBA Interview

Brandie Tarvin (6/22/2009)
Jeff Moden (6/22/2009)
Heh... "Log shipping" = "hauling lumber" 😛
Oh, the agony! Oh, the pain!
Oh, I wonder how many more of these we can come up with... We could...
--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)

June 22, 2009 at 10:56 am

#1013460
RE: Which is better

Lynn Pettis (6/22/2009)
Eswin (6/18/2009)
Hi Expertz
Performance wise Which is better
...
And please provide me a good cursor example (ie optimized cursor eexample).
Isn't this, optimized cursor an oxymoron?? 😉
Heh... more like a...
--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)

June 22, 2009 at 10:15 am

#1013428
RE: Common questions asked in SQL Server DBA Interview

Heh... "Log shipping" = "hauling lumber" 😛
--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)

June 22, 2009 at 10:11 am

#1013424
RE: Multi Company DataBase

nalmir.hugo (6/22/2009)
First of all, thanks for Lynn Pettis,Jeff Moden,PaulB,ps,WayneS for your comments. All the points stressed out here are very important. As Jeff said, this is not a simple question...
--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)

June 22, 2009 at 9:16 am

#1013379
RE: Help with SQL algorithm to process transactions

Carl Federl (6/22/2009)
Do you know of any side-effect of creating tally in master ?
Yep... other people see it and think it's ok. Sometimes, ya just gotta set the 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)

June 22, 2009 at 9:11 am

#1013372

Viewing 15 posts - 43,231 through 43,245 (of 59,063 total)