Let's try two things. First, qualify all the column names. You've created aliases, at, am, put those in front of the columns where appropriate so that all the columns are...

Oh no, this is absolutely not the place for a trigger. The right answer is to make those columns not null. That will raise an error and that error can...

WayneS (1/5/2015)

---

Grant Fritchey (1/4/2015)

---

Lynn Pettis (1/3/2015)

---

Jeff Moden (1/3/2015)

---

It's only the 3rd of the year and I believe we already have a candidate for the year's most vague question.

http://www.sqlservercentral.com/Forums/Topic1648047-2799-1.aspx

Anyone...

Oh noes. Not again.

Ha!

Another thing to check are the ANSI settings for the connections. Maybe one set of machines is different than the others. That can lead to differences in execution plans and...

If it's only a few tables, you could try just using a MERGE query to make it so that the data is moved across based on what's new, deleted or...

The process is outlined pretty clearly here in the Books Online. You need to create a TYPE the defines the table structure and then you can set the parameter for...

Books Online is always the place to start when learning about anything in SQL Server. When you're ready for the details, I can't recommend Denny Cherry's book on security strongly...

I think everyone else largely has it covered between data types and the possibility of encryption, you may see little to no compression.

IncidentalProgrammer (1/5/2015)

---

Grant Fritchey (12/30/2014)

---

IncidentalProgrammer (12/29/2014)

---

Fortunately, I won't have to worry about doing the backups in SQL, myself. Corporate backs everything up automatically on a daily basis, and I'm told that...

To my knowledge, no, you can't do this. The instance is exposed as a single IP, especially across the cluster. I've never seen anyone set up different IP addresses for...

Here's the entry in the Books Online for DROP STATISTICS.

I strongly recommend just keeping a link to the Books Online. That's where you'll need to go for most of your...

IncidentalProgrammer (1/5/2015)

---

GilaMonster (12/30/2014)

---

IncidentalProgrammer (12/29/2014)

---

Fortunately, I won't have to worry about doing the backups in SQL, myself. Corporate backs everything up automatically on a daily basis, and I'm told that to...

Ha! No, no thanks.

I'm sure your install can be saved. I have yet to see one that couldn't be cleaned up in some fashion. You just have to work...

You can set up SQL Server on a different machine (hosted or not). In order to use it for your development, you just need to make sure you set up...