1. Default Database Reports – Disk Usage by Table

    1

    July 19, 2017 by Kenneth Fisher

    Every now and again you need to know how big a table is. Or several tables. Or all of the …
    Continue reading

    Category: Microsoft SQL Server, Reporting, SQLServerPedia Syndication, SSMS | Tags: , ,

  2. Default Instance Reports – Configuration Changes History

    Leave a comment

    July 17, 2017 by Kenneth Fisher

    Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured …
    Continue reading

    Category: Auditing, Microsoft SQL Server, Settings, SQLServerPedia Syndication, SSMS | Tags: , , ,

  3. Default reports in SSMS

    1

    July 13, 2017 by Kenneth Fisher

    As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are …
    Continue reading

    Category: Documentation, Microsoft SQL Server, SQLServerPedia Syndication, SSMS | Tags: , ,

  4. Save and save often

    2

    July 11, 2017 by Kenneth Fisher

    It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday! …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL, T-SQL Tuesday | Tags: , ,

  5. What is the system_health extended events session?

    1

    July 5, 2017 by Kenneth Fisher

    Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures | Tags: , ,

  6. SQL Homework – July 2017

    8

    July 3, 2017 by Kenneth Fisher

    For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a …
    Continue reading

    Category: Backups, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  7. SQL Crossword : T-SQL Keywords : June 2017

    Leave a comment

    June 28, 2017 by Kenneth Fisher

    I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked …
    Continue reading

    Category: DBA Humor, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , ,

  8. Temp table quiz

    10

    June 26, 2017 by Kenneth Fisher

    Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , ,

  9. Dynamically generate the command line DMA statement for each database

    Leave a comment

    June 21, 2017 by Kenneth Fisher

    If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run …
    Continue reading

    Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, Upgrades

  10. Adding Identity to an existing column

    1

    June 19, 2017 by Kenneth Fisher

    A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
    Continue reading

    Category: Microsoft SQL Server, Partitioning, SQLServerPedia Syndication, T-SQL | Tags: , ,

« Older Entries

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,662 other followers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013