Jeff Moden

Forum Replies Created

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

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
RE: What Server Am I Running From

Why not just map a drive on each server and use the same drive letter on each server?
--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 7:39 pm

#923859
RE: Table with 60 columns

roy vagner (1/8/2009)
I have a table with 60 columns (most of the columns are int)
what is better for performance?
Leave the table like that or divide it for 2 or 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 6:58 pm

#923849
RE: highest unused ID

Either of the following will meet your requirements... 😉
SELECT MIN(RowNum)+1
FROM dbo.JbmTest
WHERE RowNum+1 NOT IN (SELECT RowNum FROM dbo.JbmTest)
SELECT MIN(RowNum)+1
FROM dbo.JbmTest...
--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 6:51 pm

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

gvsriramakrishna (1/7/2009)
Hi Mike,
Seems the query is taking a while to execute. I tried it for 20minutes.. not have seen any output.
Does this have any performance dependancy on the size 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)

January 8, 2009 at 6:25 pm

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

Chris Morris (1/8/2009)
Apart from anything else, the emphasis on teaching will give you quite a bit of leeway with the "give a man a fish" scenario. We've all been there,...
--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 6:24 pm

#923840
RE: Two different columns to one single column (JOIN)

Fábio (1/8/2009)
Thank you also Jeff, how could I not think about referencing the table twice :blink:
You were probably thinking about alligators, instead... 😉
--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 11:35 am

#923586

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