Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,641 through 44,655 (of 59,101 total)

RE: SQL Server 2005 Paging – The Holy Grail

Jeff Moden (3/12/2009)
C. Westra (3/12/2009)
I'm afraid differences in resources are partly induced by Sql Server caching (intermediate) results between the first and latter queries.
If you use DBCC DROPCLEANBUFFERS between 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)

March 12, 2009 at 9:26 pm

#958894
RE: SQL Server 2005 Paging – The Holy Grail

C. Westra (3/12/2009)
I'm afraid differences in resources are partly induced by Sql Server caching (intermediate) results between the first and latter queries.
If you use DBCC DROPCLEANBUFFERS between the queries, caches...
--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 12, 2009 at 9:10 pm

#958891
RE: SP naming convention policy

Sorry... almost for got...
select @name where @name like ''_\_[a-z][a-z][a-z]\_%'' ESCAPE '\'
The code above is one way to use underscores as both a single character wild card and a "literal". ...
--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 12, 2009 at 9:07 pm

#958890
RE: SP naming convention policy

dallas13 (3/12/2009)
well i agree but irrespective of all tht we r going to create new system , we are building it from scratch..
Now so far i m using NAme facet...
Where...
--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 12, 2009 at 9:01 pm

#958888
RE: Can I make this any faster

chrisau168 (3/12/2009)
hey mate
what's authority
rules were made so you know what you are breaking
and you are only breaking them "only" when you get caught
BWAA-HAA!!! Now THAT's ironic... THAT's probably...
--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 12, 2009 at 8:06 pm

#958881
RE: Get Month Name

karthikeyan (3/12/2009)
A little modification in Jeff's code.
SELECT DateName(mm,DATEADD(mm,MonthNumber,-1))
Yep... good call.
--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 12, 2009 at 6:55 pm

#958866
RE: split date and time from datetime

dmoldovan (3/12/2009)
Try also:
CONVERT(CHAR(8), GETDATE(), 114)
CONVERT(CHAR(8), GETDATE(), 108)
No... not for the application the OP is going to use and almost never for everything else because both methods are slow due 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 12, 2009 at 6:50 pm

#958865
RE: how can i convert this date'200702071630+1100' in datetime or in string '20070207'

karthikeyan (3/11/2009)
Can you explain it how it is internally trated by sqlserver? how it is opearting internally? how the memory structure will differ for each function?
if you see REVERSE() 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 12, 2009 at 12:30 am

#958091
RE: SQL Server 2005 Paging – The Holy Grail

First of all... very well written article. Nice to see examples like that with some performance stats. Unfortunately, the most important performance for the user (duration) wasn't measured...
--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 12, 2009 at 12:18 am

#958087
RE: Get Month Name

You bet... thanks for the feedback.
--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 11, 2009 at 9:33 pm

#958058
RE: Can I make this any faster

Bob Hovious (3/11/2009)
Jeff, I understand about pre-aggregating, but why is it so important to do it with a temp table, rather than a derived table? Just so 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 11, 2009 at 9:28 pm

#958056
RE: Transact-sql for changing a telephone number

aram_golbaghi (3/11/2009)
hi
i think gsquare's solution is verywell,
works fine
Yep... right up until you dial a 1 or 3 digit country code instead of +44.
Country codes can be from 1 to 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 11, 2009 at 9:05 pm

#958048
RE: Transact-sql for changing a telephone number

Spikemarks (3/11/2009)
I have tweeked the code and have put it inside a cursor which should read the first 3 chars and then change to which ever it should be.
Once 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 11, 2009 at 8:59 pm

#958046
RE: How do I select a specific entry from a select top nn statement

Heh... close... the next question will likely be "How can I parameterize the TOPs in SQL Server 2000?"
--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 11, 2009 at 8:42 pm

#958039
RE: Straighten me out using "Top 1"

Tony (3/11/2009)
Jeff - he is a beginner, this is his first job out of tech school, and we hired him because we saw his potential for learning. I never...
--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 11, 2009 at 8:11 pm

#958033

Viewing 15 posts - 44,641 through 44,655 (of 59,101 total)