Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,066 through 52,080 (of 59,091 total)

RE: Need to return query result in 0.02 sec

Oooohhh... I just ran into that paging problem... really bad case of parameter sniffing and the traditional methods don't fix it... only full blown dynamic SQL fixes it... lemm see...
--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 6, 2008 at 1:38 pm

#786339
RE: ANYTHING about Performance and System Monitoring

p.s. You friend DOES know what Books Online is, doesn't (s)he??? I figure if you have to ask questions on this forum for him/her, they just might 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 6, 2008 at 1:03 pm

#786323
RE: ANYTHING about Performance and System Monitoring

A week of preparation on this is not enough... but I'd say your best bet is to curl up with Books Online for the next week...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/e9099cce-7f81-4808-8523-587bbcdc1720.htm
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c2eb5f77-2dc1-49b4-bd19-2cdac4c6cae1.htm
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/31529dfe-68e7-49f7-b3c2-39fcecf33a95.htm
... an exam-cram of 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)

March 6, 2008 at 1:00 pm

#786321
RE: The Cost of Function Use In A Where Clause

Just another test... please ignore.
--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 6, 2008 at 11:00 am

#786216
RE: The Cost of Function Use In A Where Clause

Just a test... please ignore...
--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 6, 2008 at 9:12 am

#786091
RE: Using Execute Process Task to run Access (.mdb) ?

Perhaps a permissions change on SQL Server or someone removed a "share" from the target drive... or, maybe the file isn't there anymore... or the machine the file is on...
--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 6, 2008 at 8:01 am

#786000
RE: difference between Sql Server 2005 Integration service architecture and Informatica Architecure.

Shiva,
Try the Microsoft website... I'm sure they have oodles of SSIS propaganda there...
--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 6, 2008 at 7:58 am

#785995
RE: Temporary tables & execution time!!

Ok... was just making sure. You should have no problems with the temp tables.
--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 6, 2008 at 7:54 am

#785989
RE: Problem: Coverting varchar to Datetime

No... you don't need anything that complicated. Looky here...
[font="Courier New"]SELECT CAST('Jan 2008' AS DATETIME)
------------------------------------------------------
2008-01-01 00:00:00.000[/font]
So, the only thing you need to do is change the backslash to 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)

March 6, 2008 at 7:52 am

#785986
RE: How to eliminate KeyLookUp in queryplan

GilaMonster (3/6/2008)
The index with ProductID first produces an index scan because ProductID is not in the where clause.
Ummmm..... heh... What's that highlighted in red????
SELECT
ph.ProductId
,ph.CLientID
, ph.PolicyType
FROM
PolicyHeaders ph
INNER JOIN Products pr
ON...
--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 6, 2008 at 7:40 am

#785978
RE: logic needed for date

Ken... the OP actually wants to know what the algorithym is for the CheckSum function.
--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 6, 2008 at 7:35 am

#785969
RE: Temporary tables & execution time!!

Jacob Luebbers (3/6/2008)
Interesting Jeff - just compared your test query (1m rows) with slightly modified version that CREATEs #MyHead first and INSERTs into it (both running in TempDB). This 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)

March 6, 2008 at 7:34 am

#785968
RE: Temporary tables & execution time!!

Nisha, 2000 rows is nothing. Use Select/Into. Look at my previous post with the test code. Select/Into will load 2000 rows in less than 15 milliseconds. ...
--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 6, 2008 at 7:26 am

#785961
RE: Get Only the File Name

Why would you want to create, compile, register, and attach a CLR to do the same thing that was just done in T-SQL?
--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 6, 2008 at 7:18 am

#785956
RE: conditional operator

I agree.... the Dynamic SQL will frequently perform better because it snuffs any chance of parameter sniffing and forces a recompile so you're always using a good execution plan... For...
--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 6, 2008 at 7:09 am

#785946

Viewing 15 posts - 52,066 through 52,080 (of 59,091 total)