Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,791 through 35,805 (of 59,099 total)

RE: How do I know when to use temp tables/table variables?

GilaMonster (12/5/2010)
sandippani (12/5/2010)
Have a look to this link :
http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx
However note that the first 'fact' stated in that article is incorrect. Changes to table variables are logged. They don't participate in...
--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)

December 5, 2010 at 3:36 pm

#1258847
RE: Are the posted questions getting worse?

Heh... I found a way around all of the "problems" with WordPress... I write articles on SQL Server instead of blogging. 😛
--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)

December 5, 2010 at 3:22 pm

#1258844
RE: Combining / crunching data?

Brian McGee-355525 (12/4/2010)
Ok this will take some explaining.
If I have a table, columns MYKEY, DT, A, B, C, D, E with the following data:
MYKEY DT ...
--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)

December 4, 2010 at 6:27 pm

#1258792
RE: Speed

Heh... <soap box mode on>
I'll agree that some bloatware has caused problems and that data is growing but I think the real problem is that some really sloppy code has...
--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)

December 4, 2010 at 6:10 pm

#1258791
RE: Huge tables with no appropriate column for creating clustered index !

PaulB-TheOneAndOnly (12/4/2010)
Jeff Moden (12/4/2010)
PaulB-TheOneAndOnly (12/4/2010)
Jeff - I'm not saying you should not use a clustered index, I'm saying you should use it when it brings some value.
I've seen many 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)

December 4, 2010 at 4:59 pm

#1258788
RE: deleting huge records From Table

Ah... never mind. The thing I was looking for is in the link you previously posted and it doesn't do quite what I thought. What I thought was...
--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)

December 4, 2010 at 11:58 am

#1258773
RE: deleting huge records From Table

Paul White NZ (11/23/2010)
David.Poole (11/23/2010)
I thought SWITCH only worked in Enterprise Edition?
One can only create partitioned tables on Enterprise, it's true, but ALTER TABLE...SWITCH works regardless of any partitioning.
All 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)

December 4, 2010 at 11:46 am

#1258770
RE: Delete duplicate records in a table

Sachin Nandanwar (12/3/2010)
Also it is a better idea to put the recover model to SIMPLE or else your log file will bloat.But make sure you take a Full and 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)

December 4, 2010 at 11:25 am

#1258769
RE: Need help building a query.

michaelwelcome (12/1/2010)
you could do a correlated sub query.
select
d1.auID,
d1.Emp_ID,
d1.dt_Start,
(
select top 1
d2.dt_End
from auData d2
where d2.auID > d1.auID
and d2.Emp_ID = d2.Emp_ID
order by d2.auID
) as dt_end
Emp_Cat
)
from auData d1
where d1.dt_Start is not null
This will...
--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)

December 4, 2010 at 10:37 am

#1258762
RE: Index build and parallelism

Heh... thanks for the understanding. I just hate making this type of mistake because I'm usually the first one to ask "Really??? You got proof of that???"
I've bookmarked 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)

December 4, 2010 at 10:33 am

#1258761
RE: Huge tables with no appropriate column for creating clustered index !

PaulB-TheOneAndOnly (12/4/2010)
Jeff - I'm not saying you should not use a clustered index, I'm saying you should use it when it brings some value.
I've seen many tables where an extra...
--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)

December 4, 2010 at 10:29 am

#1258760
RE: CSV Import Problem

SQLSmasher (11/30/2010)
Jeff,
The method i can straight away suggest is to use SSIS.
1. Create in-memory single column table with each csv row as table row
2. find COMMA's between "xxxx,yyyy"
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)

December 4, 2010 at 10:04 am

#1258758
RE: Get Parameter Name

bhuvan.ram (12/1/2010)
Jeff Moden (12/14/2007)
SELECT * FROM INFORMATION_SCHEMA.PARAMETERS WHERE Specific_Name = 'Award_Category_Insert'
Excellent...thanks alot
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)

December 4, 2010 at 9:58 am

#1258757
RE: Beware of Search Argument (SARG) Data Types

I agree with many of the others. This is a "hidden" performance problem that a lot of people don't even consider because they don't know about things like data-type...
--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)

December 4, 2010 at 9:54 am

#1258756
RE: add data separate with a coma in temp table !?

Where in DelimitedSplit8K do you find a physical Tally Table?
--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)

December 3, 2010 at 11:14 pm

#1258728

Viewing 15 posts - 35,791 through 35,805 (of 59,099 total)