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...

LIKE queries are not useful in FULLTEXT indexes. You'd need queries to use CONTAINS or FREETEXT in the WHERE clause.

Best practice is to monitor space and add space before it is needed. Adding space can interfere with your workload and slow the server down. You also get fragmented files....

BWFC (2/18/2016)

---

To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version but many people testing that,...

thisisfutile (2/17/2016)

---

I've been tempted to rely, 100%, on the "I forgot my password" links on more critical sites. They all send an email (and I have a very secure...

djj's solution works, whether you have more or less:

DECLARE @a VARCHAR(100)

SELECT @a = 'aaa'

SELECT LEFT(@a, 50)

SELECT @a = 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

SELECT LEFT(@a, 50)

However, if you truncate data, make sure clients know there...