Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,891 through 43,905 (of 59,101 total)

RE: Give me a strong Solution?

Oh... and my definition of "Performance Tuning" is one of two things... either writing code to let the optimizer do its job, or rewriting someone else's code to let 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)

May 4, 2009 at 11:04 pm

#988551
RE: Give me a strong Solution?

The basic idea is to allow the optimizer to do it's job using properly written set based code. You do that by avoiding cursors and while loops in 99.99%...
--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)

May 4, 2009 at 11:02 pm

#988549
RE: Filtered index with IS NULL predicate

GilaMonster (5/4/2009)
No, it is covering and the optimiser should, theoretically, be picking it. Might be a bug, might be something subtle that we've missed.
I'm not sure how creating a filtered...
--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)

May 4, 2009 at 10:23 pm

#988536
RE: Do You Need an IT or CS Degree to be a Successful DBA?

I'd like to know why anyone cares? Either the DBA is doing (or can do) a good job or not. When I conduct an interview for a potential...
--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)

May 4, 2009 at 10:07 pm

#988535
RE: "tempdb" size -- 550GB!

Barkingdog (5/4/2009)
Jeff,
I agree with what you wrote:
>>
You need to reset TempDB to a reasonable size and setup a trace for TempDB growth to help isolate the code that's causing 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)

May 4, 2009 at 9:42 pm

#988531
RE: Double quotations in Bulk insert - csv file

Clark Bones (5/4/2009)
Hello!
I have a simple csv-file that I want to import into a table. I have some code and the file is imported, but the columns in 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)

May 4, 2009 at 8:42 pm

#988515
RE: snapshot isolation understanding.

Drop the following into the URL field of BOL for how to implement it. It has nothing to do with the app...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/035b3297-6f89-4043-9ba0-76108781b827.htm
--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)

May 4, 2009 at 8:32 pm

#988514
RE: "tempdb" size -- 550GB!

Barkingdog (5/4/2009)
We use a 3rd party ETL tool instead of SSIS (not my choice). I put a "cap" on tempdb growth at 450GB and the weekend ETL job failed....
--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)

May 4, 2009 at 8:28 pm

#988513
RE: Error string: Class not registered

We get the exact same error on one of our servers. I've not figured out what is causing it, yet... but, it doesn't seem to bother either replicaton nor...
--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)

May 4, 2009 at 8:23 pm

#988512
RE: Improving data import performance - More RAM ?

ifila (5/4/2009)
Yes that is the number of files.
Each file SIZE is between 30k and 35k.
The complete text documents are stored in one table, but the parsed information extracted from 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)

May 4, 2009 at 8:20 pm

#988511
RE: Give me a strong Solution?

Everyone say it with me... G-O-O-G-L-E 😉
http://www.google.com/search?hl=en&q=what+is+performance+tuning+sql+server&btnG=Google+Search&aq=f&oq=
On a different note, I would also recommend Grant's book.
--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)

May 4, 2009 at 8:02 pm

#988507
RE: datetime conversion error

Mh (5/4/2009)
Sorry my bad, I know why I was getting the error:
multi-part identifier could not be bound.
Thanks!
Two way street, please... tell us what you found! 😉
--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)

May 4, 2009 at 7:57 pm

#988505
RE: finding old/inactive databases

Heh... if you want to play the part of a BSOFH, take the databases offline one at a time and wait for someone to sqawk. 😛
--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)

May 4, 2009 at 7:55 pm

#988504
RE: Disaster Recovery Strategy for VLDB

As a side bar, considering things like hurricane Katrina and other major disasters, I'm thinking that <100 miles isn't enough especially in coastal regions and earth quake prone areas.
Shifting 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)

May 4, 2009 at 7:39 pm

#988501
RE: Queries running slower in SQL 2008 than in SQL 2000

Frank Carrelli (5/4/2009)
I found my issue that was causing my slow running queries. It appears the Coalesce statements...
How serendipitous... I've recently made that same discovery with doing things like concatenation...
--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)

May 4, 2009 at 7:08 pm

#988493

Viewing 15 posts - 43,891 through 43,905 (of 59,101 total)