Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,951 through 31,965 (of 59,099 total)

RE: Starting with "WITH"

What is the code used for the function named "Split", Chris?
--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 17, 2011 at 4:42 pm

#1409632
RE: Missing Last Row of Data

Brandie Tarvin (11/17/2011)
Jeff,
I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File...
--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 17, 2011 at 4:31 pm

#1409626
RE: Split function in SSRS report

kevin_nikolai (11/17/2011)
Hi Komal,
Martins method: DWH.dbo.Split_Values(@Store_Code_List,',') should be used in stored proc's where clause (not in from clause).
Sorry, but no. Martin's method uses a WHILE loop and an mTVF. ...
--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 17, 2011 at 4:29 pm

#1409624
RE: tempdb 35 GB using by query statement- Help

ananda.murugesan (11/14/2011)
Thanks --Mr.Jeff for your valuable reply....
I created clustred index after that it won't help aslo same issues, as you suggested me that is correct after creating clustred index.
Once drop...
--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 16, 2011 at 5:26 am

#1408393
RE: Maximum flow from continuous flow rate

Oh, my apologies... I lost track of this thread. Glad someone posted against it to refresh it in my inbox.
--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 16, 2011 at 5:14 am

#1408380
RE: Error converting data type varchar to numeric- sql 2005

j.miner (11/15/2011)
Nice article Jeff. The function that you wrote determines if it is a integer. If there is decimal data, the regular expression has to be changed. ...
--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 16, 2011 at 5:10 am

#1408376
RE: Missing Last Row of Data

I don't know SSIS but "ragged right" strongly suggests missing columns. You don't have missing columns so turn off "ragged right".
Are you absolutely sure the last row has 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 15, 2011 at 8:30 pm

#1408240
RE: ssis and ssrs interview questions

Koen Verbeeck (11/14/2011)
As soon as you dig a bit deeper they fall rather quickly through their disguise.
How well I know that. 🙂 I just hadn't really thought about how...
--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 14, 2011 at 10:50 pm

#1407618
RE: tempdb 35 GB using by query statement- Help

ananda.murugesan (11/13/2011)
GilaMonster (11/12/2011)
Widen this index: IX_CMTS_IPADD nonclustered located on PRIMARY CMMAC. Add cpip as a second column.
Widen this index: IX_CMTS_IPADD_D nonclustered located on PRIMARY CMMAC. Add CPEIP, CPEMAC
Thanks for reply...
--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 14, 2011 at 10:44 pm

#1407617
RE: Starting with "WITH"

SQL Kiwi (11/13/2011)
Efficiency, it seems to me, comes down to doing the least work possible to return the required results.
Agreed. But then there's that problem of defining efficiency. ...
--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 14, 2011 at 10:37 pm

#1407615
RE: ssis and ssrs interview questions

Phil Parkin (11/12/2011)
Jeff Moden (11/11/2011)
Gosh... I went back and looked at one of the links for SQL Server questions and answers. Part of the reason that I recommend 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)

November 12, 2011 at 9:12 pm

#1406777
RE: tempdb 35 GB using by query statement- Help

ananda.murugesan (11/12/2011)
kindly find the attached Execution plan about that query.
I really sorry for the late replay...
10 Lacks Records Means - 1000000 Rows count.
Please Provide the solution
thanks
ananda
I believe, according 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)

November 12, 2011 at 8:50 pm

#1406776
RE: How to check only the numeric values at the same time ignoring the symbols or characters using SQL queries

Dev (11/11/2011)
mvijaykumar.mca (11/11/2011)
Thanks Peter..
SELECT *
from Metatags WHERE
'|' + MetatagDesc + '|' LIKE '%|2|%'
If the field contains 2|23|4 , and am searching 23, its shud...
--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 12, 2011 at 7:58 pm

#1406774
RE: How to check only the numeric values at the same time ignoring the symbols or characters using SQL queries

{Edit} Never mind... I see that other folks have already brought up the problem of false positives when using LIKE without concatenation of the delimiters.
--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 12, 2011 at 7:44 pm

#1406773
RE: I really cannot think of a good description for this one :)

AndrewSQLDBA (11/12/2011)
That is perfect.
Thank You very much.
As you can see from my UserName, I am more of an Admin and not so much as a Developer. I am learning,...
--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 12, 2011 at 7:40 pm

#1406772

Viewing 15 posts - 31,951 through 31,965 (of 59,099 total)