Yet Another DBA (3/31/2015)

---

Steve Jones - SSC Editor (3/30/2015).... . Developers shouldn't have access to account information or keys that are used in production. There should be separate credentials used...

True, but not everyone starts in a small shop. Plenty of people change jobs, and the more we apprenticed, the more talented people that would move on to other positions.

I...

It's only to let someone easily cut/paste code and exclude the semi-colon.

I do try to provide good code samples with semi-colons in them to help get people in the habit.

Ha, you're jealous because I ignored Detroit.

I agree. I've started to try this:

;

WITH myCTE ...

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