Thanks. We have someone looking at this as we did see some spam issues.

GilaMonster (2/22/2016)

---

Bandwidth. Latency.

My current...

TheFault (2/22/2016)

---

Gary Varga (2/22/2016)

---

Given that there are even cloud sandboxes for most things now it does beg the question why anyone would not use cloud hosts. There are issues that...

Grumpy DBA (2/22/2016)

---

Thanks to Steve (and those who agreed with him) on the book suggestion Ready Player One, I took it to Canyons-Park City and read it on the plane...

First, expensive. I've looked at them quite a bit. They...

If the users don't have rights, meaning a user mapped, in those databases, they can't do anything. You cannot hide these in SSMS, so you need to be sure there...

Triggers can move data, perform an insert/update/delete when there is an insert, update, delete operation on a table. The advantage of a trigger is it is always run when data...

I agree with Orlando. An i5 runs fine. My laptop has been an i5, 16GB for the last year, and I run virtual machines with multiple instances of SQL ...

I agree with Jeff in that the exam doesn't cover real world examples. If you want to see how a particular feature might be used in the real world, search...

There are liscencing guides available for each edition:

2008: http://download.microsoft.com/download/6/f/8/6f84a9fe-1e5c-44cc-87bb-c236bfcba4df/sqlserver2008_licensingguide.pdf

2012: above

2014: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwjLqfmuh4rLAhUGWCYKHRKpABMQFggiMAE&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F5%2F6%2FE%2F56E49A78-442B-4945-8CF6-D0352F84C62A%2FSQL_Server_2014_Licensing_Datasheet.pdf&usg=AFQjCNHS28wq6hJZz1r257JkjXb1ri4JoA

How are you licensed now? If you are licensed per processor, you need to license all processors on both servers....

If you have a filestream container in this database, you might need to look at using a WITH MOVE here. I don't have a 2008 instance, but you potentially must...

Sent a note off to see if we can track down the issues.

Eric M Russell (2/18/2016)

---

Yes, that's my point exactly: what tool can compare scripts in VSC versus deployed in production? To pull that off developers would have to follow a regid...

It isn't clear what you mean. This is best described with some code to show what you mean by move.

If you mean you have a timer in your application that...

A RAM disk isn't any different from another disk to SQL Server. If you can't add space to the files on that disk, either you have no space, a quota...