SQL_Ninja (1/29/2015)

---

Recently, we performed an in-place upgrade of a SQL VM from 2008 to 2012 just to test it out. Everything seems to have gone off without a hitch,...

chrisn-585491 (8/22/2014)

---

A separate QA Team? Wow, that's a luxury where I work.

Development needs to spend some time on databases that reflect real data and large datasets. There's nothing like actual...

david.wright-948385 (8/22/2014)

---

I don't see the point. If production data can be obfuscated while maintaining similar statistical characteristics, and if...

I am for having the right data in the right environment.

Dev databases should have a data set that is representative of Production but smaller. All known scenarios should be covered....

You can deploy a CLR object to SQL Server from Visual Studio as long as you...

Markus (4/14/2014)

---

[quote-0Yes, but aren't those [In-memory] features only available for ENTERPRISE Edition? If so, not many will be able to justify the huge cost for that version of standard...

The In-Memory OLTP and In-Memory Columnstore indexes (for data...

Cody K (4/11/2014)

---

I think you are MEANT to do a full backup, begin a trace to record a day of work, take another backup, and then use replays to compare...

I manage the Business Intelligence server for my company and we just started planning our upgrade to 2014. I expect that all our BI servers except the SharePoint/SSRS stuff will...

Thanks Gail and Jeff!

The experience I was referring to was apparently old and moldy. I think I ran into a problem with subqueries and IN back in SQL 7 or...

All of the solutions to Ash-N's question are really good. I am just not sure Ash-N asked the right question. That would be "What is the best way to fix...

In my experience, IN performance stinks with sets. They work...

Could you define "admin access"?...

Actually a UNIQUEIDENTIFIER (AKA GUID) is a number. The problem farax_x is running into it that a BIGINT is a 64 integer while the UNIQUEIDENTIFIER is 128 bits so trying...

bob.lawson (9/5/2012)

---

I am trying to run the Database engine tuning advisor but when I try and run it I get an error that it has stopped responding.

I have noticed that...