Jeff Moden (5/8/2012)

---

david.rowland (5/7/2012)

---

Although RegEx is powerful, I have tried using it once and found that coding my own CLR function to manipulate strings to what I want was 100...

Although RegEx is powerful, I have tried using it once and found that coding my own CLR function to manipulate strings to what I want was 100 times faster than...

GSquared (6/15/2011)

---

And, of course, this absolutely won't work:

SELECT

eggs,

cheese,

milk,

--bread,

cookies,

salt,

...

My coding method is more like the following:

SELECT

eggs

,cheese

,milk

,bread

,cookies

,salt

...

Thanks for that reply.

Overlooked that on the books.

Removing access to the servers BUILTIN\Adminstrators group to an IT Infrastrure team just so they cannot create a login to SQL Server will be like not allowing DBA's access to...

If a hacker wants to read this article thinking they can use it to hack into SQL Server databases, then they will be disappointed.

The title is fine.

Thanks for this ariticle. Could come in handy one day.

Just a few things to clear up from some of the comments here:

1. You just need to be a...

My rule of thumb for removing cursors is to try to replace them with a set based operation if I can.

I would rather use several set based queries and then...