Start with the basics: make sure to spend some time in SQL Express, getting some good indexing going on the tables, so as to "help" whatever views and/or queries you...

The biggest gains you get out of converting would be to move your queries to executing from the server, and not from the local Access instance. If you simply...

Chris Morris (11/26/2008)

---

UNION ALL shouldn't be necessary because none of the rows are duped.

I'll test it for speed tomorrow using a permanent table. A whole minute for returning 30,000...

nishant.sagar (11/26/2008)

---

Thanks for all responses but my problem is that I am creating a script to import data for all tables of the database for extension schema.In that script its...

The message is telling you the fix: you cannot use

Insert MyTable

Select *

.....

You need to explicitly list out the columns you want to insert into. In other words:

Insert...

...and - we're doing it again. By virtue of this thread alone - we're HIGHLIGHTING the "ugly threads" which mean they get more facetime, and (probably) more answers than...

I'm no specialist in 2007, but if you click on the "office" icon (top left corner), you should get a "manage" option, which then gets you to the compact and...

You have to be careful with ident_current, since it

Returns the last identity value generated for a specified table or

view. The last identity value generated can be for any session...

Lynn Pettis (11/25/2008)

---

And I would be careful when looking at natural key as a primary key. What might be unique and unchangeable today may not be so tomorrow as...

Steve Jones - Editor (11/25/2008)

---

You might be better off importing the entire file into a table with one column, one large varchar, and then searching through for this line, if...

Lynn Pettis (11/24/2008)

---

Matt Miller (11/24/2008)

---

There was a very similar thread to this a little while back. You might care to do a search using the SSC google search box...

There was a very similar thread to this a little while back. You might care to do a search using the SSC google search box (top right on most...

I'd tend to agree with smunson. Once you convert the data to SQL Server, you could use something real-time like triggers to allow you to "react" to data changes...

Jack Corbett (11/22/2008)

---

Thanks, but don't forget the the second half...

In addition to the excellent info from Lynn - the biggest thing to see is that in most cases you don't "pick" the index, the query compiler picks the index....