Hey, I resemble that remark

FYI, if you register for the PASS Summit now, it's $995, < $100 a month for your education/networking

Those are kilts, Grant Fritchey and myself.

I'll check this on our list and see how quickly we can enhance it. We have a few other things in process, including some hardware upgrades, but we'll try to...

I completely agree with the compelling reason. Don't add SQL agents because you can. Don't choose compression/encryption, unless you have a valid reason to do so.

snow

Nicole, those are good points, but employers should work with people in situations. There are single men with issues that are the same, and there are other professions (doctors, etc.)...

Good time at PASS, sorry you guys didn't make it.

Bob is in the podcast today (briefly).

Grant, see if someone will post an NDA summary in the newsgroups. Would be nice...

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