I would think it would need to be a two-way street. Microsoft needs to listen to MVPs and others on what's needed, but they also need to disseminate what's...

I put my guess in that thread, since I was already involved...

What I meant by "test the index" was just that. Try creating the index and see what that does.

Obviously, it's not applicable, based on data you've since discovered.

I'll definitely...

Try the index. Temp tables do keep stats, and it can make a HUGE difference.

If that doesn't do what you need, try a join hint. I've only ever...

Simply put, SQL does whatever order works best for it's engine, unless you tell it otherwise explicitly with a final Order By.

So it's not really "random", but it's definitely not...

As far as replacing the code with something more efficient, I'd need to know what the UDFs do and have an actual table structure and some sample data. Given...

You can nest Case statements. You could do this:

CASE

WHEN

CASE

WHEN UseStartDate = 1

THEN CustStartDate

ELSE dbo.GetNewestOrderDate(CustomerID)

END >= dbo.DateOnly(ISNULL(CustStartDate,UseThisDate)) AND DATEDIFF(m, UseThisDate, getdate()) <= 13

THEN 0

WHEN

CASE...

The easiest way to do this is right-click the database name in Management Studio, pick Tasks then Export Data. But that's only good if you just want to do...

I did an online search (Bing in this case) for "data type conversion ssrs", and the first hit was http://msdn.microsoft.com/en-us/library/cc281083.aspx. The second subhead on the page is "Converting Dataset...

You're welcome.

Makes sense. I'd just go with your standard in this case, unless something happens like log file growth causes storage or performance problems.

Nothing in SQL guarantees sequence except the Order By on the final select.

If you really want to force a specific sequence, you have to include that. Otherwise, all kinds...

You'll need to talk to Microsoft about that. I'm pretty sure it's not possible. I could be wrong, but I seriously doubt it.

You can set permissions on schemas if that's what you need.

It sounds more like you should deny the ability to create/modify/drop objects and just put the devs into roles that...

The reason you're having trouble finding data on how recovery models affect tempdb growth is because there's no relationship at all between the two things.

If all you're doing is nightly...