Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,216 through 31,230 (of 59,101 total)

RE: Rerunnble update Script

What do you want to make "dynamic" in the script?
--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)

February 10, 2012 at 6:03 pm

#1445844
RE: Dropping Unused indices - User_updates?

Indexes don't have to be used to be valuable. Having, for example, a unique index where that index is never used might tempt you to drop it. 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)

February 10, 2012 at 5:58 pm

#1445842
RE: Reduce DB Size

Admingod (2/10/2012)
Does reducing database size gives any better performance? If yes please explain?
Thanks
Along with all the "It Depends" explanations, I'll just come right out and say, "NO". Performance is...
--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)

February 10, 2012 at 5:39 pm

#1445838
RE: the TSQL code for this query...is needed.

wurkenmomz (2/10/2012)
Also, he states that using the Distinct will not get the recommended results and can be very unreliable, in these cases. He does this for a living.
Perfect. ...
--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)

February 10, 2012 at 5:36 pm

#1445837
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Solomon Rutzky (2/9/2012)
Hi Jeff. Yeah, I kinda realized as I was writing my reply that you could just put the xp_cmdshell calls into Procs and control access via Roles...
--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)

February 10, 2012 at 4:35 pm

#1445825
RE: the TSQL code for this query...is needed.

Eugene Elutin (2/9/2012)
J Livingston SQL (2/9/2012)
I believe the COUNT(*) needs to be COUNT(DISTINCT VendorName) to allow a single vendor to have more than one presence in the city.
absolutely agree...but should...
--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)

February 10, 2012 at 4:07 pm

#1445814
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

rmechaber (2/9/2012)
Jeff Moden (2/8/2012)
Thanks for the feedback, Elliott. I'm more confused than ever though. Paul White built a CLR for me for the "Tally Oh!" article. 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)

February 9, 2012 at 7:38 am

#1445073
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Solomon Rutzky (2/9/2012)
xp_cmdshell is a wide-open hole for anything.
First, thank you very much for the explanation. Your explanation is more along the lines of what I understood.
On 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)

February 9, 2012 at 7:35 am

#1445068
RE: the TSQL code for this query...is needed.

Eugene and wurkenmomz ,
The <> in both of your code creates a "double Triangular Join". If you use that code (making the appropriate substitutions for the different table)...
--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)

February 9, 2012 at 7:23 am

#1445059
RE: the TSQL code for this query...is needed.

J Livingston SQL (2/8/2012)
Hi...seems that from your previous posts that you are currently a student.
...no probs with that, but you will learn a lot faster if you at least provide...
--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)

February 9, 2012 at 7:15 am

#1445049
RE: Hierarchy Query

fahey.jonathan (2/8/2012)
Jeff Moden (2/7/2012)
I'm just curious. What type of hierarchy are you using? Adjacency list, Hierarchical Path, HierarchyID, Nested Sets, cfomposite of 2 or more of those? ...
--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)

February 8, 2012 at 11:29 pm

#1444878
RE: Hierarchy Query

cdh-727733 (2/8/2012)
Jeff Moden (2/7/2012)
fahey.jonathan (2/7/2012)
cdh-727733 (2/7/2012)
I can't do that unfortunately as this is to be driven from user searches which I can't predict.
What I am suggesting is that you create...
--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)

February 8, 2012 at 11:20 pm

#1444875
RE: Help with a query.

xRafo (2/8/2012)
Thanks, i hope this code will get best perfomance than the another (with while statement)
thanks.
It'll blow the doors off the While Loop.
--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)

February 8, 2012 at 11:11 pm

#1444873
RE: Please fix the "Pretty Print" class in the forums and the article "Contribution Center"

Tests for #5 are absolutely spot on for the fix. Great job! That makes life a whole lot easier on this side of the house! I can...
--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)

February 8, 2012 at 11:09 pm

#1444872
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Elliott Whitlow (2/7/2012)
Jeff Moden (4/29/2011)
Elliott Whitlow (4/29/2011)
Oh well.. I released a SQL CLR file function library on codeplex in march 2011. It is at:
http://nclsqlclrfile.codeplex.com/%5B/url%5D
Let me know what you think,...
--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)

February 8, 2012 at 10:54 pm

#1444867

Viewing 15 posts - 31,216 through 31,230 (of 59,101 total)