Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,446 through 47,460 (of 59,095 total)

RE: Checkpoint frequency: is it possible to configure at database level?

Marios Philippopoulos (10/29/2008)
I'm having a performance problem, while migrating a large amount of data from one database to another within the same SQL instance.
The main wait type is - by...
--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)

November 3, 2008 at 9:31 pm

#893404
RE: CLR functions in SQL,Insane or Brilliant?

I believe you've hit upon the only two uses that I'd even think of letting someone write a CLR for. 🙂
The other thing is that, with the exclusion of...
--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)

November 3, 2008 at 9:24 pm

#893399
RE: Query tuning

vkundar (11/3/2008)
Hi,
I have a cursor which fetch around 1000 rows from the table.
This step is fast there is no isue.
Heh.... Bzzzzt! Wrong answer! Deduct 10 points! :P...
--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)

November 3, 2008 at 9:17 pm

#893396
RE: Re: Evaluating logically-equivalent stored procedure performance

jlp3630 (11/3/2008)
What's the best test methodology for comparing the performance of multiple, logically equivalent versions of a stored procedure? Browsing through the internet, it seems that you should use 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)

November 3, 2008 at 9:09 pm

#893395
RE: in clause vs not in clause

bang725 (11/3/2008)
hmmmm...
" Not in " will take more time.
Heh... prove it. Got code? 😉
--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)

November 3, 2008 at 9:05 pm

#893393
RE: Life is Like a Manure Spreader

Heh... I beg to differ, Steve. You did NOT compromise. You simply made it easier for someone else to do the work and, as it turns out, 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)

November 3, 2008 at 9:01 pm

#893392
RE: IF EXISTS vs if @@rowcount

I would suggest you stop looking at costs in either the estimated or actual execution plans because it is frequently very wrong.
For example, given the following test data...
DROP...
--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)

November 3, 2008 at 8:42 pm

#893389
RE: temporary tablesvs derived table

1. I see no difference in the time when measured properly...
--SELECT GETDATE() as Time
--GO
SET STATISTICS TIME ON
CREATE TABLE #Temp_Example (
[CategoryID] INT NOT 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)

November 3, 2008 at 8:21 pm

#893387
RE: StaticvsDynamic queries

clive (11/3/2008)
1. Static query: (Clustered Index Seek cost is 100% - estimated execution plan)
Select * from tblContract_Instal1
where Contract_No = 4669
2. Dynamic query: (Clustered Index Seek cost not shown -...
--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)

November 3, 2008 at 8:08 pm

#893384
RE: Change datatype

Mike Levan (10/31/2008)
I am changing datatype int to varchar(10) whata re the pros and cons, will i lose any data by any chance, what is the gud approach and how.
thanks
Ummm......
--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)

November 3, 2008 at 8:03 pm

#893383
RE: convert string to int in ssis

The "E" indicates either "Engineering Notation" or "Scientific Notation". The "E+11" means "Times 10 to the 11th power". It won't fit into an INTEGER, but it will fit...
--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)

November 3, 2008 at 7:59 pm

#893381
RE: Please need help on looping through the dataset!!!

Awesome to know... thanks for the compliment, Seth. I really appreciate it. Heh... I also appreciate you getting to all of these before me! Makes my life...
--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)

November 3, 2008 at 7:54 pm

#893380
RE: Tune Query

What indexes do you have on the 3 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)

November 3, 2008 at 7:45 pm

#893379
RE: Relationships between views?

Are you saying that you've revoked base table rights from users on a reporting database? If so, give it back!
--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)

November 3, 2008 at 7:25 pm

#893376
RE: Parsed string into a view

Robert,
Take a look at the following article. It explains what a Tally table is, how it works, has a couple of examples including how to split a whole table'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)

November 3, 2008 at 7:22 pm

#893374

Viewing 15 posts - 47,446 through 47,460 (of 59,095 total)