You'll have to provide more details on what you are trying to achieve. A cross join is a product of all possibilities. If that's what you need, that's what...

Robert Sterbal-482516 (12/19/2014)

---

I think my evenings are limited to once a week for all practical purposes for the foreseeable future. What is the second best way to get out there...

Gary Varga (12/19/2014)

---

For sure. This is mostly my plan, though I lose 10-12 a year for events....

Nope, and Happy New Year to you

No real danger. Some things take effect immediately in the patch, some don't until reboot. However no issue as long as (mentioned above) it isn't a patch that tries to...

Watch datetime v datetime2 for things as well.

They should be dropped if they're not system tables. Perhaps you have an application connecting or you are running some queries? SQL Agent?

How are you checking for temp tables? Also,...

BrainDonor (12/24/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now. My question is when...

Haven't specifically upgraded to 2014 for SSRS, but the data sources should work fine. The connections from applications are the same (OLEDB/ADO.NET/etc) and those work fine from 2005->2014

Upgrade SSRS to ...?

Do you mean you have SSRS only on the 2008 instance? Or are you looking to update all instances? Is this a separate 2008 instance, but connects...

Ahh, sorry. Fixed it

File operations are cumbersome in T-SQL. There aren't really extensions to do it well. Powershell works really well, and you can schedule these in SQL Agent.

Lynn Pettis (12/27/2014)

---

I am not actually complaining...

Apologies. Points have been awarded back.

This was a snippet from the stored procedure, so I didn't think about the output variable when looking at it.

Rory and Keith,

Congrats and PM the email you'd like to use for your prizes. I'll shoot them out ASAP.