Doh, my bad... misread your comment. To unzip you're going to use:

gzip -d c:\mydir\*

I'm sure there are probably easier ways to do it, but I've used gzip for so...

If you're concerned about this, you might also consider only defragmenting/rebuilding the indexes which need it. Indexes which are very small in size or have little to no fragmentation...

You should just be able to use a command like this:

gzip C:\mydir\*

Should zip everything up.

I used to do something like this using gzip (http://www.gzip.org/). Free, easy to use, good compression and in my experience pretty fast.

My understanding is that schemabinding simply causes any attempts to alter or drop the tables to fail. So I suppose if you were doing an update to the software...

Ninja adds a good point there. Think about the order of both inserts and scans. We had a table which was used for auditing actions from another table....

Boy, that's a question that could start forum wars... 😉

First thing you have to understand is the difference between a clustered and nonclustered index. Clustered indexes define the...

Without blowing too much smoke, you'd be a good addition. Your advice in the forums is pretty much spot-on and I've learned a few things.

Let's see, I have the...

Eh, I'm an author... not eligible. But my friends and I send e-mails to each other in code all the time anyway, so I'm used to this. 😛

And...

To me it looks like you're missing your owner/schema in your update statement... That's the first thing that looks to be missing. Unless your owner is Test1DB, however...

Dang, you guys are all way more clever than I am. Nice work.

Here we go, SQL Server 2005-style:

SELECT content FROM SSC.com

INTERSECT

SELECT content FROM UsefulInfo

(68731155373876 row(s) affected)

😀

I know that as an author I'm technically ineligible but I figured I'd share what I've gotten out of this site.

I'm largely self-taught. I found SSC early in my...

Honestly your best bet really is to have 255 parameters. :blink: You could pass in a single parameter as either a long string or as XML and parse...

I also liked the old format of the 5 newest topics, not necessarily the most recent posts. I was quickly able to see what I was interested in and...

If you can back up the log, you should be able to apply the last full backup and then successive log backups up to the point in time right before...