Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,261 through 34,275 (of 59,099 total)

RE: Unpivoting multiple columns.

srilu_bannu (4/15/2011)
hi all,
I want to unpivot multiple columns in my table and i came across this article
http://mangalpardeshi.blogspot.com/2009/04/unpivot-multiple-columns.html
This blog is very nice ,but the problem i have is i don't...
--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)

April 16, 2011 at 8:16 pm

#1312476
RE: hierarchyid traversing the tree.

Inherently, URL's are already a form of hierarchy "ID". Are you sure it's worth using HierarchyID for 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)

April 16, 2011 at 2:17 pm

#1312464
RE: C# CLR performance

opc.three (4/16/2011)
Craig Farrell (4/15/2011)
opc.three (4/15/2011)
Fine...into rabbit hole 🙂 What is your MemToLeave setting on both instances? -g on your startup options.
Awww, OPC, if I didn't know better, I'd say 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)

April 16, 2011 at 2:11 pm

#1312463
RE: Can't find index even though it exists

Laura Schmalzbauer (4/15/2011)
IndexID Name
0NULL
2IX_mms_cs_linkobjectstateattribrefere
3IX_mms_cs_linkrefereobjectattribstate
4IX_mms_cs_linkobject_idis_deleted
5IX_mms_cs_linkobject_idis_renamed
and the index that is giving me issues is index_id = 5
Did you actually rename the index somewhere along the line? That can sometimes...
--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)

April 16, 2011 at 2:06 pm

#1312462
RE: "SET SCIENTIFIC NOTATION OFF"

opc.three (4/15/2011)
I haven't tried them myself but a 64-bit Jet<edit>-alternative</edit> driver was released: http://www.microsoft.com/downloads/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en
Thanks for the link. I'll take a look.
--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)

April 16, 2011 at 1:37 pm

#1312460
RE: Passing multiple parameters using REPLACE function in the query is throwing error.

Jeff Moden (4/12/2011)
I causually looked at your code and it appears to be correct. What is the error that is being thrown?
Looks like the OP either sussed his own...
--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)

April 16, 2011 at 1:11 pm

#1312457
RE: Dynamic SQL and IN Operator

Thanks for posting the splitter code. There are several problems with that splitter code that you may not be aware of.
1. That splitter doesn’t work 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)

April 16, 2011 at 12:13 pm

#1312451
RE: Dynamic SQL and IN Operator

bubs (4/13/2011)
I use a sql function called Split that handles the string so it can be used using the IN operator
As a bit of a sidebar, you should post 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)

April 15, 2011 at 10:11 pm

#1312405
RE: "SET SCIENTIFIC NOTATION OFF"

opc.three (4/15/2011)
I do not think this is related to SQL Server. I suspect it is the Excel driver that is inferring your data types and causing your data to be...
--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)

April 15, 2011 at 10:08 pm

#1312404
RE: Creating Delimited Strings

opc.three (4/15/2011)
Thanks. Sorry if my last set of results were confusing.
...
...
Here are my results after making those changes for two different size sets of test data:
I guess my comment about...
--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)

April 15, 2011 at 8:22 pm

#1312401
RE: Creating Delimited Strings

I guess I'm confused. I see the XLM method beat all but one or two of the CLR's in most groups in your latest test results (which are very...
--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)

April 14, 2011 at 10:10 pm

#1311924
RE: Are the posted questions getting worse?

Brandie Tarvin (4/14/2011)
It's a singular versus plural reference. "There's" = "there is" (singular) while "there are" is a plural reference.
And I'd have committed the worse writting sin of all... ...
--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)

April 14, 2011 at 8:31 am

#1311644
RE: Are the posted questions getting worse?

ALZDBA (4/14/2011)
As I recall an english teacher being very nitpicking on the language being used any other way than the one only to be found in literature that needs to...
--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)

April 14, 2011 at 8:28 am

#1311639
RE: The Job Posting - Do I really have to be the SQL God?

Koen Verbeeck (4/14/2011)
fname lname-1111520 (4/13/2011)
I get it: "then", "than", "there's", "there are". Stop reading (and I did), it can't be coherent.
Oink? You stop reading a technical article...
--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)

April 14, 2011 at 2:40 am

#1311469
RE: The Job Posting - Do I really have to be the SQL God?

fname lname-1111520 (4/14/2011)
Craig Farrell (4/14/2011)
fname lname-1111520 (4/13/2011)
I get it: "then", "than", "there's", "there are". Stop reading (and I did), it can't be coherent.
Huh? Could you specifically...
--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)

April 14, 2011 at 2:23 am

#1311467

Viewing 15 posts - 34,261 through 34,275 (of 59,099 total)