Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,611 through 47,625 (of 59,102 total)

RE: convert a varchar(4000) to a int !?

smunson (10/24/2008)
It's good to have a working solution, but the performance of a WHILE loop construct for splitting strings could have problems with performance when dealing with a large number...
--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)

October 25, 2008 at 9:31 am

#889647
RE: Absolutely (Not?)

I guess I'd have to argue that developers are sometimes even more arrogant than the DBA. What makes a GUI developer think (s)he knows something about how to store,...
--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)

October 25, 2008 at 9:17 am

#889645
RE: Need Help with Query

Doing it the old fashioned way using a "Derived table" instead of a CTE...
SELECT orig.AgentID, orig.AgentType
FROM #a orig
INNER JOIN
...
--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)

October 25, 2008 at 8:43 am

#889640
RE: tally to sql

Don't know because we can't see the "Tally Data". There's lot's of ways to "see" file data as if it were a "linked server", but it depends, a lot,...
--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)

October 25, 2008 at 8:27 am

#889639
RE: Pivot table withiught aggregation

Paul,
It would help us give you a better answer quicker if you posted Table A and it's data in a readily "consumable" format. See the link in my signature...
--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)

October 25, 2008 at 8:21 am

#889637
RE: trigger question

Lynn Pettis (10/24/2008)
Well, first of all, I had to fix the code you posted. Both tests ran the same stored procedure. After fixing the code, yes the stored...
--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)

October 25, 2008 at 7:39 am

#889634
RE: trigger question

Crud... I gotta learn to keep everything. I can't find the code that I wanted. I do remember that it's not the same as the following which seems...
--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)

October 24, 2008 at 9:01 pm

#889590
RE: Calculating Work Days

Heh... thanks Fraggle... I guess you really do hate RBAR after 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)

October 24, 2008 at 7:53 pm

#889586
RE: 70-445 Questions and answers

Brandie Tarvin (10/24/2008)
Jeff may disagree with me on this, but here's my take on interviews.
Know your stuff, but if you can't answer the question, be honest about it. Tell 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)

October 24, 2008 at 7:42 pm

#889585
RE: trigger question

Like I said... lemme see if I can find the code I made previously...
--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)

October 24, 2008 at 6:49 pm

#889580
RE: Help with delete command

Dang... you're right... there is an edit on Jerry's post. Thanks for the reminder, Seth. You'd think folks would at least admit to making a correction, but 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)

October 24, 2008 at 6:47 pm

#889579
RE: Forum Etiquette: How to post data/code on a forum to get the best help

Adi, it would be my pleasure! Absolutely ok with me for you to add the link to your signature. If more folks would do that, we might get...
--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)

October 24, 2008 at 6:43 pm

#889577
RE: Calculating Work Days

Hi Jim,
Thanks for the feedback.
It's amazing, to me, how many posts this article elicited... and it was my very first article, to boot! 🙂
As you probably already know,...
--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)

October 24, 2008 at 6:39 pm

#889576
RE: Shrinkfile and log backup

True enough.... but not until you find out [font="Arial Black"]WHY [/font]it grew to 50GB in the first place and fix it. Otherwise, it's just gonna grow again. 1...
--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)

October 24, 2008 at 6:16 pm

#889571
RE: Dangers of using MYSQL...What are they?

:hehe: If you have SQL Server, you don't need CLR's or any of that other stuff with the exception of maybe some RegExReplace. 🙂
--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)

October 24, 2008 at 6:13 pm

#889570

Viewing 15 posts - 47,611 through 47,625 (of 59,102 total)