The Lounge is rated PG. If you're about to post something you wouldn't want your
kid sister to read then don't post it. No flame wars, no abusive conduct, no programming
questions and please don't post ads.
Scalar functions used in large sets can be the work of the devil, the overhead for processing a function is proportional to the number of rows and the run under a single thread. If you can't or don't want to use the CLR and want better performance, write table valued functions and use a subquery. Sounds stupid and kind of counter intuitive, but it works...
"If you ever start taking things too seriously, just remember that we are talking monkeys on an organic spaceship flying through the Universe"
Sorry, I meant table valued parameters, which is what I assumed Rhys was talking about (that is, pass a bunch of results to a function through a table valued parameter, then return the manipulated results as a table from the function).
I once did a mistake of writing a query with a function that takes a string, manipulates it and returns the value. The query took forever to run. Moving the logic to the query itself made it insanely faster.
On Tuesday when I went home from work there were a 30" and a 20" monitor connected to my PC. I had a day off Wednesday and came in this morning to find the 20" monitor has been swapped for another 30". It's pretty cool, I feel like I'm working in mission control now!
It's always nice having more than one monitor and having two quite large ones is nice. I don't have monitors as large as 30" but I have three 21.5" displays that I love using. I love the added screen space.
I'd be interested if it was a video about Raman Spectroscopy. As it stands, its a poor copy of a poor boy-band tune from 2000, coupled to a poor Bollywood video that soooooo can't decide if it wants to copy "The Beach" or that Wham video on the Yacht. Even the moderately attractive woman in it doesn't save things: she's fully clothed throughout, and barely features. Instead we're treated shots of to the over-vocalized singer trying hard to hip or whatever the youngsters are calling it nowadays.