THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSMS » T-SQL   (RSS)
  • Quick Regions in SQL Server Management Studio (SSMS)

    There are a few tools and add-ins that support the creation of “regions” in T-SQL code. SQL Server Management Studio (SSMS) supports one way to separate sections of long-ish T-SQL scripts natively, by using begin/end: To demonstrate, start with a snippet of T-SQL that includes begin/end: If you click on the “-“ highlighted above, the code will ...
    Posted to Andy Leonard (Weblog) by andyleonard on April 14, 2017
  • A new (to me, and possibly you) SSMS feature - Query Plan Comparing

    Wow, Microsoft has really changed in culture recently. This new rapid release cycle for SSMS is seemingly paying dividends in a major way. In a recent build of SSMS (okay, perhaps not "recent", more like this October of 2015, according to this blog by the MSSQL Tiger Team:), they added the ability to compare query plans. I tried it on a ...
    Posted to Louis Davidson (Weblog) by drsql on January 26, 2017
  • Code that Writes Code

    I have scripts that re-create my databases for testing and development purposes. But sometimes I want to take the data from a set of tables and move it as well – I could use SSIS, or a SELECT INTO statement, but what if I want to “re-set” the data to a point in time? In other words, load it with some “base data”? I thought this might be a good ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 25, 2009
  • Connect digest : 2009-06-12

    Again I am a day early, as tomorrow I will be speaking at the CTDOTNET CodeCamp in Hartford.  As a reminder, I am not begging for votes here, just raising visibility for new issues you may not have seen yet, or older issues that have entered my peripheral vision again for some reason. ================================== Better behaving ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 12, 2009
  • Connect Digest : 2009-05-30 : please vote!

    Here are some issues I came across recently; most involve SSMS in some way, though Erland's assertion suggestion is a great one. And just to be clear, since I am seeing some accusations of distorting the fairness of Connect by ''asking for votes,'' I am not asking anyone to vote blindly on these items (and it's clear from last week's results that ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 30, 2009
Privacy Statement