Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,691 through 24,705 (of 59,099 total)

RE: Mastering Dimensions of Time

JohnFTamburo (1/21/2014)
Jeff Moden (1/21/2014)
I know it's a personal preference but I've worked with "DateDIM" tables that use date and time serial numbers and I've never understood why people would bother....
--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 21, 2014 at 8:56 pm

#1682252
RE: How do you describe what you do?

Tell them that all DBAs are secretly paid by the NSA and they'd better be nice to you or you'll publish their phone number on a porn site. 😛
--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 21, 2014 at 2:17 pm

#1682165
RE: Any problem with installing SQLServer 2012 on Windows 2012?

I believe I may have answered my own question in the following... thought I'd share it with others who may be taking the plunge...
http://technet.microsoft.com/en-us/library/ms144228.aspx - Security Considerations for a 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)

January 21, 2014 at 1:08 pm

#1682138
RE: Mastering Dimensions of Time

Luis Cazares (1/21/2014)
Here's an extract of the procedure to populate date dimension (I removed columns needed in my company and left some that might be relevant). We populate it by...
--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 21, 2014 at 9:24 am

#1682044
RE: Mastering Dimensions of Time

akosinsk (1/21/2014)
If you need to define your internal, company calendar i.e. "4/4/5" in time table, such a script may become a little more interesting.
If you have such a thing, it...
--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 21, 2014 at 9:14 am

#1682031
RE: Mastering Dimensions of Time

PHYData DBA (1/21/2014)
I want to thank everyone that took the time this morning to read my article and comment on it.
I had no idea that my very first...
--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 21, 2014 at 9:10 am

#1682025
RE: Mastering Dimensions of Time

peter-757102 (1/21/2014)
We use such date tables as well, but structured quite differently, see the script code for details.
What it amounts to is our own integer based structured date type, with...
--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 21, 2014 at 9:08 am

#1682020
RE: Mastering Dimensions of Time

raulggonzalez (1/21/2014)
And for this particular case, I cannot see any 'true set based' alternative, maybe because I'm used to recursive CTE to generate this kind of samples.
See the example code...
--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 21, 2014 at 9:02 am

#1682013
RE: Mastering Dimensions of Time

mtassin (1/21/2014)
Jeff Moden (1/21/2014)
Just a couple of thoughts...
First, these two tables are one of the few places where I'd use the natural key of either the date or the time...
--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 21, 2014 at 8:52 am

#1681994
RE: How to check wheter a value is whole number or in fraction

Borrowing a bit of Gail's code, pick your poison. Just remember that the prerounding of the datatype you've chosen is going to result in some possibly surprising answers 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)

January 21, 2014 at 1:35 am

#1681762
RE: Mastering Dimensions of Time

Just a couple of thoughts...
First, these two tables are one of the few places where I'd use the natural key of either the date or the time instead of 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)

January 21, 2014 at 1:10 am

#1681752
RE: What do you use to find out what's slowing down your instance right now

smitty-1088185 (1/20/2014)
There is so many variables to your question I'm not sure where to start. How do you know it's SQL verses some other process?
How much available memory?
How much...
--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 20, 2014 at 10:31 pm

#1681728
RE: Need to create table relationships

ramadesai108 (1/20/2014)
Hello Jeff Moden,
Thank you for pointing me in the right direction. How about using HierarcyID, are there any drawbacks?
Thank you so much for your time,
Rama
I've...
--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 20, 2014 at 10:28 pm

#1681727
RE: Uncontrolled Code

It's not Excel, spreadsheets, or anything else in particular. It's crap code and human error in general. I just saw an article yesterday where a couple got 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)

January 20, 2014 at 8:50 pm

#1681723
RE: Index fragmentation not cutting down to 0

On the other hand, I've found that it almost takes the same amount of time to filter out such tables as it is to try to defrag them because they...
--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 20, 2014 at 4:23 pm

#1681697

Viewing 15 posts - 24,691 through 24,705 (of 59,099 total)