Staring you in the Face

Question

Staring you in the Face

Tony Davis

SSCarpal Tunnel

Points: 4405
More actions
May 16, 2009 at 11:17 am

#130389

Comments posted to this topic are about the item Staring you in the Face

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

Pseudo-Cursors, MAV's (Multiple Assigned Variables), NEWID() random number generators, and my long time friend, the Tally table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Andrew..Peterson SSCertifiable Points: 6838 More actions · Answer 2

...Mirroring is one of those features.

Sure you might have known about it, but until you get it going, and realize, how little effort it really takes, and the comfort it offers, you think, what took me so long to get going with this?

If you are busy making things happen, it easy not to have time to keep up with all the latest tools. Some are good, some are not.

That's what makes SSC such a great resource!

The more you are prepared, the less you need it.

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 3

Bill does a great job of showing those features. I might need to add those to our Question of the Day list!

nycdotnet Right there with Babe Points: 799 More actions · Answer 4

Use... Regular Expressions / Wildcards in the SQL Server Management Studio in the Find/Replace dialog.