Viewing 15 posts - 1 through 15 (of 37 total)
Moreover, a simple SELECT into a variable without a table is optimized as equivalent to a SET, so in the following example, only the third variation returns the expected NULL:
April 20, 2015 at 5:37 pm
Good summary and followup to the prior article http://www.sqlservercentral.com/articles/FMTONLY/64130/ "How SSIS and Other Tools Obtain Metadata". Based on the comments there, two additional points to make:
1 - Note that PRINT...
April 20, 2015 at 5:36 pm
Stephanie J Brown (1/15/2015)
January 18, 2015 at 6:06 am
Indeed, I have also learned that "just asking a business person to tell me what to do often results in neither of us being successful."
Just had a situation where they...
January 15, 2015 at 2:04 am
Looks like the key insight is in http://www.sqlservercentral.com/articles/SSRS/119024/ "Dealing with the Evil of FMTONLY from SSRS": every possible conditional code branch is evaluated. Yes, that is right: every...
December 23, 2014 at 1:50 am
Two wrinkles to be aware of - PRINT has no effect with FMTONLY ON, and SELECT = constant takes effect as soon as you SET FMTONLY OFF. So this works:
December 17, 2014 at 1:13 am
@Renato Buda-153382: It didn't work for you because you did SET instead of SELECT. That's why I was able to initialize my variable to 0 with SET, then check if...
December 17, 2014 at 12:59 am
@t.ovod-everett good catch, selecting a constant works as well as selecting a count from a table (I checked it in SQL 2005).
December 15, 2014 at 8:33 pm
Please consider voting for these related Microsoft Connect feature requests (I just added #917919):
July 11, 2014 at 1:09 am
4 stars! You should mention how to confirm that it took effect, by looking at the errorlog after creating a database, to see if it no longer says "Zeroing completed"....
July 11, 2014 at 12:18 am
@jobudzin, my NameSQLinConfioIgnite script did get published at http://www.sqlservercentral.com/scripts/Performance+Tuning/106514/. Enjoy, and please let me know if you have success or any issue with it.
February 13, 2014 at 6:39 am
@jobudzin, my "NameSQLinConfioIgnite" script is scheduled to publish on SSC Feb 5-6. If you want it sooner, you can send me an email from my website http://www.tomkellerconsulting.com/[/url] (linked...
January 27, 2014 at 12:02 pm
@jobudzin, I have submitted my "NameSQLinConfioIgnite" script to SSC, will advise when it is published. I just ran it to capture the usage of my example in the...
January 25, 2014 at 12:13 am
@swoozie, I have not put further effort into "achieving the nirvana of an Inline Table-Valued UDF using a Recursive CTE (Common Table Expression) with zero logical reads" for...
January 24, 2014 at 11:44 pm
@jobudzin, I love Confio Ignite, but I quickly realized the pain of naming many SQL statements legibly... and then re-naming them, without duplication, when they were recompiled. A...
January 13, 2014 at 2:38 pm