Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,296 through 32,310 (of 59,099 total)

RE: Typical DBA day...

Amanda Bates-348384 (10/12/2011)
I'm wondering how other DBA team leads use their time.
I recently got a new manager, and had one of many, many meetings with him. We were discussing...
--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 13, 2011 at 7:55 pm

#1394422
RE: Update Cost Query --Need Your Help

Like this...
UPDATE inv2
SET Cost = inv1.Cost
FROM dbo.Inventory inv1
INNER JOIN dbo.Inventory inv2
ON inv2.Part_ID = inv1.Part_ID
...
--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 13, 2011 at 7:37 pm

#1394419
RE: How to retrieve varbinary(max) using sqlcmd.exe and T-SQL

I believe you need to include the "RAW" option in order to keep from generating the "stray" charcters which are typically used to identify the file type internally to 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 13, 2011 at 7:29 pm

#1394416
RE: I cringe every time I see a recommendation for xp_cmdshell.

Needless to say, I prefer the "all in one place" aspect. MS took the time to write a "suite" of CLR's to implement the HierarchyID... I'd love it 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)

October 13, 2011 at 7:10 pm

#1394412
RE: convert date in sql

daveriya (10/13/2011)
i am getting this error : [Microsoft][SQL Native Client][SQL Server]Conversion failed when converting datetime from character string.
i place 'set @Account_date = convert(datetime,'yyyy-mm-ddThh:mm:ss.mmm',126)'
The datetime format you've selected is 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)

October 13, 2011 at 6:56 pm

#1394411
RE: using While loop in place of cursors

I agree... I don't currently know of a method to send emails using an "effictive" set-based method. Sure, there are set-based methods to generate other code in a set-based...
--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 13, 2011 at 10:12 am

#1394195
RE: I cringe every time I see a recommendation for xp_cmdshell.

On the "poll" section of this thread, I see that 9 people voted as "[font="Arial Black"]Yes, but I can give you a good example of when you HAVE to use...
--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 13, 2011 at 9:58 am

#1394178
RE: I cringe every time I see a recommendation for xp_cmdshell.

opc.three (10/12/2011)
Think third-party web service. A company that offers a value-add service to enrich data that does not reside locally, i.e. data not reachable via standard T-SQL methods.
Actually, that's 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)

October 13, 2011 at 9:17 am

#1394132
RE: Are the posted questions getting worse?

L' Eomot Inversé (10/13/2011)
SQLRNNR (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best...
--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 13, 2011 at 8:51 am

#1394103
RE: Are the posted questions getting worse?

Roy Ernest (10/12/2011)
Today I am taking it easy. I did not go for the Marketing talk of MS regarding SQL server 2012. I had a great time yesterday and day...
--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 12, 2011 at 10:19 am

#1393584
RE: Are the posted questions getting worse?

bitbucket-25253 (10/12/2011)
WayneS
I'm very fortunate to know Jeff, and I'm honored to consider him a friend. He has taught, and continues to teach all of us many things. And not just...
--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 12, 2011 at 10:13 am

#1393578
RE: Sorting: Letters before numbers

SQLRNNR (10/11/2011)
Try this
SELECT MerchantID
from #tempSort
ORDER BY LEFT(merchantID,8) DESC,CASE WHEN ISNUMERIC(REVERSE(right(REVERSE(right(merchantid,LEN(MerchantID)-8)),3))) = 1 THEN 1 ELSE 0 end
Oh... be careful, Jason. REVERSE is terribly expensive compared to other methods especially...
--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 12, 2011 at 1:31 am

#1393262
RE: I cringe every time I see a recommendation for xp_cmdshell.

opc.three (10/11/2011)
The peeve here is when people looking for answers on a forum are blindly fed "just use xp_cmdshell" with no eye towards how to implement it securely...
Now, THAT, 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 12, 2011 at 1:24 am

#1393261
RE: I cringe every time I see a recommendation for xp_cmdshell.

Nope... my comment wasn't directed specifically at you, Orlando. If it was, I'd have said, "Orlando, stop....". 😉
I do have a question for you though... why would you want...
--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 10, 2011 at 5:05 pm

#1392632
RE: Tricky Query

Performace Guard (Shehap) (10/9/2011)
You are right Jeif, i have missed one business case, ...
Heh... I have 4 letters in my name and you did me the dishonor of mispelling it....
--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 10, 2011 at 5:21 am

#1392334

Viewing 15 posts - 32,296 through 32,310 (of 59,099 total)