Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,121 through 33,135 (of 59,099 total)

RE: Are the posted questions getting worse?

Steve Thompson-454462 (7/22/2011)
Gianluca Sartori (7/19/2011)
There's someone you all know that deserves your vote here[/url].
I'm sure you know who I'm talking about. 😉
Jeff gets my vote.
One of the first articles 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)

July 25, 2011 at 4:41 pm

#1358186
RE: Are the posted questions getting worse?

Jack Corbett (7/20/2011)
Congrats to Jeff for the Exceptional DBA nomination.
Sorry about the late reply. Thanks for the congrats, Jack.
--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)

July 25, 2011 at 4:36 pm

#1358182
RE: Urgent: Handling [& , ' etc] in TSQL

That would be a problem with your dynamic SQL. How are you doing the EXEC???
If you're using EXEC @somevariable, that's the wrong way to do it. You need...
--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)

July 25, 2011 at 11:40 am

#1358009
RE: select into.. "datetime"

Tara-1044200 (7/25/2011)
I doing select into for some tables from SQl 2005 database to SQl 2008 which has few date fields, the date fields are "smalldatetime" data type in the source...
--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)

July 25, 2011 at 7:44 am

#1357772
RE: becoming a DBA

It's a tough job description to break into "cold". My recommendation would be to begin your diversification and training where you currently work. Even for a "junior" 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)

July 25, 2011 at 7:42 am

#1357771
RE: How to add column in specific position

For all those balking about column order not mattering in a table, I absolutely agree when it comes to programming.
But, for troubleshooting, it's sometimes very helpful and can save some...
--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)

July 25, 2011 at 7:39 am

#1357766
RE: Career Advice - SQL Server Development ---Please Help!

It's really hard for a fresher to get into the "SQL Developer" position. They usually want an SQL Ninja. Even places hiring a "Junior" SQL Developer want you...
--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)

July 25, 2011 at 7:28 am

#1357754
RE: Leave Developers Alone

bwillsie-842793 (7/25/2011)
Jeff Moden (7/25/2011)[hr...Sure, I agree that everyone needs a break here and again during the day, but not hours-long breaks.
I think there's a big difference between a "break" and...
--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)

July 25, 2011 at 7:21 am

#1357752
RE: How to Delete Right 3 Characters from a string

Kingston, you're the consumate gentleman and a dedicated programmer. I'd work with anytime. Thank you for the feedback. 🙂
--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)

July 25, 2011 at 4:58 am

#1357682
RE: Recursion in T-SQL

ghanshyam.kundu (7/25/2011)
i just took a chance
Interesting way to do the same as Celko's infamous "push stack" conversion. Thanks for posting it.
I have code that will generate a million...
--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)

July 25, 2011 at 4:49 am

#1357678
RE: Leave Developers Alone

One study finds a 10 point IQ drop from regular email and phone interruptions.
BWAA-HAAA!!!! That explains the first 4 letters of "twitter". 😀
It's a trade off. I've...
--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)

July 25, 2011 at 4:18 am

#1357667
RE: How to create a CLR assembly on a remote server with limited permissions

lenne_dk (7/25/2011)
I think this article could also be listed as "how to compromise the databaseserver, when you have compromised the webserver" 😉
Agreed. Add to that the subtitle of "while...
--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)

July 25, 2011 at 4:05 am

#1357664
RE: Career Advice - SQL Server Development ---Please Help!

Do you have any experience with databases at all? Also, what is it that you've been doing for the last 10 years?
--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)

July 24, 2011 at 8:10 pm

#1357592
RE: Urgent: Handling [& , ' etc] in TSQL

Sridoc2020 (7/24/2011)
Do you know how I can force to accept following name in above query which contains comma
18765_McHaney,Packet,DI,4.2.10_1
At the risk of offending you, you have to start trying what 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)

July 24, 2011 at 7:00 pm

#1357585
RE: guaranteed unique?

Jules Bonnot (7/19/2011)
Does anyone how unique this is? How many times I would have to run it before I found a duplicate.
select ABS(CAST(CAST((newid()) AS VARBINARY(5)) AS Bigint))
I did the analysis,...
--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)

July 24, 2011 at 3:10 pm

#1357567

Viewing 15 posts - 33,121 through 33,135 (of 59,099 total)