Jeff Moden

Forum Replies Created

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

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
RE: Mining for Experts

Heh... I learned a great East Indian word for the techniques used to find experts... ready? "Booils**t".
I'm currently 4 for 4... That is, I've worked with 4...
--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 6:56 pm

#988489
RE: Quarterly Executive Reports

tdunbar (5/4/2009)
I have a request from my manager to produce quarterly reports. There was not a lot of specific when I asked about expectations or purpose of the report.
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)

May 4, 2009 at 6:33 pm

#988485
RE: I've tried this on 2 other forums, does anyone know the answer?

Steve Jones - Editor (5/4/2009)
I'd still vote for 13 separate databases, and turn Barry's comment around. It's harder than one database, but not 13x harder. Just a little harder.
Heh... and...
--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 6:28 pm

#988484
RE: Using Functions or Stored Procedures or Views or ????

Like Grant said... "Just to pile it on"...
I agree with what the others have said. While the use of UDF's can make for some very RAD (Rapid Application Development)...
--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 6:25 pm

#988483

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