Lynn,

Best wishes, and I hope it goes well. I'm sure she will appreciate the hardships later.

Ok, double check what you're saying.

It is one physical file split into many physical files? either you have one MDF, which is one file, one file group, or you have...

Jeff, there are a few MI people that do SQL. you ought to get the user group to run a SQL Saturday. The event in Baton Rouge ran smoothly, minimal...

Sarah B (7/31/2009)

---

I am from central Wisconsin, and the closest SQL Saturday event is in Iowa City. They will not pay for the travel, but I am considering paying...

jpowers (7/31/2009)

---

The main reason I don't go is that many are not local. If it is within a 60 mile radius of my home, then I can go. I don't...

Terri (7/31/2009)

---

I will be driving from New Orleans to Baton Rouge tomorrow morning (1.5 hour drive) to attend SQL Server Saturday. I'm happy to have the opportunity for the...

It uses the reserved space automatically.

Let me ask a couple questions. Are you giving us total space or data space? Some people confuse the log with the data, and see...

New code formatting engine available for you SQL gurus.

http://www.sqlservercentral.com/Forums/Topic763966-433-1.aspx

Thanks, Mel.

Give it a try if you can.

Hopefully they are not removing databases regularly. the plans don't modify well, so if this is a regular problem, I'd stop using the "all user databases" and check each database....

software shouldn't break down like hardware does, but it always has defects in it. If we continue to delay fixing software, often we are building on a poor foundation and...

I would bet something else has changed. If you added more memory, you might have people running queries that they didn't run before, or perhaps trying reports that used to...

What do you mean by database size? The size on disk? The data size? The data size + log used size?

We are happy to help, but we also expect you...

You create an SSIS package, add an FTP task to it, then run the package. It's not a standalone task.

First, you have a WHERE clause in both examples. The problem is the inequality, not the WHERE clause. The only way you can determine something is NOT another value is...