SQL Server will consume all the memory you allow it to have. That's how it works. You should allow it as much memory as you can on any give server...

Your best bet for something like this would be to use Extended Events. You can capture execution of queries and it has very good filtering so you can just get...

After you make the change that Gail suggests, here's a very large percentage of everything you need to know about In-Memory OLTP. Make sure you read through all the recommendations...

And don't miss out on free opportunities in your area. SQL Saturday Chicago is happening in just a couple of weeks. SQL Saturday Madison was just a couple of weeks...

Tune the query. Tune the data structure. Tune the indexes. Keep the statistics up to date. That's about all I can based on the query running slow and that's all...

They turned them off to speed up a data load but never turned them back on?

I don't know. Pretty much blazing away at their feet though.

Ah, that makes sense. I was following this question because I was curious if it worked differently than my understanding too. Good to know we both have a handle on...

I'm not sure. It's not something I would try to do. What's the purpose of this approach?

You want to do this live against your database? In short, you're building an additional locking and blocking mechanism on top of SQL Server (assuming I understand what you're suggestion)....

Looks pretty good. I like the approach of defining the problem space and then talking about how you'll present solutions to that problem space. I'd say it needs one more...

There's been tons of discussion around this. Coding Horror has an article[/url] about one of the best articles on ORMs, that and all the links are worth a read.

I've worked...

Just looking at pictures of execution plans and not able to see the properties, this is a bit of a guess, but I'd say it's probably bad parameter sniffing.

When you...

I'm not an expert on sp_prepare, but I'm pretty sure you're not supposed to set the value to a particular number, you're supposed to capture that value in the output...

Why try to open it through a SQL query? Why not just use a command line utility like PowerShell or sqlcmd.exe? Either of those can read the file and execute...

Most of the migration projects I've been on take 6-9 months to move stuff over. With that in mind, I usually always suggest going to the latest release because we're...