Sean Lange (10/12/2011)

---

MysteryJimbo (10/12/2011)

---

Sean Lange (10/12/2011)

I wouldn't argue the rationale for using NOLOCK as a routine hint for queries but I would say that performance IS the reason your shop...

CheeseheadDBA (10/12/2011)

---

Using dynamic sql is the way to go. Here's an example code snippet:

SELECT @sqlCMD = 'USE [' + @databaseNm + '];

INSERT INTO #tmpOrphanUsers (dropCmdTxt, Completed)

SELECT '+''''+ 'USE...

Rob-350472 (10/12/2011)

---

To be honest in the first instance I was making sure that Developer edition would actually do what I wanted, that was the aim of the post really!

It sounds...

Look... The reality here is that this is small potatoes compared to what the BSA or Microsoft is looking for. IF and I mean a big IF Microsoft suspected a...

MysteryJimbo (10/12/2011)

---

Ninja's_RGR'us (10/12/2011)

---

I've yet to see a single client trade data quality for a little extra performance (never had a lot with correct tuning on the system).

Once you tell them...

Lynn Pettis (10/12/2011)

---

When in doubt, contact Microsoft. It is their kicensing scheme, they are the ones that will give you the answer you seek. All we can do...

It sounds to me like since these are not being used in any disaster recovery or production use, you are fine. Fundamentally, you are using these snapshots for development...

Here is a link to Microsoft's Quick Reference Licensing guide. This was very helpful to me when proving to my employers that we needed a separate license for Reporting services...

What I am asking is if the columns from that file that you need (assuming that you only need a subset) change names every time. If the names of the...

Sean Lange (10/11/2011)

---

jared-709193 (10/11/2011)

---

Sean Lange (10/11/2011)

---

Just to take a totally different approach to this. Could you not have just run a trace? This would have shown you what the actual...

Sean Lange (10/11/2011)

---

Just to take a totally different approach to this. Could you not have just run a trace? This would have shown you what the actual statements were. To...

SQL Server has some tools for you and depending on what your requirements are and what edition you have, these can be very useful (CDC is only available on Enterprise):

http://msdn.microsoft.com/en-us/library/cc280519.aspx

Thanks,

Jared

Are the column headers of the file for the columns that you need consistent? I must ask though, why is the file format changing. Can you ask for...

What edition of SQL Server 2008 are you running?

Thanks,

Jared

J Livingston SQL (10/10/2011)

---

Tom Bakerman (10/10/2011)

---

BUT, one clarification, and this is where I seem to get stuck:

The result for the current month is MTD (GETDATE()). The count for previous...