Category Archives: Problem Resolution

  1. Query to compare indexes between two tables

    Leave a comment

    October 16, 2013 by Kenneth Fisher

    We have a set of databases at my office that use the load and swap method of loading data with …
    Continue reading

    Category: Index, Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication | Tags: , , , , ,

  2. Why you should know how to script as well as use the GUI

    Leave a comment

    October 14, 2013 by Kenneth Fisher

    Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out …
    Continue reading

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

  3. I’ve refreshed a test database from prod but now the users can’t access it.

    4

    October 9, 2013 by Kenneth Fisher

    This happens to me all the time. I get a request from a developer to overwrite the test copy of …
    Continue reading

    Category: Backups, Microsoft SQL Server, Problem Resolution, Security, SQLServerPedia Syndication | Tags: , , ,

  4. Brad Shultz’s blog on reviewing your database

    1

    September 17, 2013 by Kenneth Fisher

    This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
    Continue reading

    Category: Backups, Microsoft SQL Server, Performance, Problem Resolution, SQLServerPedia Syndication | Tags: , , ,

  5. The most important skill to practice when preparing for any certification exam!

    4

    August 28, 2013 by Kenneth Fisher

    I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an …
    Continue reading

    Category: Certification, Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication | Tags: ,

  6. Notes on debugging Database Mail problems

    10

    July 29, 2013 by Kenneth Fisher

    I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
    Continue reading

    Category: Database Mail, Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, System Functions and Stored Procedures | Tags: , , , ,

  7. EXECUTE, not required, but advisable.

    1

    February 6, 2013 by Kenneth Fisher

    The other day one of the developers I work with gave me a script similar to this: He was getting …
    Continue reading

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

  8. Small changes, big effects

    Leave a comment

    January 30, 2013 by Kenneth Fisher

    We got a call last week about an application that was running slowly. The server was showing about 80% CPU …
    Continue reading

    Category: Index, Microsoft SQL Server, Performance, Problem Resolution, SQLServerPedia Syndication, T-SQL | Tags: , , , , ,

  9. Red errors in the results pane

    3

    December 19, 2012 by Kenneth Fisher

    Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed …
    Continue reading

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

  10. I can connect to my instance locally but not remotely

    4

    October 23, 2012 by Kenneth Fisher

    Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down.  …
    Continue reading

    Category: Microsoft SQL Server, Problem Resolution, Settings | Tags: , ,

Newer 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 3,975 other subscribers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013