Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,461 through 47,475 (of 59,095 total)

RE: Auto grow option

Matt Miller (11/3/2008)
I would usually advise to leave autogrow on. Not leaving auto-grow on means your database runs the risk of running out of space, in which case everything...
--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 3, 2008 at 7:16 pm

#893373
RE: Introduction to DML Triggers

Dang it, Jack! Somehow I missed this article when it was published. Found it as a link in one of your good posts. Awesome article especially 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 3, 2008 at 6:53 pm

#893365
RE: Page Splits

mark.hall (11/3/2008)
I've got an SQL server where my avg. page splits per second is 3-4. However there is process that runs twice a day when this process is running...
--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 3, 2008 at 6:30 pm

#893361
RE: compressing / collapsing numbers

OMG! LMAO! Stop it! {Clutching at sides trying to catch a breath} That's just too funny! 😛
--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 3, 2008 at 6:21 pm

#893359
RE: using CLR assembly

J (11/3/2008)
Never used CLR yet. This was supposed to be the greatest thing since sliced bread.
Jeff, would you please enlighten me as to why CLR is viewed as a bad...
--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 3, 2008 at 6:18 pm

#893356
RE: Subquery and Join (Speed)

I appreciate the comments guys. Thank you very much. Perhaps I will write it up as an article with a couple of more "gotcha" examples... Thanks again.
--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 3, 2008 at 6:11 pm

#893354
RE: Query data with manipulation

jack_hc (11/3/2008)
Jeff Moden (10/31/2008)
jack_hc (10/30/2008)
Hi,
I am facing a problem to extract data from a table, the table contains over 41k records, and some of them(>5k) share same column value, now...
--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 3, 2008 at 5:58 pm

#893351
RE: Please need help on looping through the dataset!!!

It's amazing, even to me, how often that particular solution has been used, lately. Nice job, Seth. 🙂
--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 3, 2008 at 5:55 pm

#893350
RE: Need help on performance and integrity

Heh... I wanna know who ever said that "set based" meant "everything done in one query... 😛
--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 3, 2008 at 5:46 pm

#893348
RE: Last Day of Month subscription for Shared SSRS schedule

Angela Henry (10/31/2008)
An update on this.
I thought I had figured out how to do this. I set up a total of three separate shared schedules (not bothering with leap...
--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 3, 2008 at 5:41 pm

#893347
RE: Field Type to use for Elapsed Time in HH:MM?

charles.frank (11/3/2008)
Thanks for all of these ideas. They've helped me narrow the scope of what I need. I'm most interested in the amount of time that machines take...
--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 3, 2008 at 5:39 pm

#893346
RE: compressing / collapsing numbers

Garadin (11/3/2008)
Trying... to... resist...
Gah.
BWAA-HAAAA!!! You're addicted! Now, that's some funny stuff right there! 🙂
Nice job on the code, Seth. Only thing you might want to try,...
--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 3, 2008 at 5:31 pm

#893344
RE: BULK INSERT & Text Qualifier

Ummm... the answer is actually near the beginning of this thread. Instead of waiting, read the rest of the thread.
--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 3, 2008 at 5:37 am

#892939
RE: Expressions based on data in the SELECT statement

jeanangeo,
Where does "SessionTypeX" come from in your desired results?
--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 2, 2008 at 10:16 am

#892838
RE: Exercise to practise SQL

I agree... you want practice? THIS is the place to get it. Lot's of books have the same ol' stuff and while they may be good for rank...
--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 1, 2008 at 11:46 pm

#892787

Viewing 15 posts - 47,461 through 47,475 (of 59,095 total)