Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,611 through 44,625 (of 59,095 total)

RE: T-Sql rant

foxjazz (3/14/2009)
Not having the ability to use non-cursored rowbased loops is a big downfall.
There is a way to do non-cursored row-based loops in T-SQL... the technique is called "pseudo-cursors"...
--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)

March 14, 2009 at 12:29 pm

#959772
RE: T-Sql rant

foxjazz (3/14/2009)
Ok set this baby... Real world.
I have a table catagory fields are description, catID, typeID. parentID
another tables queryed with (make, model, yr, engine).
in the category table makes are typeid...
--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)

March 14, 2009 at 12:23 pm

#959769
RE: t-sql dates

Just thought I run this past you guys...
On the subject of generating two years of test data... there's no need for RBAR. The following will run in about 3...
--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)

March 14, 2009 at 12:14 pm

#959768
RE: t-sql dates

Rob Fisk (3/13/2009)
OK, so your total cost is 6-8 times faster than mine.
Tally table example would be great. PM me since we have already crowded this topic somewhat.
Thought I'd...
--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)

March 14, 2009 at 11:14 am

#959755
RE: String Manipulation

Goldie Graber (3/13/2009)
I have received a requirement to write a trigger that accepts a string and then performs the following actions.
1.Remove Script tags and contents
2.Replace all HTML tags with spaces.
3.Replace...
--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)

March 14, 2009 at 11:08 am

#959753
RE: time difference computation

thomyes (3/14/2009)
I got the above msg when i tried to run the queries offered as solutions (to my time difference calculation prob. )here .
It simply means that you have data...
--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)

March 14, 2009 at 10:59 am

#959749
RE: slow running query/queries

Such slowness is normally caused by a mistake somewhere in the query... formulas around columns in the WHERE clause will prevent good use of indexes... misunderstanding of the data may...
--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)

March 14, 2009 at 10:49 am

#959741
RE: Recursive Join Problem

Bob Hovious (3/14/2009)
my requirement is that i have get the details about the parentid's along with the recursive data' in a single join
Test question?
I've been taking buisness requirements for years,...
--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)

March 14, 2009 at 10:42 am

#959740
RE: How to import data from multiple CSV files into the same table

Ramesh (3/14/2009)
See this article on Looping, Importing and Archiving files in DTS Packages using ActiveX Script
Just do 3 simple bulk inserts. It's also one of the fastest ways 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)

March 14, 2009 at 10:37 am

#959738
RE: sql_variant

Florian Reischl (3/14/2009)
Hi
I'm using sql_variant alike Jeff stated for logging. I've got a usp_Log like this:
CREATE PROCEDURE dbo.usp_Log
@msg VARCHAR(4000),
@p1 SQL_VARIANT = NULL,
...
--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)

March 14, 2009 at 8:38 am

#959717
RE: Are the posted questions getting worse?

Bob Hovious (3/13/2009)
I tried to take the high road for a change. However, I am ready to buy a round for Sergiy 🙂
Heh... Sergiy... I've learned...
--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)

March 13, 2009 at 11:28 pm

#959631
RE: T-Sql rant

foxjazz (3/13/2009)
Why couldn't they write t-sql more like C# or have a flavored compiler for t-sql so that we could work it like c# or vb depending on how 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)

March 13, 2009 at 11:18 pm

#959630
RE: Are the posted questions getting worse?

Steve Jones - Editor (3/13/2009)
So I got a question in email (it's not just posters, I get them regularly). I have a sig I paste in that replies and says...
--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)

March 13, 2009 at 11:15 pm

#959629
RE: Are the posted questions getting worse?

GilaMonster (3/13/2009)
Am I being too harsh here?
http://www.sqlservercentral.com/Forums/FindPost675279.aspx
Absolutely 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)

March 13, 2009 at 11:13 pm

#959628
RE: Are the posted questions getting worse?

Steve Jones - Editor (3/13/2009)
I'm torn here. I wouldn't be surprised if he got the job since most candidates can't answer those questions. At least not from the stories I...
--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)

March 13, 2009 at 11:00 pm

#959626

Viewing 15 posts - 44,611 through 44,625 (of 59,095 total)