Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,486 through 43,500 (of 59,102 total)

RE: Mining for Quitters

GSquared (6/11/2009)
Don't disagree with you about the need for human involvement in the process. I just think a system that can do things like track average national and local salaries...
--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)

June 11, 2009 at 9:12 am

#1008067
RE: Programming Training

http://www.sqlservercentral.com/Forums/Topic695088-149-1.aspx#bm695796
bpowers (4/13/2009)
Not quite sure how to go about the suggestions. To say I am a novice is an understatement. Here is the table I put together. How do I implement...
--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)

June 10, 2009 at 10:15 pm

#1007772
RE: convert from varchar to datetime

abhavsar (6/10/2009)
SELECT date_id
FROM Summary_D
Brings data in following format.
May 17 2009 12:00AM
May 18 2009 12:00AM
May 22 2009 12:00AM
May 26 2009 12:00AM
May 27 2009 12:00AM
Jun 1 2009 12:00AM
May 20 2009 12:00AM
May...
--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)

June 10, 2009 at 9:41 pm

#1007767
RE: Differences between Unicode Text and ASCII text file

jagadish_sds (6/10/2009)
That differences I knew, I am asking what is the differecne between Unicode & ASCII text file in SQL Server, both are generating .sql file and content also same....
--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)

June 10, 2009 at 9:37 pm

#1007766
RE: Random problems

christian_nowicki (6/10/2009)
Peso (6/9/2009)
And it's also well established that
ABS(CHECKSUM(NEWID())) % 100
gives random numbers between 0 and 99 with very high, good and even distribution.
I like this solution - it is simpler...
--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)

June 10, 2009 at 9:35 pm

#1007765
RE: Differences between Unicode Text and ASCII text file

RBarryYoung (6/10/2009)
What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.
Any idea if SQL Server supports UTF-8?
--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)

June 10, 2009 at 9:16 pm

#1007762
RE: Week numbers and week start dates

balars_2000 (6/10/2009)
thanks jeff.
You bet. Thanks for the feedback. So, are you all set or do you have a remaining question?
--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)

June 10, 2009 at 8:39 pm

#1007755
RE: Differences between Unicode Text and ASCII text file

It's what you can't see that makes the difference... the following is a very good article on the subject...
http://www.joelonsoftware.com/articles/Unicode.html
As a side bar, it took me about 2 minutes to...
--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)

June 10, 2009 at 8:27 pm

#1007753
RE: Updating diff columns & multiple rows of same table

{insert jeaopardy them song here} Heh... I'll just bet someone talked him into a cursor solution.
--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)

June 10, 2009 at 8:00 pm

#1007747
RE: Using sp_executesql to create dynamic sql

Using QUOTENAME will pretty much put the kabosh on SQL Injection. But, I agree... if it's not used in a public facing environment, there's not much need 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)

June 10, 2009 at 7:57 pm

#1007746
RE: Clustered Primary key index on INT column or on a date column

Lynn Pettis (6/10/2009)
If your date queries are range based, then the clustered index on the date column may be worthwhile. Remember, the clustered index is the order in which...
--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)

June 10, 2009 at 7:51 pm

#1007744
RE: Are the posted questions getting worse?

lmu92 (6/10/2009)
It's not that hard to generate sample data - but it's time consuming.
It's a lot less time consuming than putting it into an excel spreadsheet, attaching the file, 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)

June 10, 2009 at 7:11 pm

#1007738
RE: Mining for Quitters

GSquared (6/10/2009)
BUT, in a company with thousands of employees, can top management, or even upper middle management, actually get to personally know every employee?
Absolutely agreed. I didn't say they...
--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)

June 10, 2009 at 6:36 pm

#1007730
RE: Mining for Quitters

GSquared (6/10/2009)
So, in other words, no human anywhere should use any tool for anything, because it will cause the loss of responsibility and "the human touch".
I don't believe anyone even...
--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)

June 10, 2009 at 6:15 pm

#1007724
RE: Mining for Quitters

Mad Hacker (6/10/2009)
Although I was initially receptive to this idea, I've about decided that the benefit(s) may not outweigh the costs. Although it sounds like a great idea on...
--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)

June 10, 2009 at 11:54 am

#1007600

Viewing 15 posts - 43,486 through 43,500 (of 59,102 total)