Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,501 through 31,515 (of 59,101 total)

RE: Problem during inserting row in a table ( sql server 2005)

TheSQLGuru (1/5/2012)
>> "you also have a pot-wad of indexes"
Jeff, is "pot-wad" a new technical term coined by the Standing Exceptional DBA?? 😎
Heh... my Grand Father gave me the term...
--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 5, 2012 at 9:19 pm

#1429445
RE: Primary Keys are necessary for good database design

Thanks for the feedback, Steve. I was absolutely amazed at how she turned such a potentially dry subject into something so interesting and useful.
--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 5, 2012 at 9:02 pm

#1429442
RE: Date Range in Ms sql

margieleneespanol (12/20/2011)
How can I display a result with given date range.
I need a syntax for it.
Thanks
:crazy:
Are you all set now or what??? :blink:
--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 5, 2012 at 8:42 pm

#1429439
RE: Are the posted questions getting worse?

SQL Kiwi (1/5/2012)
Jack Corbett (1/5/2012)
Have had a discussion with Aaron Bertrand about case-sensitivity recently.
You knows he's super-anti-underscores?
Makes two of us.
--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 5, 2012 at 8:27 pm

#1429436
RE: Are the posted questions getting worse?

Brandie Tarvin (1/5/2012)
I don't know if anyone's posted this or not (my memory fails me after working a 22 hour shift):
"Whatta ya mean it's 2012? I'm not done with 2011...
--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 5, 2012 at 8:25 pm

#1429435
RE: Are the posted questions getting worse?

Stefan Krzywicki (1/5/2012)
jcrawf02 (1/5/2012)
Brandie, not sure what you're referring to exactly, but nothing I've seen on the Thread would make me decide to not hire someone. Make them question my...
--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 5, 2012 at 8:22 pm

#1429434
RE: Are the posted questions getting worse?

Brandie Tarvin (1/5/2012)
Assuming you didn't know any of the participants in this conversation or understand the purpose of The Thread, how many of you would view comments posted by other...
--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 5, 2012 at 8:21 pm

#1429433
RE: Are the posted questions getting worse?

Lynn Pettis (1/5/2012)
Ninja's_RGR'us (1/5/2012)
Steve Jones - SSC Editor (1/5/2012)
In terms of depreciation, it sucks, but it's real. The value of your stuff is lower over time, and if you had...
--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 5, 2012 at 8:14 pm

#1429432
RE: How to diplomatically not answer recruter's question about salary ?

But it IS worth continuing if you're good at what you do. It's all part of the negotiations. I've seen several good DBA's get better than the range...
--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 5, 2012 at 7:50 am

#1429032
RE: How to diplomatically not answer recruter's question about salary ?

Actually, my best advice is that most employers want a DBA that knows the job and can make decisions. Part of knowing the job is what the current industry...
--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 5, 2012 at 6:15 am

#1428953
RE: Problem during inserting row in a table ( sql server 2005)

kumar.sachu08 (1/5/2012)
I know i am fresher....and i am giving interview......i have only 1 years of experience.
then what should i do....when any interviewer asking like such type of question ?
Should 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)

January 5, 2012 at 6:01 am

#1428946
RE: Are the posted questions getting worse?

Koen Verbeeck (1/4/2012)
Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)
Did I miss anything...
--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 5, 2012 at 5:47 am

#1428940
RE: Censoring the Internet

Revenant (1/4/2012)
Yes, from say American perspective. However, foreign countries are not obliged to follow American law with its 70 years copyright extensible by another 70. Only EU harmonizes its...
--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 4, 2012 at 5:35 pm

#1428761
RE: Quirky Update query...works on server ...fails on PC.

CELKO (1/4/2012)
The "quirky" update flaw is based on the old Sybase contigous storage model. The problem is that it is unpredictable; the data comes back in whatever is on 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)

January 4, 2012 at 3:41 pm

#1428735
RE: Censoring the Internet

But there is a process. It's the same process someone has to go through with any "Cease and Desist" order.
I'll also add that there are many websites (for example)...
--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 4, 2012 at 6:09 am

#1428244

Viewing 15 posts - 31,501 through 31,515 (of 59,101 total)