Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,081 through 40,095 (of 59,072 total)

RE: INSERT INTO and INDEXES

Anam Verma (1/26/2010)
Fraggle-805517 (1/26/2010)
I could be wrong on this, but the issue might not be the indexes, but the statistics. If you statistics start to get out of date,...
--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)

January 26, 2010 at 11:01 pm

#1109108
RE: INSERT INTO and INDEXES

Navnish Sharma (1/26/2010)
As a best practice, you should script out your indexes. Drop them before the load, perform your load and then recreate them. When you talk about millions or...
--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)

January 26, 2010 at 10:57 pm

#1109106
RE: Definitions Help

Like this...
http://tinyurl.com/yd47o3d
--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)

January 26, 2010 at 10:52 pm

#1109104
RE: Definitions Help

My recommendation would be to do a search for a thing called "Books Online". It's the free help system that comes with SQL Server. It contains all 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)

January 26, 2010 at 10:49 pm

#1109102
RE: Insert values from one table to another table

In case anyone is wondering, this is what the post should have looked like. The "normal" forum lettering ate the leading spaces. I was able to recover them...
--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)

January 26, 2010 at 10:47 pm

#1109098
RE: Sql Update table

Considering the DROP statement, I hope the OP doesn't decide to skip the USE TEMPDB statement. 😛
--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)

January 26, 2010 at 10:36 pm

#1109094
RE: A Dearth of Comments

I definitely agree that some prior knowledge is essential when reading another person's comments in code.
However, I've found that a lot of folks either don't comment enough, don't...
--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)

January 26, 2010 at 10:18 pm

#1109083
RE: Ways to run large script files

Ah... got it. Thanks.
Heh... it's odd what someone get's used to... I love to automate "heavy metal ETL". A lot of the work I do involves Call Detail...
--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)

January 26, 2010 at 9:33 pm

#1109065
RE: How to query on acedemic years?

mcommmgr (1/25/2010)
I have a standard datetime field value. I need to write a query that looks aggregating numbers by acedemic year. This acedemic year is defined by August 1st thought...
--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)

January 26, 2010 at 9:06 pm

#1109043
RE: Bulk Data Transfer

p.s. Also, unless you're in the "Simple" Recovery Mode, watch your log file. You may want to do some backups between "steps" in the multi-insert process to keep...
--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)

January 26, 2010 at 8:57 pm

#1109039
RE: Bulk Data Transfer

You can easily create the new target table either manually or by using a SELECT/INTO with a WHERE 1=0 if you're lazy like me.
Since every server has a "tipping point"...
--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)

January 26, 2010 at 8:55 pm

#1109037
RE: sp_who2 and sysprocesses.

I'm not sure what the question is. If you're asking why to ever use the SysProcesses table instead of sp_Who2, it may be because there are a lot 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)

January 26, 2010 at 8:46 pm

#1109035
RE: Do you patch your server with Cumulative Updates even if they are fine?

As many have already suggested, I don't install CU's unless there's a specific problem that needs to be fixed... there just isn't enough time to regression test for every CU...
--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)

January 26, 2010 at 8:35 pm

#1109034
RE: Ways to run large script files

Just curious, Jason. Why would data loads be so different as to require such a large script? 200 MB seems high for such a thing. And, no......
--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)

January 26, 2010 at 8:14 pm

#1109033
RE: File Loading

7-Zip. Has a command line interface, as well.
--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)

January 26, 2010 at 7:58 pm

#1109027

Viewing 15 posts - 40,081 through 40,095 (of 59,072 total)