Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,891 through 37,905 (of 59,072 total)

RE: Need Expert advice on my sql query for speed improvement

Agile (6/27/2010)
Thanks guys! I think it's too much if I ask again what are the meaning of the items that you inserted. I'll just study them by my self 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 27, 2010 at 9:49 pm

#1185492
RE: Are the posted questions getting worse?

lmu92 (6/27/2010)
Matt Miller (#4) (6/27/2010)
...
It's hard to even support that claim (the "dodgy decision" one). I can't believe FIFA actually tolerates the shoddy refereeing that's being shown. It seems...
--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 27, 2010 at 9:44 pm

#1185491
RE: Are the posted questions getting worse?

Lynn Pettis (6/27/2010)
I will agree that there have been some bad calls, some made and some that should have. Over all, however, I think the officiating has been good....
--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 27, 2010 at 9:41 pm

#1185489
RE: T-SQL for creating a text file with with this filename format - Month(MM)Day(dd)Year(yyyy).Log

Agile (6/27/2010)
sorry for that... I have to get yesterday date.
Thanks
Morris
In that case, I'd use sqlcmd to write out the correct bcp command to another batch file and then execute...
--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 27, 2010 at 9:33 pm

#1185488
RE: looping through table values, exporting to excel

vani_r14 (6/9/2010)
Hi there
please find attached is the document that can help you with this. It has screenshots and steps as i learnt while doing this... Hope it helps...
Let me know...
--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 27, 2010 at 9:23 pm

#1185486
RE: T-SQL for creating a text file with with this filename format - Month(MM)Day(dd)Year(yyyy).Log

Agile (6/27/2010)
Thanks for the reply, Im using it in Cmd Prompt. (As .bat file)
Ok... and which date would you like to use? Today's date or something else? If...
--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 27, 2010 at 9:15 pm

#1185484
RE: First Tally Table T-SQL

Paul White NZ (5/14/2010)
Hey Jeff,
As you know, there's nothing much in either of your replies that I don't agree with. 🙂
I set a pretty high bar for SQLCLR code that...
--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 27, 2010 at 9:10 pm

#1185483
RE: Convert CSV values in three columns to rows

mishaluba (6/27/2010)
Thank you very much, lmu92 ! Great solution and exactly what I need.
As a side note I did a search on this site for "DelimitedSplit8K", but I can't...
--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 27, 2010 at 8:56 pm

#1185480
RE: T-SQL for creating a text file with with this filename format - Month(MM)Day(dd)Year(yyyy).Log

Agile (6/27/2010)
Guys, Is there a T-SQL that I can use to create a text file and with .Log file extension?
The process would be, I will get the data from a...
--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 27, 2010 at 8:45 pm

#1185478
RE: Variable Table Names in SP ?

Let's start this off with a little data analysis... Unless I'm totally off my rocker (heh... which is always a possibility :-D), all of the following code...
IF @Segment = 6
IF...
--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 27, 2010 at 8:37 pm

#1185476
RE: database settings

Contrary to what seems to be the popular opinion and depending on who has access to the server, I'll usually set the max number of CPU's to be used for...
--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 27, 2010 at 7:21 pm

#1185473
RE: The Phantom DBA

andrewkane17 (6/25/2010)
One other thing about smaller shops is that the DBA is generally not chargeable to the client, I worked at a shop where anyone who touched the databases was...
--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 27, 2010 at 6:38 pm

#1185470
RE: Working with Currenty -- Looking for case studies or how others have done it.

PaulB-TheOneAndOnly (6/27/2010)
At the granular level I would store all figures in the currency of origin and I'll identify the currency.
I would also have a DIM_CURRENCY_CONVERSION table storing daily conversion rates...
--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 27, 2010 at 6:10 pm

#1185464
RE: store password and user name

GilaMonster (6/26/2010)
Jeff Moden (6/26/2010)
Since HASHBYTES doesn't use any form of encryption key, ... Don't use HASHBYTES as a form of encryption.
It's not a form of encryption, it's a one...
--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 27, 2010 at 5:26 pm

#1185461
RE: How to Get Random Numbers

Dave Ballantyne (6/27/2010)
Thanks Jeff , hindsight on the isnull issue 😉
http://beyondrelational.com/blogs/dave_ballantyne/archive/2010/05/19/null-or-coalesce-what-s-the-difference.aspx
Heh... yeah... hindsight is 20/20. That's a nice, short, to-the-point blog article, Dave. Keep up the good work....
--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 27, 2010 at 4:58 pm

#1185457

Viewing 15 posts - 37,891 through 37,905 (of 59,072 total)