Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,106 through 33,120 (of 59,099 total)

RE: What traits does an SQL Server Developer need?

Ian86Myers (7/26/2011)
Hi, I'm new to SQL server. I'd like some opinions on what people think makes for a strong SQL Server Developer. Specifically what traits and skill sets are...
--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 26, 2011 at 10:49 pm

#1358951
RE: Create Random Generated Primary Key

chadphillips807 (7/26/2011)
Hello,
So I have been tasked with creating a table where the Primary Key is a 10 digit number and is randomly generated with each insert. NEWID() and NEWSEQUENTIALID() are...
--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 26, 2011 at 10:43 pm

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

I guess I'm out of tricks, then. I can't troubleshoot any further from here. My apologies.
--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 26, 2011 at 10:37 pm

#1358947
RE: New line Charecter

@SQLFRNDZ (7/26/2011)
CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))
returns @temptable TABLE (items varchar(8000))
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)

July 26, 2011 at 10:16 pm

#1358943
RE: dynamic pivot maybe?

This is a simple "pivot" problem... except I don't care for using PIVOT because it's slower than classic "Cross Tab" code and I don't care for its structure. 😉
Let's peel...
--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 26, 2011 at 9:39 pm

#1358933
RE: Transition to Oracle?

My recommendation would be to study Oracle on your own a bit before making such a move. There's a huge paradigm shift between PL/SQL and T-SQL. At least...
--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 26, 2011 at 8:49 pm

#1358926
RE: Adding a Decimal Value to a DateDiff Statement

DATEDIFF doesn't work the way most people think. It works on the borders of days (ie: midnight). For example, even though the following dates are only 3 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)

July 26, 2011 at 8:36 pm

#1358925
RE: Query to find matching rows

You bet, Marcelo. 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 26, 2011 at 9:39 am

#1358621
RE: dynamic pivot maybe?

Use methods similar to those found in the following article...
http://www.sqlservercentral.com/articles/Crosstab/65048/
Instead of using SUM or COUNT on the DATETME and character based columns, use MAX, instead.
If you'd like a coded answer...
--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 6:43 pm

#1358212
RE: Query to find matching rows

Chelo (7/25/2011)
hello-
I'm working with a database that contains a table with IDs to create Relationships and Reciprocal records in the database. The table with the IDs for 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)

July 25, 2011 at 6:30 pm

#1358207
RE: Estimate Table size

If you insist on an estimation, there's a section in Books Online called "estimating table size" in the index. Personally, I think that's a huge PITA although you could...
--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 5:53 pm

#1358200
RE: Are the posted questions getting worse?

john.arnott (7/25/2011)
Would it be OK to submit this as a QOD?
Question:
What's the answer?Answer choices:
It depends.
It doesn't depend.
What's the question?
I think there's a tpyo in here so I can only guess.
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)

July 25, 2011 at 5:15 pm

#1358193
RE: Are the posted questions getting worse?

mtillman-921105 (7/25/2011)
Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master"...
--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 5:01 pm

#1358190
RE: Are the posted questions getting worse?

jcrawf02 (7/22/2011)[hrAnyone who is using them to be *busier* is doing it wrong.
That's what I used to think... then I became a regular poster on SSC.:-P
--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:51 pm

#1358189
RE: Are the posted questions getting worse?

LutzM (7/21/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. 😉
Vote added.
Thank you Jeff for all the help 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 4:45 pm

#1358188

Viewing 15 posts - 33,106 through 33,120 (of 59,099 total)