Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,986 through 36,000 (of 59,102 total)

RE: Are the posted questions getting worse?

bitbucket-25253 (11/21/2010)
Thanks Jeff I needed a good laugh. Oh and let me buy you a drink at the Friday night dinner for speakers at SQL Sat#60
It will be my...
--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)

November 22, 2010 at 12:34 am

#1253596
RE: selecting 'next min() date' from a historic recordset

Also, take a look at the article at the first link in my signature below. It'll help you get coded answers on your next 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)

November 21, 2010 at 7:05 pm

#1253562
RE: How to repeat/or duplicate my results?

clarks (11/19/2010)
Nevermind, I got it! I'm a little "Slow" on Friday's. Thanks for the help!:hehe:
That's cool. Would you mind posting your final code so others may learn how 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)

November 21, 2010 at 7:03 pm

#1253561
RE: log file fills up in simple recovery model

There's no long running transaction right now... it sounds to me like someone wrote an accidental cross join (inner join with many-to-many relationship... same affect as cross join).
--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)

November 21, 2010 at 6:58 pm

#1253560
RE: Learn cross tab query

CELKO (11/19/2010)
I give several ways to do this in SQL FOR SMARTIES.
BWAA-HAA!!! Spam reported! 😉
--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)

November 21, 2010 at 6:42 pm

#1253558
RE: fetch from cursor seems to be much slower than original query

marko61 (11/19/2010)
Leo & Lutz
I'd just got as far as collecting some trace data (which showed 31M rows being read instead of a couple) when the developer arrived and said they'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)

November 21, 2010 at 6:40 pm

#1253557
RE: fetch from cursor seems to be much slower than original query

Leo.Miller (11/18/2010)
Avoid using cursors!
Cursors are row based queries, in simple terms SQL defines which rows are required in what can be thought of as a temporary structure. Then when you...
--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)

November 21, 2010 at 6:36 pm

#1253556
RE: Computed column help, or another direction?

Jeff Sims-413169 (11/19/2010)
They want to build a DB for our pc naming which will automatically give the pc techs the next pcname to use when installing a new pc. ...
--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)

November 21, 2010 at 6:34 pm

#1253555
RE: Finding current and prior date

CELKO (11/19/2010)
SELECT P1.part_nbr, P1.part_price AS current_part_price,
...
--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)

November 21, 2010 at 6:32 pm

#1253554
RE: How to enforce business rule (Constraint?)

CELKO (11/19/2010)
The full details are going to be part of the second edition of my TREES & HIERARCHIES book, but the article will get you started.
What is the expected...
--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)

November 21, 2010 at 6:18 pm

#1253552
RE: Want to append to different values to a output

And please post what you've actually tried.
--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)

November 21, 2010 at 6:14 pm

#1253551
RE: simple sp

nazaninahmady_sh (11/20/2010)
thanks but i want the records after that Max(ID), with all of their fields
Gosh, would you at least try? The code posted by Bit-Bucket contains the essence of...
--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)

November 21, 2010 at 6:12 pm

#1253550
RE: Indexes

Tara-1044200 (11/21/2010)
I have nearly 20 databases which are compltely itenditical . I would like do some check every time i do some data loads into those databses so that 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)

November 21, 2010 at 6:05 pm

#1253547
RE: SQL Book

GilaMonster (11/21/2010)
jagirdba (11/21/2010)
In that case you appear to have problem with your brain your self. Secondly if I was a neurosurgeon I would surely suggest a good book.
Thanks for...
--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)

November 21, 2010 at 6:03 pm

#1253546
RE: Poor Restore Times

Di you have other things running on the server, as well?
--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)

November 21, 2010 at 5:52 pm

#1253545

Viewing 15 posts - 35,986 through 36,000 (of 59,102 total)