Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,421 through 51,435 (of 59,091 total)

RE: The Exceptional DBA

See? Exceptional DBA... 😀
--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)

March 31, 2008 at 6:46 am

#795890
RE: Bachelors degree - Who has one, or even more education?

Jack Corbett (3/30/2008)
I have nothing against getting a degree, but, as Jeff said, I am not sure what you gain on top of your experience. Do you feel green...
--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)

March 31, 2008 at 6:02 am

#795867
RE: Bachelors degree - Who has one, or even more education?

Sam's example is not an exception, either. I've heard the same story more than once.
Also, Sam is spot on about "hard work" and "common sense". There are a...
--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)

March 31, 2008 at 6:01 am

#795865
RE: cursor to identify changed,deleted and added records

Robert (3/31/2008)
Maybe because he/she means the broader meaning of cursor.
Considering the level of the question, I wouldn't think so. I sure wish the OPs would answer these questions so...
--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)

March 31, 2008 at 5:51 am

#795863
RE: Deleting millions rows from some tables

Most people crab about the duplicate disk space while that happens. If you don't mind that, then yes, the method you spoke of will be faster.
The problem is, the...
--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)

March 31, 2008 at 5:40 am

#795859
RE: cursor to identify changed,deleted and added records

chinni (3/30/2008)
they asked to use curser becoz it needs to check the records every time for the changes for every baselineobject...........
I don't understand... why do you think that requires a...
--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)

March 30, 2008 at 5:26 pm

#795743
RE: Problem with duration in profiler n query editor

10813 is in milliseconds... 10813330 is in microseconds... divide micoseconds by 1000 to get milliseconds.
--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)

March 30, 2008 at 5:22 pm

#795742
RE: Strategy to build a history

Do a search for "Audit Log"...
--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)

March 30, 2008 at 5:18 pm

#795741
RE: SELECT Statement Question

Anirban Paul (3/27/2008)
Hi Roberta
I am late to join this discussion. Did you explore this library http://msdn2.microsoft.com/en-us/library/ms177673.aspx
It is a mine for T-SQL statements. I think most of your queries should be...
--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)

March 30, 2008 at 5:11 pm

#795740
RE: Need help on small project from SQL professional

😀
--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)

March 30, 2008 at 5:02 pm

#795738
RE: Bachelors degree - Who has one, or even more education?

I've got news for you Cory... getting the Bachelor's degree didn't make those guys smarter about SQL Server nor did it get them their jobs. A well written resume...
--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)

March 30, 2008 at 9:57 am

#795703
RE: CLR Code to run Generic Command Prompt Commands

Todd Engen (3/30/2008)
Both of those can be addressed by a CLR stored procedure.
No... not in this case... not when the CLR does what the OP requested which is to basically...
--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)

March 30, 2008 at 9:07 am

#795701
RE: Bachelors degree - Who has one, or even more education?

I'm not really trying to discourage anyone from getting a degree... but consider this...
Against my wishes, the company hired a guy who had a PHd in Mathematics as the...
--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)

March 29, 2008 at 11:24 pm

#795677
RE: Bachelors degree - Who has one, or even more education?

Before you even think of spending the 20 to 30 thousand dollars to get a Bachelor's degree...
Why do you feel like the "green guy"? Why do you feel...
--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)

March 29, 2008 at 11:08 pm

#795676
RE: Need help on small project from SQL professional

Why not just post the problem(s) and see what you can get for nothing on this forum? Maybe people will even bid for the "job". 😉
--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)

March 29, 2008 at 10:43 pm

#795674

Viewing 15 posts - 51,421 through 51,435 (of 59,091 total)