If the statistics were "bad", or insufficiently sampled, why would running the query with the recompile option help?  You'd be making a new query plan with the same bad or...

We've used the Alter Table statement on a fairly busy database a few times to add a column, and have been very pleased with the utter lack of a noticable...

Is there a corresponding way to do this same example using SSMS?

Nice summary Steve.  We're looking to put SP2 into place the first weekend in April (assuming we don't read too much bad press before then!)

XML should be used as a transfer protocol.  I see a use for sending (for example) 7 records at once to a sql server, and letting the Stored Procedure tear...

In the past, we have used the SQL Import wizard to bring Jet tables into a new SQL database (manually).  With express, you don't have that option (as I read...

Let's see:  No import/export capability so you can't simply upsize a Jet app to it.  No SQL Server Agent so you can't run any automated database maintenance task like backups...

Dave, that won't really work.  You'll see the resultant HTML that the ASP or PHP or whatever generated, but you won't see the actual code behind it (unless something is...

For us the "normal, usual" method of accessing our MS SQL Server databases is through plain old Active Server Pages.  But I'll tell you right now, what each company/person uses...

When you can't find out anything, especially pricing, without doing a personal data dump, I lose interest very quickly.

I liked what little I saw, but when will vendors learn that...

There is nothing wrong with the components you're using to access your sql server, we use the same basic setup with hundreds of users.  The time out expired problem is...

It's truncated automatically and ONLY when you run a transaction log backup.   Running a full backup does NOT truncate the transaction log, despite what you might see posted from time...

Don't forget to go into SQL ServerConfiguration manager and make sure the "Listen on" settings under protocols, tcpip, properties reflect the proper IP address(es).  Should be fine for most folks, but...

I agree with most here that the ads on SSC are focused on the expected readers, and placed in a reasonable manner.  I absolutely hate pop-ups and pop-unders.  I don't...

If I understand the question correctly, you're asking if 64 bit and 32 bit versions of SQL server store your data any differently?  No, they don't.  The 64 bit concept...