Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,581 through 47,595 (of 59,099 total)

RE: Updating Values Without Cursor

Garadin (10/25/2008)
rbarryyoung (10/25/2008)
Jeff Moden (10/25/2008)
Parul Sharma (10/24/2008)
I can tell you the answer to that... Seth's will handle a million rows in less than 7 seconds... the others that use a...
--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 26, 2008 at 7:22 pm

#889808
RE: Absolutely (Not?)

Ross McMicken (10/26/2008)
We have a couple of places where we have to use cursors to generate interface files that are sent to legacy mainframe apps. Not an ideal situation, but...
--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 26, 2008 at 7:17 pm

#889807
RE: 'N' number of usage - Tally Table

Absolutely no comment on that stupidity.
--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 26, 2008 at 7:13 pm

#889805
RE: DATEADD FUNCTION WITH TALLY TABLE GIVE OVERFLOW ERROR WITH MONTH

Bottome line is, don't do calculations on t.N in the WHERE clause or all of the Tally table must be evaluated... as I saw previously suggested, this works the best...
--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 26, 2008 at 10:28 am

#889758
RE: Correlated Query

Jim Nesbitt (10/24/2008)
A correlated subquery is the way to go. They can be very useful.
select
ID
, ProjectPeriodID
, ItemisedGrantID
, Amount
, ISNULL (
(
-- This does the correlated sub query
SELECT sum (amount)
from ProjectPeriod...
--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:08 pm

#889708
RE: How do I create a conditional counter?

Um... this is actually a cross post with a different name. The bad part about cross posting is that it split resources, the unsuing discussions, and the answers. ...
--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:56 pm

#889705
RE: Stored Procedure to query many tables

Don'cha just love the feedback on some of these posts? 😛
--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:47 pm

#889703
RE: What does 2 periods after DB name mean?

rbarryyoung (10/14/2008)
That just means that the default schema (dbo) should be used. In other words:Customers..FirstName is the same thing as Customers.dbo.FirstName
Not the same for performance, though... 😉
--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 pm

#889702
RE: how to save a blob to harddisk?

Heh... Ice Cream Scoop... :hehe:
--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:37 pm

#889701
RE: Performance Tuning ...

A query is said to be a good query... until someone finds a way for it to run faster. 😀
In truth, if the query contains RBAR of any sort, it's...
--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:34 pm

#889700
RE: help with leap year

Heh... you can do it a bit easier than that... not sure it's even worth putting in a function...
[font="Courier New"]DECLARE @Year INT
SET @Year = 2007
SELECT ISDATE(STR(@Year)+'0229')[/font]
--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:14 pm

#889699
RE: small query help me out

Chris (10/22/2008)
THKZ SIMMONS IT WORKED ...
Really? Try these and see what happens... 😉
SELECT ISNUMERIC('3D2'), ISNUMERIC('3E2'), ISNUMERIC('1,000'), ISNUMERIC(CHAR(13)), ISNUMERIC(CHAR(9))
One way to beat this is...
SELECT ISNUMERIC('3D2'+'.d0'), ISNUMERIC('3E2'+'.d0'), ISNUMERIC('1,000'+'.d0'), ISNUMERIC(CHAR(13)+'.d0'), ISNUMERIC(CHAR(9)+'.d0')
--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 6:56 pm

#889698
RE: help with datediff and datepart in sql express

webconcepts (10/25/2008)
Thanks, by the way count again LOL first 5 inserts are for the month of 09.......:D
My fault... didn't copy the first line.
--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 6:24 pm

#889697
RE: Extracting pieces of a string...

yisaaacs (10/24/2008)
I have a log table, that contains a Detail column which looks like this...
auth=2 ms,xslt=110 ms,wallet=531 ms,resp=136 ms,total=0.823 sec,meta-data=3 ms
i need to extract each integer with the corresponding name,...
--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 5:56 pm

#889696
RE: T-SQL Development Standards

Heh... I don't know why people even bother with any standards at all. As soon as something needs to "go in in a hurry", all notions of standards and...
--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 5:29 pm

#889692

Viewing 15 posts - 47,581 through 47,595 (of 59,099 total)