Indexes are built using extents (allocations of pages ) in the db file. As the index is built, it gets new pages from the file that are not necessarily contiguous,...

Note that you would take the output of Lowell's script and execute it in SSMS as a query to alter all tables.

The idea is that you are using code to...

We've done a variety of things here. Bike rides or hikes usually go over well with the kids in Colorado.

Movie night, video game times, those are fun. We've gotten Rock...

The typo is corrected and I will award back points for those that might have mistakenly picked up on that.

I know that some of these people are annoying, but let's try not to pile on too much. Just post that you expect them to do some work, or something...

The presentation talks about people writing "=null" not "is null", and gives the latter as the proper way to test for NULL.

Multi-row triggers are something that people commonly do not...

You run this as T-SQL

http://technet.microsoft.com/en-us/library/ms188787.aspx

I'll try to make it. Not sure about the timing

Express does not allow remote connections by default. Use sp_configure to change this

sp_configure 'remote access', 1

RECONFIGURE

BOL: http://msdn.microsoft.com/en-us/library/ms174269.aspx

How do you do the import?

If you use BULK INSERT, http://msdn.microsoft.com/en-us/library/ms188365.aspx, there's a batch size parameter, which will load xx rows in a transaction and then commit.

There are similar things...

Replication can have delays, and it's not a scale out solution. It can mimic it if the loads are not too high, but there's no guarantee that one node will...

Setup will handle this for you.

Measure the usage of various instances, keeping in mind CPU and disk. RAM is hard since they tend to use all memory, but look at #s of connections and transactions...

Martyn Hughes (10/19/2010)

---

My comment is not meant to be 'snarky', I'm always troubled when I have to fight within an organization to get useful tools. Pervasive does cost several thousand...