Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,591 through 37,605 (of 59,098 total)

RE: BCP error

Both Sumit and Mike have some good pointers for getting this working.
--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)

July 20, 2010 at 9:05 pm

#1195911
RE: Average Inventory (Stock) Age

gah (7/20/2010)
Extraordinary..........:w00t:
Running on SQL 2000...7 year old box with 4gb RAM
100K products
20M transaction lines
sub 1 minute !!!!
beats the hell out of the vendor's app (2½hrs)...but that sits on a different...
--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)

July 20, 2010 at 9:01 pm

#1195909
RE: Average Inventory (Stock) Age

steve.vidal (7/20/2010)
I'm a bit late to the party because I was busy yesterday but I wanted to try that "quirky update" thingo, so I had a crack this morning... 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)

July 20, 2010 at 8:57 pm

#1195907
RE: Return value for null rows

Nope... not a DTS package...
Here's 24 hours of 15 minute segments...
SELECT CONVERT(CHAR(5),DATEADD(mi,(t.N-1)*15,0),108)
FROM dbo.Tally t
WHERE t.N BETWEEN 1 AND 96
Of course, for that to 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)

July 20, 2010 at 6:01 pm

#1195893
RE: spliting a varchar(max) into multiples

Paul White NZ (7/20/2010)
Jeff Moden (7/20/2010)
Please see the following "how to" article for a T-SQL only solution...
http://www.sqlservercentral.com/articles/T-SQL/63003/
Yes, that's one of the top articles on the whole site. For some...
--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)

July 20, 2010 at 4:53 pm

#1195878
RE: Parsing QueryString to SQL Table

Thanks for the feedback, RJ. Glad to have been of service.
--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)

July 20, 2010 at 4:52 pm

#1195877
RE: TSQL

palla.sureshbabu (7/20/2010)
Hi ,
i need to create a trigger that needs to be fired on a table when that table is idle for two hours.can anybody help me with...
--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)

July 20, 2010 at 4:51 pm

#1195876
RE: Tempdb growing huge

I agree with Roy. You have to find out what the cause of the growth is before you do anything else.
As a side bar, a 15GB TempDB may not...
--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)

July 20, 2010 at 4:48 pm

#1195875
RE: Rename Table Without Stored Procedure

amrata88 (7/20/2010)
Hi,
1. Using Stored Procedure requires permission .
Only the members of the sysadmin fixed server role, the db_owner fixed database role, or the owner of the object can 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)

July 20, 2010 at 4:32 pm

#1195866
RE: Recursive CTE to replace a cursor problem

I'll tell you that replacing a cursor with a recursive CTE is counter productive and won't buy you much for performance and may actually cost you about 3 times 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)

July 20, 2010 at 4:20 pm

#1195860
RE: spliting a varchar(max) into multiples

Paarthasarathy (7/20/2010)
Hi,
I have a need to split a varchar column into multiple columns based on a delimiter.
Hi have a variable named @a varchar(max)
it contains value similar to below
select @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)

July 20, 2010 at 7:10 am

#1195485
RE: Parsing QueryString to SQL Table

@RJ,
Are you all set on this?
--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)

July 20, 2010 at 5:58 am

#1195437
RE: Using Format File with IDENTITY COLUMN

For starters...
1. "SQL Lat..." is not a valid collation.
2. For field 35 (the ID field you're trying to ignore), there must be a length.
3. If you're using...
--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)

July 19, 2010 at 5:12 pm

#1195225
RE: Function with Select * that references a View

doobya (7/19/2010)
I wrote a tool for this type of dependency refresh problem
it calculates the dependency graph for a group of changing objects
and generates the correct dependency-aware script to refresh 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)

July 19, 2010 at 5:00 pm

#1195222
RE: How do I calculate the week number given a date?

Jeff Moden (7/19/2010)
Eralper (7/19/2010)
Hello,
Easiest solution is using DATEPART function
select DATEPART(WEEK,GETDATE())
If that is not useful for your requirements, you can also think of to create date table in SQL Server
It depends....
--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)

July 19, 2010 at 4:57 pm

#1195220

Viewing 15 posts - 37,591 through 37,605 (of 59,098 total)