Viewing 15 posts - 2,686 through 2,700 (of 8,416 total)
Stefan Krzywicki (9/12/2010)
September 12, 2010 at 5:57 pm
Alvin Ramard (9/12/2010)
They say we learn by our mistakes. Some need a major mistake before they learn.
I think the whole thread was a mistake, bordering on a train wreck.
See...
September 12, 2010 at 5:37 pm
Lennie (9/12/2010)
strSql = "Select SupplierID, SupplierName "strSql &= "IIF(ActiveStatus = 1, 'YES' , 'NO') as ActiveStatus "
strSqk &= " From TblSupplier "
SQL Server does not have the IIF function, so...
September 12, 2010 at 3:54 pm
Hmm. If anyone is wondering why 'Lennie' mentioned CASE before - it's because (s)he asked the same question on another site and has become confused as to who said...
September 12, 2010 at 8:40 am
steve-893342 (9/12/2010)
I believe this feature was introduced in SQL Server 2005.
Thanks Steve - I couldn't remember whether it worked in SQL Server 2000 or not. If anyone has a...
September 12, 2010 at 8:11 am
GilaMonster (9/12/2010)
September 12, 2010 at 6:27 am
Lennie (9/11/2010)
September 12, 2010 at 6:17 am
Steve Jones - Editor (9/10/2010)
I always find time to read. Keeps me sane (...)
:laugh: Sane?
September 10, 2010 at 8:01 am
Matjaz Justin (9/10/2010)
My question is: is it possible to have CLR table-valued function with variable number of return columns?
All functions (T-SQL or SQLCLR) must return a deterministic set of columns....
September 10, 2010 at 6:03 am
CirquedeSQLeil (9/9/2010)
I'm missing it too. Maybe it was read as "Knave" instead as "naive"
On reflection, I think the problem is simply lack of familiarity with the term. I...
September 9, 2010 at 9:09 am
Douglas Osborne-456728 (9/9/2010)
I knew you were in rarefied air when a Google search on 'NormalizeGbAgg SQL' returned 36 results and Bing returned 2 - both yours! 10 Star articleDoug
That's...
September 9, 2010 at 8:51 am
Hugo Kornelis (9/9/2010)
My sole critisicm of this article is that it's much too short.I can't wait to read the parts three and four!
Thank you, Hugo.
September 9, 2010 at 8:34 am
Rick-153145 (9/9/2010)
I feel I must point out this great typo though, made me chuckle:"1. Convert the naive nested loops join to an index nested loops join "
I still can't see...
September 9, 2010 at 8:25 am
aeyates (9/9/2010)
Do you have before/after timings?
No.
Was the query statement unchanged?
Yes.
Did you add an index?
No.
It is not clear how the query was improved.
The series is about how the query optimizer works...
September 9, 2010 at 8:15 am
Viewing 15 posts - 2,686 through 2,700 (of 8,416 total)