Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,051 through 46,065 (of 59,101 total)

RE: Adding running number on groups of records in a table

Heh... ah yes... THAT one. And because I'm a professional, I'm also supposed to be nice in the face of such abuse. I rewrote that one about 5...
--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 9, 2009 at 8:01 am

#924194
RE: Dropping database did not free disk space

Ninja's_RGR'us (1/9/2009)
They shouldn't, unless manually deleted.
How else would they be, Remi? 😉 And, what else can you think of that would cause these symptoms? :hehe:
--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 9, 2009 at 7:33 am

#924162
RE: Help needed to do performance tune in stored...

KSB (1/8/2009)
Hi All,
I am new to performance tuning. I wanted to do tune below stored procedure. Please help me that anything needs to be change.
My first question would be.... why...
--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 9, 2009 at 6:57 am

#924134
RE: Archive some records from db

Jack Corbett already suggested the correct solution. If the deletes are huge, then you need to write a loop to do the deletes in groups of 10 or 20,000...
--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 9, 2009 at 6:49 am

#924128
RE: Dropping database did not free disk space

Are you sure those files aren't simply sitting in the trash bin?
--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 9, 2009 at 6:08 am

#924076
RE: Selecting from temp table outside SP?

thj (1/8/2009)
Hi
I have a SP that has been running for 408 hours, computing Citrix statistics. The SP writes to a temporary table called #tmpResults, and I would like to know...
--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 9, 2009 at 6:03 am

#924072
RE: Datetime Checks

If the following formula results in zero, the data was entered today, regardless of time...
SELECT DATEDIFF(dd,datecolumn,GETDATE())
--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 8, 2009 at 10:11 pm

#923902
RE: Are the posted questions getting worse?

DavidB (1/8/2009)
Ah, another huge benefit of working from home. I look out my window, watch the snow swirling, look at the ice and snow on the van and shudder as...
--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 8, 2009 at 10:04 pm

#923901
RE: Are the posted questions getting worse?

Lynn Pettis (1/8/2009)
Amazing, isn't it? Three days ago I scraping ice off my car, today I walked at lunch without a jacket!
Amazing, isn't it? For the last 3...
--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 8, 2009 at 9:18 pm

#923889
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

You'll like this... takes just seconds to run on a half million rows... of course, you'll need to change #YourTable to your actual table name. For future...
--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 8, 2009 at 9:06 pm

#923886
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

gvsriramakrishna (1/8/2009)
480002 rows
I'll be right back...
--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 8, 2009 at 8:46 pm

#923878
RE: Adding running number on groups of records in a table

SQLMAIN (1/8/2009)
May be a minute or so.
That would be about right for 15M rows.
Just a bit of caution, though... make sure you follow ALL the instructions in the article. ...
--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 8, 2009 at 8:25 pm

#923876
RE: What Server Am I Running From

On the flip side, you can get the machine name and maybe go from there...
SELECT HOST_NAME()
--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 8, 2009 at 8:21 pm

#923874
RE: Update column3?

I can't help getting the feeling that was homework and the OP didn't 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)

January 8, 2009 at 8:17 pm

#923873
RE: Performance question

Micheal Young (1/8/2009)
Looking at Nitin's reply reminded me of a few coding things that can hinder performance (I'm basing this off my own experience).
1. If there are queries that 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)

January 8, 2009 at 8:06 pm

#923870

Viewing 15 posts - 46,051 through 46,065 (of 59,101 total)