If you are going to 2012, think about FileTable. In some ways the development is easier than Filestream.

The filters for blobs are based on the iFilter standard. You can purchase...

Answer John's question, and then go to BIGINT. I had to do this in a system doing scans of our nodes every hour. We ran out of INTs in about...

If no other processes are running, do you care? You want the server to use the resources it has, not skimp. CHECKDB isn't set to use 10% CPU regardless of...

SQL Server roles won't help here. Row based access means you're using joins to help accomplish this.

A couple links that might help:

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

http://stackoverflow.com/questions/1122513/how-to-implement-database-access-control-on-row-basis

It wasn't fixed until SP2. That's how. Fixed won't be back ported to another fix. That's the reason the next fix comes out.

Mock up something with 10 colums and provide the DDL and some sample data (with inserts) . Show a result set.

We can try to help, but as Sean mentioned, not...

I don't like the idea of blackballing. We all screw up, we all get second chances in different parts of our lives.

I do like disclosure, and the idea of laying...

One more thing to keep in mind, you may have statistics on columns that are not in indexes. Make sure those are being updated. Your plan could potentially skip these...

Good point. Our IT staff used the best advice at the time, which was 1 per core. It's possible that we should reduce down to 4 files.

Sorry, this should be fixed.

In a practical sense, it doesn't matter if it's cat videos or anything else. We still need to manage the data, which means work for us in the data business....

You are welcome. But it's not just me, some of the excitement is...

Yes. I was working with this for a talk and kept editing what I thought was the English file. Eventually I...

Not angry, just asking. From your next question, it didn't appear you had actually looked at SSIS.

We are happy to help, and point you in the right direction, but we're...

Did you look at the link?

The second article talks about imports: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/72493/

When you do the import, you'll need to then separate out the various parts of the data. This isn't...