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 » Tips » SSMS   (RSS)
  • Hovering Over the Titles in Activity Monitor

    I show this little-known feature in just about every perf tuning class I give, and it’s often a surprise to most of the folks there. It’s not earth-shattering or anything, but I do find it helpful. In SQL Server Management Studio 2008, start the new Activity Monitor. Open one of the “Bands”, such as “Processes”. Move your mouse cursor over one of ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 21, 2010
  • Tools and Processes for “Fitting it all in”

    Most data professionals I’ve met work in two modes: we plan for our day, and we react to the situations around us. I’m staring at my list of things that I need to do today right now, which is my planned work. Of course, I have no idea how much of that will really get done – it’s optimistic to be sure. On the other hand I have several systems I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 18, 2010
  • Quick poll : what is your favorite Management Studio tip or trick?

    I am putting together a presentation on SSMS Tips & Tricks, which I will debut at SQL Saturday #34.  I already have a pretty full slide deck, but I am not the be-all and end-all of SSMS, so in the interest of distributing this information as widely as possible, I would be interested to see if you have any tips and/or tricks that I haven't ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 4, 2010
  • 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
  • Changing the Primary Key After You Have Data

    Yesterday I blogged about changing a Primary Key (PK) during the design phase, and before you have data in the database. Even then, it’s not trivial to change the data type or column(s) that make(s) up the PK. When you have data in that Primary Key and/or you have Foreign Keys (FK) that point to a PK field, this becomes a much more involved ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 24, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement