GilaMonster (2/11/2015)

---

below86 (2/11/2015)

---

GilaMonster (2/11/2015)

---

It does not. Nor does...

GilaMonster (2/11/2015)

---

It does not. Nor does the order...

Well, OK then, I'm not sure why I thought it made a difference.

I know when listing the fields in your joins in the same way the index is...

I guess I was just hoping that someone knew this, or has already tested it, without running my on test. Like I said anytime I write SQL I try...

mister.magoo (1/24/2015)

---

...or you can use the Object Explorer Details view to sort the columns.

Just click on the "Columns" node in Object Explorer, then press F7 to open the details view...

I just turn on the line numbers and change some of the coloring, the 'track changes before saving' the default I think is a light yellow, very hard to read,...

Sean Lange (1/21/2015)

---

below86 (1/21/2015)

---

Sean Lange (1/20/2015)

---

Eric M Russell (1/20/2015)

---

I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are...

Sean Lange (1/20/2015)

---

Eric M Russell (1/20/2015)

---

I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used for...

GilaMonster (1/16/2015)

---

Stone age, but it works. I'm there too....

aochss (12/22/2014)

---

GoofyGuy (12/22/2014)

I've been in IT going on 40 years, and I've discovered it's often the 'bad apples' who have the best ideas and insights.

Conformity may bring a sullen peace...

I had a choice out of college of two jobs, pretty much the same benefits/salary for both, except one had a cafeteria and the other barely had a break room....

Beatrix Kiddo (11/21/2014)

---

Some good points here.

I do believe that it's in my own interest to spend few years working harder now while I'm young, have the energy, and my...

GilaMonster (11/20/2014)

---

I've been sitting with negative leave days available since July (about -0.5 at this point). No one in management is complaining, no pointed hints that I need to work...

Results after creating table and database:

checkDatenamedatabase_idcreate_datefile_typedb_file_namedb_file_size

2014-11-19 09:42:22.460db_work1152014-11-19 09:41:46.597ROWSdb_work4096

2014-11-19 09:42:22.460db_work1152014-11-19 09:41:46.597LOGdb_work_log1024

Results after insert into:

checkDatenamedatabase_idcreate_datefile_typedb_file_namedb_file_size

2014-11-19 09:43:58.207db_work1152014-11-19 09:41:46.597ROWSdb_work19456

2014-11-19 09:43:58.207db_work1152014-11-19 09:41:46.597LOGdb_work_log76216

I then deleted the table and database, then recreated them. Ran the SQL...

SQL to create the database and table:

DROP DATABASE db_work

;

CREATE DATABASE db_work

;

USE db_work;

CREATE TABLE target_table

(

pNum CHAR(100),

pMod INT

)

;

The Insert Into statement:

INSERT INTO db_work.dbo.target_table

SELECT pNum,

pMod

FROM source_db.dbo.source_table

;

The log file size check SQL:

SELECTGETDATE() AS...