Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,976 through 39,990 (of 59,098 total)

RE: Really complicated select statement

lmu92 (2/3/2010)
I'm not sure if I'm heading in the right direction...
If you want to see all order numbers with different values then you could use something like the following (untested,...
--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)

February 3, 2010 at 7:46 pm

#1113388
RE: Run a stored procedure from BCP

Perhaps include a fully qualified schema name instead of just "dot dot"?
--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)

February 3, 2010 at 7:00 pm

#1113370
RE: How to bulk insert rows from text file into a WIDE TABLE which has 1400 columns?

Welsh Corgi (2/3/2010)
Have you tried using a format file with the BCP Utility?
I believe that Welsh's idea above could be one of the simplest and fastest ways. ...
--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)

February 3, 2010 at 6:56 pm

#1113369
RE: Calling a powershell script from TSQL

xp_CmdShell (I believe) but why would you want to do 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)

February 3, 2010 at 6:50 pm

#1113368
RE: Column With Multiple Values

BaldingLoopMan (2/3/2010)
if the model will always be the second value in the delimited list then i would go online and bring down the split function. Which is below
---------------------------------------------------------------------
CREATE FUNCTION dbo.Split
(
@RowData...
--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)

February 3, 2010 at 5:48 pm

#1113360
RE: BCP utility

Shark Energy (2/3/2010)
I'm not 100% sure it will work but copy the files bcp.exe and bcp.rll from the SQL Server\Tools\Binn folder on the db server and place them on your...
--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)

February 3, 2010 at 5:30 pm

#1113357
RE: Paying attention to detail and being thorough.

It's real hard to come up with a more meaningful post on this subject than what the two of you have already so I'll leave my rant about this right...
--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)

February 3, 2010 at 5:27 pm

#1113355
RE: Indexing fields for JOINS and WHERE

Ohhh... be careful. I just went through a similar thing a month ago. Having an index with a leading column having only two possible states will sure speed...
--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)

February 3, 2010 at 5:05 pm

#1113348
RE: Virtual PM's for Jeff...

I still think it would be a great article. Lots of people run into the same problem.
--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)

February 3, 2010 at 4:37 pm

#1113334
RE: Are the posted questions getting worse?

GilaMonster (2/3/2010)
Um....
http://www.sqlservercentral.com/Forums/FindPost858555.aspx
Heh... that one brought back some bad Oracle discussion memories.
--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)

February 3, 2010 at 4:32 pm

#1113330
RE: Are the posted questions getting worse?

Roy Ernest (2/3/2010)
GilaMonster (2/3/2010)
"I am working in a project nearing to its deadline. I am not having enough time/patience to read books now."
http://www.sqlservercentral.com/Forums/Topic856967-1291-1.aspx
Seriously, where are all the idi^H^H^H novice-type people...
--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)

February 3, 2010 at 4:23 pm

#1113324
RE: Are the posted questions getting worse?

Alvin Ramard (2/3/2010)
Jeff Moden (2/2/2010)
GilaMonster (2/2/2010)
Gianluca Sartori (2/2/2010)
On the last one you almost corrected Jeff on the LDFs thing, so I think you have the answer.:-D
I realised what he meant....
--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)

February 3, 2010 at 4:19 pm

#1113322
RE: hourly average

BaldingLoopMan (2/3/2010)
trying to wrap my mind around what u guys did.
first:
DATEDIFF ( datepart , startdate , enddate )
So DATEDIFF(hh,0,UtcTd) = 956142. What is that. The number of hours since when?...
--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)

February 3, 2010 at 4:07 pm

#1113319
RE: XACT_ABORT ON

rburgess (4/29/2009)
That caused a 4 table update to only update some tables and not others and changes did not get rolled back in tables that had already been updated 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)

February 3, 2010 at 6:07 am

#1112791
RE: How to Prevent DBA's from viewing the data

On top of Gail's good suggestion, if you don't want any one person to have the key, then use a dual key external encryption and store each key in 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)

February 3, 2010 at 6:03 am

#1112789

Viewing 15 posts - 39,976 through 39,990 (of 59,098 total)