Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,541 through 24,555 (of 59,099 total)

RE: Create a Dimention - BI

L' Eomot Inversé (1/31/2014)
All sensible people are prohibited from participating in BI topics.
BWAAA-HAAA!!! Too funny, Tom. The ways I've seen some C-Levels use BI, I'm convinced that 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)

February 1, 2014 at 8:44 am

#1685289
RE: using a user defined function in a view - need help

You're too kind, Ed. :blush: Thanks for the kudo.
--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)

February 1, 2014 at 8:12 am

#1685288
RE: using a user defined function in a view - need help

The function needs to be in the FROM clause of the overall query for the view in a CROSS JOIN or as a CROSS APPLY.
You should also pick a function...
--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)

January 31, 2014 at 9:25 pm

#1685275
RE: Subtotal when vendorcode changed.

jdr.suporte (1/31/2014)
Try
;with
T as (
SELECT VendorCode, 1 as Seq, UnitPrice, Qty, (UnitPrice * Qty) as Total
from Sales
union
SELECT VendorCode, 2, sum(UnitPrice), sum(Qty), sum(UnitPrice * Qty)
from Sales
...
--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)

January 31, 2014 at 9:10 pm

#1685274
RE: auto-increment across multiple tables

squeekz01 (1/31/2014)
Haha thanks mate. That helped a lot.
P.S. I am a finance recruitment officer by day... I seem to structure all of my questions as though I am interviewing...
--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)

January 31, 2014 at 9:07 pm

#1685273
RE: Create a Dimention - BI

Steve Jones - SSC Editor (1/31/2014)
Jeff,
You are prohibited from participating in this subject area.
😀
--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)

January 31, 2014 at 9:01 pm

#1685272
RE: converting Year and Month varchar to date

Luis Cazares (1/31/2014)
You can add a derived column on the table with a formula as used below:
WITH SampleData([Year], [Month], Productname ) AS(
SELECT '2013', '11', 'ACB' UNION ALL
SELECT '2013', ...
--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)

January 31, 2014 at 3:34 pm

#1685238
RE: auto-increment across multiple tables

Sounds like an interview question. Lookup "Sequences" in Books Online.
--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)

January 31, 2014 at 3:31 pm

#1685236
RE: Sorting large volume of data

Apologies for not offering help here but I do have a couple of questions... Why do you need to have 4.8 Billion rows sorted in a single file? 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)

January 31, 2014 at 3:30 pm

#1685235
RE: Subtotal when vendorcode changed.

kishorefeb28 (1/31/2014)
Hi Experts,
i need to write a stored procedure for a table with below columns
for instance the table had 5 columns like
VendorCode | UnitPrice |...
--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)

January 31, 2014 at 3:02 pm

#1685227
RE: Complicated query with sample data

stmu009 (1/31/2014)
Actually CTEs tend to be better for performance.
Better for performance than 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)

January 31, 2014 at 2:57 pm

#1685224
RE: Create a Dimention - BI

"Create a [font="Arial Black"]Dimention [/font]- BI"
Heh... since I am dimented, just stand close and watch the "Dementions" spin off spontaneously. 😀
--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)

January 31, 2014 at 11:46 am

#1685168
RE: Thoughts about Table Partitioning...

About the only way that I can think of to increase the performance of inserts when an IDENTITY column is the clustered index (and with the understanding that I haven't...
--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)

January 31, 2014 at 9:19 am

#1685103
RE: Comparing string with date

Lempster (1/31/2014)
Jeff Moden (1/31/2014)
The truth be told, they're both not that great because of the mixed character data in denormalized columns instead of using the correct DATETIME datatype.
Yep, and 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)

January 31, 2014 at 9:09 am

#1685099
RE: Thoughts about Table Partitioning...

JohnFTamburo (1/30/2014)
Hi. A few more details...
1. Both tables are clustered on a BIGINT identity. This identity would be the value upon which I would partition. Each node 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)

January 31, 2014 at 9:04 am

#1685097

Viewing 15 posts - 24,541 through 24,555 (of 59,099 total)