Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,356 through 41,370 (of 59,069 total)

RE: The Value of Experience

dbo.benyos (10/24/2009)
BWAA-HAAAA!!!! So does any decent word processor!
I don't think you'd let any word processor enter any scheduled, unattended process inside production environments... My example was to show that in...
--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)

October 24, 2009 at 9:44 am

#1070389
RE: Are the posted questions getting worse?

Jack Corbett (10/24/2009)
Thanks guys. Made it through the night and she is fine. This is our first time with a "real" injury to our kids.
It's always a terrible...
--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)

October 24, 2009 at 9:41 am

#1070388
RE: query to modify

Lesson learned on my part...
--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)

October 24, 2009 at 9:36 am

#1070387
RE: Need help to write a loop store procedure

No need to declare an explicit transaction unless you're server is setup to require it. The default is not to require it.
Here's how I do such things in...
--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)

October 23, 2009 at 9:20 pm

#1070337
RE: Data like Crosstab

Agreed... no need for a Cursor... see the two articles that Jack pointed you to... I know the guy that wrote them. 😀
--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)

October 23, 2009 at 8:43 pm

#1070335
RE: How to Convert Varchar to datetime datatype

Minaz Amin (10/23/2009)
I have carchar datatype in the following format
'09-06-2005 00:00:00'
is there a way to convert this value to datetime type as I need to calculate the datediff between 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)

October 23, 2009 at 8:41 pm

#1070333
RE: I need help on how to become a SQL Server DBA

daniel.phone (10/21/2009)
I very much want to be a SQL Server DBA and I started by taking two database courses and I took MS 70-431 exam and passed. But I still...
--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)

October 23, 2009 at 8:37 pm

#1070332
RE: Copy table options...

schep021 (10/23/2009)
The code was originally written as select * into..which I am trying to get away from.
Why are you trying to get away from such a simple, effective, 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)

October 23, 2009 at 8:34 pm

#1070330
RE: 64 bit windows and 32 bit sql 2005

Jeffrey Williams-493691 (10/23/2009)
free_mascot (10/22/2009)
The only reason what I am looking is that you have already purchage 32bit sql licence and having the new 64bit hardware.
There is no such thing 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)

October 23, 2009 at 8:31 pm

#1070329
RE: Trying to not use Cursors - Eliminating Duplicates

As a side bar, if you had setup some test data and provided the scripts to gen that test data, any solutions folks gave you would probably already be tested....
--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)

October 23, 2009 at 8:25 pm

#1070328
RE: executing dos commands

Depending on your level of comfort with the DOS gods, I'd recommend either xp_CmdShell or SSIS. If you were to post a wee bit more information using the techinques...
--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)

October 23, 2009 at 8:17 pm

#1070325
RE: median

How many distinct items do you need to calculate a median for? In other words, do you have to calculate a median for every "grouped" item in a table?...
--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)

October 23, 2009 at 8:04 pm

#1070323
RE: Vacations, calendars, etc. etc. - where do I start

nick-1121133 (10/23/2009)
Here's the beginning of the problem and any feedback will be very welcome - I am not seeking a programmed solution just yet (although if someone has one of...
--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)

October 23, 2009 at 8:01 pm

#1070322
RE: Money vs. Decimal Data type

repent_kog_is_near (10/23/2009)
Under what circumstance does Float do the approximations? Are there definite situations when it gets unpredictable?
Dan
They're done some fixes in SQL Server 2005 and up but let's take an...
--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)

October 23, 2009 at 7:41 pm

#1070319
RE: The Value of Experience

Vivien Xing (10/23/2009)
dbo.benyos (10/23/2009)
For instance, a guy with some UNIX knowledge will never write a script to replace strings in a text file. He'll use SED command instead. If 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)

October 23, 2009 at 7:29 pm

#1070316

Viewing 15 posts - 41,356 through 41,370 (of 59,069 total)