Wayne West (3/30/2015)

---

I see a fundamental problem here, and that is the size of the organization. I've never worked in a large enough shop to have more than one...

Ditto.

BTW,...

One other thing, perhaps you can do a simple "switch" for your table. Rename your table before print jobs are generated and recreate a new, blank one. Then you can...

Concur with Grant's explanation.

Here's what I'd look at. Do you create an hour's worth of data every day? Or any day, maybe is a better question? Could you schedule the...

I haven't done this specifically. Only 2005-> 2008 and R2, so bear that in mind.

There is an upgrade advisor you can run from 2014, which will tell you potential issues...

And I didn't respond last weekend because I bought this:

Late to the gender bias thing as I've been skiing all week. Not to open wounds, but I liked this: http://www.sqlservercentral.com/blogs/databases-infrastructure-security/2015/03/18/women-in-technology/

Are you looking to load a single 5GB file into a single table?

There are a variety of ways to do this. Is there a transform? Is it a straight load?...

The lock is caused by a process needing to update, and requiring these locks. However because there are existing locks (shared or exclusive) on the pages/table, you get the intent...

There is no licensing restriction in SQL Server. Just install with the same key.

However, if you are audited and have two running with the same key, you are seen as...

TomThomson (3/27/2015)

---

I'm a bit surprised that the editorial seems to suggest that separating database and app releases is something new, because in fact it's something that has been around and...

Eric M Russell (3/27/2015)

---

Steve Jones - SSC Editor (3/27/2015)

---

Eric JOATMON (3/27/2015)

---

Steve,

You mention "extra columns in a result set" as being a downside to deploying database changes prior to application code...

My own answer is that I tend to just use SSMS because it does what I need. I'll use VS for .NET stuff, but otherwise SSMS only. I've rarely opened...

chrisn-585491 (3/25/2015)

---

Plus F# isn't a wallflower. F# is the best of the functional first languages. If you are a serious developer and not just a CRUD developer, F# is a...

These...