Florian is correct. SQL Server will release memory to the OS if there is pressure from other applications, but it will not release it on it's own. If you want...

There are lots of blogs and notes as well. I've been trying to blog regularly about what's happening, and I'd encourage you to follow the #sqlpass tag on Twitter. Some...

That's an interesting view. I wonder, though, if it's the message to send. Plenty of people in other professions, doctors, lawyers, engineers, architects, etc. work weekends and long hours. That's...

You'd need to get the datepart for seconds, or strip out the value.

The calculation is then seconds * 1000 for ms.

multiply by 60 for minutes to ms.

What I'd look for is items in Profiler that are either

a) executed a large number of times (group by and count the SQL command/proc call)

b) things that take a long...

Add two columns to the tables, specify default constraints, use a format file with bcp or specify which data from the file goes to which columns.

bcp/BULK INSERT is not a...

I've got an old article on this, but as Silverfox mentioned, it's not a simple thing to do. What have you done, or what do you understand about the process?

http://www.sqlservercentral.com/Forums/Topic1603-32-1.aspx

What I think you'd want to do is calculate the sizes of all rows that you have in the db, for all tables, and give that to the customers as...

Out of curiosity, how much timeout did you set for how many GB of data?

This works well with Tony's DBW editorial on tuning.

The less you write good code, the more DBAs needed.

We will never get away from admins. We might have less / GB...

Excellent points.

I think that you ought to try to tune your code, you ought to go back and refactor it when you can. However deadlines, and time pressures can force...

I'd agree that the foundations were set with the generation before the boomers. The boomers built on their work, but the explosion of computing, the push to cheaper chips, to...

If the package cannot complete all steps, it fails. So that is the mail you are getting. It isn't a "backup" it's a package.

One thing you can do is use...

Jobs run local to the instance, on local time.

I'm not sure what you are asking.

I would make sure you run a DBCC checkdb in msdb.