Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,416 through 38,430 (of 59,102 total)

RE: Sample database design, development, test and deployment for an online student class.

Steve Jones - Editor (5/14/2010)
If you know a bit, post what you know, or what you'd do, and then what you are confused about. As Gail mentioned, we don't do...
--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)

May 14, 2010 at 9:39 pm

#1167862
RE: Sample database design, development, test and deployment for an online student class.

Irfan-358189 (5/14/2010)
I am sorry If i have asked more than i should.I just want a step by step documentation to how to design and develop database.I know i will have...
--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)

May 14, 2010 at 9:27 pm

#1167861
RE: Find PreviousChange of date

jez.lisle (5/14/2010)
I have a simple table of which is an extract below, I have a query that will order each job by row number , what I want to do...
--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)

May 14, 2010 at 9:06 pm

#1167860
RE: Author Guidelines

Here are a couple of more tips about things that either I use or that aggravate the heck out of me...
1. While it’s ok to write articles about things...
--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)

May 14, 2010 at 8:57 pm

#1167859
RE: More, More, More

Cory E. (5/14/2010)
Jeff Moden (5/14/2010)
3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely disagree 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)

May 14, 2010 at 3:16 pm

#1167794
RE: More, More, More

Stefan Krzywicki (5/14/2010)
Cory E. (5/14/2010)
Jeff Moden (5/14/2010)
3. No... I disagree... old threads should NEVER be locked. Every once in a while, I'll come across one that I absolutely...
--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)

May 14, 2010 at 3:08 pm

#1167790
RE: Adding Header and Trailer

The Dixie Flatline (5/13/2010)
Be advised that UNION ALL will only help you if the header/trailer rows have identical layouts. The whole header/trailer idea is totally alien 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)

May 14, 2010 at 3:02 pm

#1167787
RE: Sum pivot columns

🙂
--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)

May 14, 2010 at 1:15 pm

#1167747
RE: Comparing two rows in one table for changes in column

Dobermann (5/13/2010)
Just getting an internet connection again (I'm in the boonies with not so much as even dial up). Mister.Magoo, what you did gives perfect results! I have...
--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)

May 14, 2010 at 1:12 pm

#1167743
RE: More, More, More

First, my hat is off to Steve and the rest of the crew that have made this site (IMHO) the best SQL Server related site in the world. I'd...
--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)

May 14, 2010 at 12:48 pm

#1167730
RE: First Tally Table T-SQL

mister.magoo (5/14/2010)
Paul White NZ (5/14/2010)
mister.magoo (5/14/2010)
That sounds about right - the SQLCLR version is blindingly fast in my tests too....Someone must be able to make a T-SQL version that comes...
--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)

May 14, 2010 at 6:07 am

#1167455
RE: First Tally Table T-SQL

Paul White NZ (4/27/2010)
nfs_john (4/27/2010)
I agree an assembly would be the best approach. Why recreate the wheel and an assembly would be more globally universal for others to make use...
--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)

May 13, 2010 at 5:58 pm

#1167261
RE: First Tally Table T-SQL

Paul White NZ (4/27/2010)
Well you certainly could do it that way - but it seems very inefficient to split, convert, and then concatenate again.
Much faster to do it all 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)

May 13, 2010 at 5:39 pm

#1167252
RE: CTE performance

kazim.raza (5/13/2010)
Lol... So far so good.. both the design and our 'friend' 😛
I want to discuss that with you... how about if get you the schema of our data mart?...
--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)

May 13, 2010 at 5:09 pm

#1167246
RE: how much time it will take to get the records from a large table

David Portas (5/13/2010)
That's different to your original question. Take a look at the execution plan. See if your query is taking advantage of indexes on your tables and consider creating...
--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)

May 13, 2010 at 2:16 pm

#1167191

Viewing 15 posts - 38,416 through 38,430 (of 59,102 total)