Viewing 15 posts - 3,376 through 3,390 (of 4,081 total)
Great 😀
I only learned about the speed of ITVFs in the last couple of months, from someone else in here. The performance gains are enough to justify the...
March 17, 2009 at 6:50 am
Great 🙂
I only learned about the speed of ITVFs in the last month or so, from someone else in here. The performance gains are enough to make...
March 17, 2009 at 6:45 am
A couple of suggestions:
(1) To improve performance, rewrite your scalar functions as inline table valued functions. They run MUCH faster in queries that produce large result...
March 16, 2009 at 10:48 pm
That's the best thing about rants, Sergiy 😀
Now I personally have no intention of visiting the aforementioned blog. But, according to Wikipedia...
Dataphor was originally created as a commercial...
March 16, 2009 at 10:12 pm
I'm in the states, and the choice of beverage is secondary to the opportunity for a good conversation. Do you do caffeine?
March 16, 2009 at 9:36 pm
I realized that one Mh is SSC Enthusiastic and the other is a Forum Newbie. Can we assume that the "Urgent Urgent" isn't really any more?
March 16, 2009 at 9:28 pm
Guiness is better. Perhaps some day we'll have opportunity to knock back a pint or two, Lynn. First round is on me.
March 16, 2009 at 9:24 pm
No cursor needed. I don't have your original data, so I'm using a table variable in my code below to mimic your output. The code below...
March 16, 2009 at 9:14 pm
No, we aren't sure what you want your output to look like.
One field on a particular table is used for 4 different fields on the report; what differentiates each one...
March 16, 2009 at 8:12 pm
Science is a b****, expediency is a w*****.
You call the language above a mark of maturity? Crass doesn't equal cool, and foul language isn't a...
March 16, 2009 at 7:34 pm
Hey Steve, you may need to implement some functionality to lock down Author's Names in the forums.
Something peculiar is going on here.
The thread was started by...
March 16, 2009 at 7:16 pm
Took me a while to sort out the identities by join date.
The obvious question to ask is:
If the other Mh wasn't the person that started this thread, why did they...
March 16, 2009 at 7:11 pm
I'm all for wine tours, but only if we include New Zealand and Australia as well. Maybe Argentina too. Obviously, I drink a lot from the...
March 16, 2009 at 4:13 pm
There are a couple of ways.
First, if you are running this from SQL Enterprise Manager, there is an option to include row headers when you send...
March 16, 2009 at 4:08 pm
Viewing 15 posts - 3,376 through 3,390 (of 4,081 total)