Jeff Moden

Forum Replies Created

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

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
RE: Space used by NULL value in different data type columns

only4mithunc (11/21/2010)
Thanks a lot Jeff,
When I tried those two things, I'm able to see the difference... 🙂
And thank you for the feedback.
--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:46 pm

#1253544
RE: unable to shrink log file

steveb. (7/24/2008)
-Take a full backup
-Change database to Simple logging
-Shirnk Log
-Change database back to full logging
Be careful though as Log files grow to a size that they need 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 5:43 pm

#1253542
RE: Transforming string for ImagePath

And, apparently, the REPLACE is not necessary. 😉
--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:37 pm

#1253541

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