Always music, it energizes without distracting, and masks other distractions. I use star ratings and tempo/loudness groupings, so I can just run a "smart" playlist to randomize the right type...

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:

DECLARE...

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...

Stephanie J Brown (1/15/2015)

---

I'm wondering if anyone else has had this experience, though: the users typically think that the most complex solutions are "easy to do" and the...

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...

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...

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:

SET...

@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...

@t.ovod-everett good catch, selecting a constant works as well as selecting a count from a table (I checked it in SQL 2005).

Please consider voting for these related Microsoft Connect feature requests (I just added #917919):

https://connect.microsoft.com/SQLServer/feedback/details/917919/when-instant-file-initialization-is-in-effect-zeros-should-be-lazy-written

https://connect.microsoft.com/SQLServer/feedback/details/809901/add-isinstantfileinitializationenabled-islockpagesinmemory-to-policy-facets

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"....

@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.

@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...

@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...

@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...