Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,056 through 32,070 (of 59,099 total)

RE: Question about stored procs, xp_cmdshell, and .NET applications

kramaswamy (11/4/2011)
Well unfortunately Lynn, that solution doesn't work - the user still needs access to xp_cmdshell, even if I use EXECUTE AS.
I've looked for other solutions, but it appears 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)

November 4, 2011 at 6:31 pm

#1403553
RE: Select the document name from a column contaning full path and file name

Cadavre (11/4/2011)
Steve Kinnaman (11/4/2011)
Both your suggestions worked! Than You!!
Could you help me with the next issue: I would like the full path in one column AS Path and the document...
--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)

November 4, 2011 at 6:10 pm

#1403550
RE: Better Query

Heh... I've seen people do this sort of thing before... decrypt the columns that are being joined on. Bloody expensive and usually not necessary at all. It's much...
--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)

November 4, 2011 at 5:34 pm

#1403545
RE: Concatenating negative number

quongo79 (11/4/2011)
I have a stored procedure that needs to return the next number in the sequence a particular sequence. The first part of the sequence is a series 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)

November 4, 2011 at 5:14 pm

#1403543
RE: Why is my SELECT query slower when the table is indexed?

Martin Schoombee (11/4/2011)
raotor (11/3/2011)
OK, Here's the query:
SELECTCOUNT(Price)
FROMTempSales
GROUP BY Price
ORDER BY Price;
I'm afraid as I'm so green with this forum you'll have to tell me the best way to attach 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)

November 4, 2011 at 5:08 pm

#1403540
RE: converting to INT from varchar

Cadavre (11/4/2011)
Another method: -
--Standard TestEnvironment of 1,000,000 rows of random-ish data
IF object_id('tempdb..#testEnvironment') IS NOT NULL
BEGIN
DROP TABLE #testEnvironment
END
--1,000,000 Random rows of data
SELECT TOP 1000000 IDENTITY(INT,1,1) AS ID,
RAND(CHECKSUM(NEWID())) * 30000 +...
--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)

November 4, 2011 at 5:03 pm

#1403538
RE: When is a scan cheaper than a seek?

bteraberry (11/3/2011)
I agree with G^2. I would rather error on the side of reducing reads over picking the "fastest" time unless it is really disproportionate.
I'd have to add 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)

November 4, 2011 at 4:28 pm

#1403534
RE: How to get file date using xp_cmdshell?

Naomi N (11/3/2011)
It is not available in SQL 2008. Does anyone have a code for this SP?
I do. This one (it's older and could use a couple of updates)...
--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)

November 4, 2011 at 7:21 am

#1403203
RE: Help with performance - aggregating a lot of data

I just got done with some testing of my theory that having temporal based and persisted calculated columns in the detail would help this problem. Sure, I get 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)

November 2, 2011 at 7:21 am

#1402122
RE: CTEs

Lexa (11/2/2011)
So basically there isn't a situation where CTE will outperform temp table or temp table variable, is that correct?
No. Didn't say that. As with anything else, "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)

November 2, 2011 at 7:12 am

#1402116
RE: How to add columns dynamically,.,..,.,

I'll also tell you this... read the first link in my signature line below and post your data THAT way. You're much more likely to get a coded answer...
--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)

November 1, 2011 at 10:52 pm

#1401971
RE: How to add columns dynamically,.,..,.,

ramanamreddy (11/1/2011)
I don't need any average or sum, I can use it in the query if I want but not in the output,.,.,
Hint: Use MAX for this instead 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)

November 1, 2011 at 10:50 pm

#1401970
RE: Split Comma Separated String to Multiple Columns

Heh... Ron beat me to it while I wasn't looking. 😛
While I'm here, pivoting phone numbers like this is quite contrary to what databases are all about. It might...
--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)

November 1, 2011 at 10:40 pm

#1401969
RE: Split Comma Separated String to Multiple Columns

To do this, you need a "splitter" function and you need to learn how to do dynamic Cross Tabs. Here are two instructional articles that will help on 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)

November 1, 2011 at 10:38 pm

#1401968
RE: CTEs

Lexa (11/1/2011)
Folks,
When are the CTEs used best? Is it true that procs that are called thousands of times a minute and store less than 100K of records are 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)

November 1, 2011 at 10:32 pm

#1401967

Viewing 15 posts - 32,056 through 32,070 (of 59,099 total)