can you enlighted us dummies as to what ETL is?

Edited by - don1941 on 12/05/2002 8:35:04 PM

when you create a table, the default is "ON PRIMARY" for it unless you specify something else. To direct it to your 2nd file group specify "create table ......

Sounds like a network problem to me. MS stopped getting caught introducing specific network incompatibilities several years ago. Maybe they're getting better at it.

Last note:

We use a prefix usp for user stored proc and SUFFIX identifiers. The IDs are only for dev and do not make it to the production system. ...

Bulk insert is for a flat file. your foxpro file is going to be formatted in its data base format and not in a usable format that BI can...

quote:

---

I have a structure which exactly matches the DB row, so if I am able to get the raw data directly I...

tempdb is just like any other data base except it is used by the system for work space. you can use the INFORMATION_SCHEMA views to look at tables and...

Currently UDFs are limited to scalar parameters (ie, your plain vanilla data types). If you want to pass a statement, I would wonder why? Usually you just want...

This is another slight flaw in SQL Server, no "modified" date. You have to rely on discipline to track when changes are made. Personally, I script the data...

quote:

---

Anyone know how to read this format?

---

I just posted Pack() and Unpack() user-defined functions. ...

I was aware of the SQL 7/6.5 info. Thought there was something new i was missing.

This is typically a client-side function that occurs prior to inserting the value in the data base. if you want a simple one, you can convert all "<" characters...

quote:

---

Think carefully before taking this option. If the script has a runtime error, you won't be able to step over the statement...

quote:

---

ALso, periodically I have seen doing a Truncate leave the value what it was before.

---

I...

quote:

---

I both agree and disagree with this. 6 smaller drives over 3 larger drives is infinately better, but the performance gain would...