Category Archives: Microsoft SQL Server

  1. Why shouldn’t I shrink my database data file?

    2

    November 20, 2017 by Kenneth Fisher

    A while back I did a post about why you shouldn’t shrink your data file. This one is going to …
    Continue reading

  2. Variables in Dynamic SQL

    Leave a comment

    November 16, 2017 by Kenneth Fisher

    I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
    Continue reading

  3. It takes a village

    1

    November 14, 2017 by Kenneth Fisher

    Ewald Cress (b/t) is our host this month for Adam Machanic’s (b/t) monthly blog party T-SQL Tuesday. Having just gotten …
    Continue reading

  4. More Collation Confusion. (tempdb)

    1

    November 8, 2017 by Kenneth Fisher

    I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance …
    Continue reading

  5. DBA Definitions: FILLFACTOR

    1

    November 6, 2017 by Kenneth Fisher

    It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing …
    Continue reading

  6. SQL Homework Nov 2017: Create a view

    2

    November 1, 2017 by Kenneth Fisher

    Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they …
    Continue reading

  7. Schema only backup or schema only DB copy

    Leave a comment

    October 25, 2017 by Kenneth Fisher

    Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded …
    Continue reading

  8. When is it a good idea to consolidate multiple instances?

    1

    October 23, 2017 by Kenneth Fisher

    In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple …
    Continue reading

  9. Updateable CTEs

    4

    October 18, 2017 by Kenneth Fisher

    CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t …
    Continue reading

  10. Permissions required for developing with Temporal Tables

    1

    October 16, 2017 by Kenneth Fisher

    Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table …
    Continue reading

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

Join 2,148 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013