>= is a comparaison operator. You need to compare something to something else. Which will return true or false. Which is what is then applied as a...

Grant Fritchey (8/12/2011)

---

Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A...

I hope it goes well on monday, but I can say for sure this application is not tuned to my specs.

Try waiting running that query every few weeks to see...

Sounds about right ;-).

Thanks for the feedback.

Anything else?

Where's that darn unsubscribe button? :blink:

Did you try the alter db set single_user option? I would also do with rollback immeditate. Drop it then restore the fresh version.

Warn people that on sunday night or...

Log shipping could be what you need here. But keep in mind that this forces you to be in read-only mode on the test db.

Would that work for you?

easy enough to test.

Take your closest test server, take a full + tail log backup (puts the db into norecovery, recycle the sql server) and see what happens.

Let us know...

Are you reffering to unused indexes or something similar?

This is wrong on so many levels I wouldn't know where to start.

I've heard of a case where a heap had balloned to 15 GB on a table with 190...

You need to also select the invoice id in your derived table. The server doesn't see the base table, it sees what's left after that little statement has run.

The only thing of value I can add here is tha cxpackets is not a problem and not a real wait. It only means that this is running under...

Best one ever.

Got the bumper version of this?

Or maybe 3D cinemax?.

I need to show this to a few "hurried" people in Montréal (who ironically enough...

If you want the current value and not the compile values (or both) , you need to use profiler performance xml plan with statistics profile. Which will containt the...

When you call someone getting a new job a couple days ahead of time you can make fun of this as much as you want...

or now if you preffer ;-).

In...