Hey Steve, which apps. I'm just curious. I moved to a WP last fall and with one exception, I've found it better than my Droid. The exception is the Swype...

And after working through Gail's excellent articles, I'd suggest getting a copy of my book. The 2012 one will be mostly applicable to 2008R2.

Well, OK then. If it's bytes, what do you want to display? Kilobytes is derived by dividing the number of bytes by 1024 because that's how many bytes makes up...

If you haven't set max memory, then, as has been noted, SQL Server will use all the memory it can. You can set max memory this way. Or, you can...

To restore the database, you'll have to move everything. No options there. You can shrink it after the restore is complete. Or, you can modify the structure prior to the...

Lynn Pettis (5/17/2013)

---

I have had to turn of SQL Prompt here at work as it sometimes fails due...

I've seen issues with filtering on database name in Trace. My suggestion, switch to database id if you can. If not, the better solution, switch to extended events. They are...

Or just turn off intelisense and get a tool that works.

You could simply do the BETWEEN operation in your JOIN criteria within T-SQL, but you're going to have to be careful about your indexing. And, it's not an enforceable join...

And look to the Cost Threshold for Parallelism. Compare that with the costs of the plans themselves. It could be that with different parameters compiled a different times, you're getting...

The one difference there that's pretty likely to be the culprit are the Compute Scalar operators in that last query. That's going to have an effect. It seems a little...

And we have a really good reason to not run backups, to have the database in simple...

Lynn Pettis (5/16/2013)

---

The Dixie Flatline (5/16/2013)

---

Brandie Tarvin (5/16/2013)

---

The Dixie Flatline (5/16/2013)

---

But I only...

I'm wearing a Friday shirt.

dbursey (5/16/2013)

---

Hello, all - thank you for your replies! What a lot of great information and resources! Just to get my feet wet, I tried to copy the database backup...