roger.plowman (9/28/2015)

---

TDD is one of those subjects I'm torn on. On the one hand it is unequiocally a good idea, of COURSE you want to test everything!

On the other hand,...

Differential Beers due to outage: (4-(Tier of the affected Server))*(number of "is it done yet" calls from users)*( number of functions affected) / (# of dba's on call)

Dean Mincic (9/22/2015)

---

Hi cthorn112

I think the CASE Statement needs ELSE part, something like

....

,CASE

...

Alvin Ramard (9/23/2015)

---

Steve Jones - SSC Editor (9/23/2015)

---

Well, since...

Maxer (9/23/2015)

---

Eric M Russell (9/23/2015)

---

Batching DML operations will always be faster than doing it one row at a time. However, keep in mind that a batch is a single transaction,...

erichansen1836 (9/12/2015)

---

One big complaint I would have in parting is that the users need to have physical access to the DB stores. Sure you can play games and obfuscate, etc.......

Kristen-173977 (9/14/2015)

---

I was picking up on your point about the pain that...

Kristen-173977 (9/14/2015)

---

We are surrounded by "cheap" here (UK side). Maybe different where you...

Brandie Tarvin (9/14/2015)

---

Public is a server-wide role. As previously mentioned, you can add people to individual databases without the role, but unless they know what to type / look at,...

Kristen-173977 (9/14/2015)

---

Matt Miller (#4) (9/14/2015)

---

The time you and your dev team spend building out your own RDBMS isn't "free": it's time you're not spending on building out actual useful functionality...

Lynn Pettis (9/14/2015)

---

I am not interested in rolling my own DBMS even if part of it is done for me, the Jet engine. Everything you have been writing from...

mar.ko (9/14/2015)

---

This compiled but won't execute:

Msg 557, Level 16, State 2, Line 1

Only functions and some extended stored procedures can be executed from within a function.

ALTER FUNCTION dbo.fnReturnTablesForGroup

(

@whichgroup int

)

RETURNS @RETTAB...

Eirikur Eiriksson (9/14/2015)

---

Jeff Moden (9/14/2015)

---

Eirikur Eiriksson (9/13/2015)

---

Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000% Annual interest rate:pinch:

😎

Jeff Moden...

erichansen1836 (9/12/2015)

---

I think my main concern would be maintainability. YOU understand what you've done, and it seems to work well for your organization. I hate to use the Bus example,...

Installing the Jet engine on each PC would reintroduce the same issues you had with a shared MDB: you're executing "unfiltered" DB calls over the wire and filtering on the...