Browse by Tags

Renaming Databases Posted on SQLServerCentral.com

Renaming Databases was just published on SSC, another in my lastest effort to expose some of the hidden complexities in seemingly routine operations. Definitely read the discussion thread attached to the article as there were several very good additional tips suggested.

Posted to It Depends (Weblog) by Andy Warren on 09-04-2008
Building a Security Philosophy Posted on SQLServerCentral.com

This was actually posted about a week ago, fell behind a little during travelling. Building a Security Philosophy was written to get people to think about they approach security. Do you give the proverbial Junior DBA only partial access? Do you believe in table access? Do you use the built in roles?...

Posted to It Depends (Weblog) by Andy Warren on 08-18-2008
Moving TempDB Posted on SQLServerCentral.com

Moving Tempdb isn't a common operation, and mercifully a simple one if it comes to that. As in much of the stuff I write about I wanted to put down a nice detailed answer to a pretty simple question. Think you know how it works? What happens to the original tempdb mdf/ldf if you move tempdb? Do they...

Posted to It Depends (Weblog) by Andy Warren on 08-04-2008
Rebuilding Stats: Twice or Not at All Posted on SSC

Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the article was that if you're rebuilding indexes with the default options you're automatically getting stats update on those columns as well.

Posted to It Depends (Weblog) by Andy Warren on 07-29-2008
Disabling Indexes Published on SQLServerCentral.com

It's been a while since I had anything up on SSC, a combination of Steve being in good shape on content and me being busier than usual, but early July I had a break and got 4 articles done. Disabling indexes isn't a complicated option of course, but one of the things I see in classes is that...

Posted to It Depends (Weblog) by Andy Warren on 07-22-2008
Computed Columns Published on SSC

I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level performance tuning class . It's not a technique you'll apply that often, but I think it's used less often than perhaps it should be. Hope you'll take a look and add a comment...

Posted to It Depends (Weblog) by Andy Warren on 02-12-2008
Partitioning Part 4 Posted on SSC

Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series worked out reasonably well, accomplished my goal of introducing the technology and options without getting into dense technical detail. There is definitely more to explore...

Posted to It Depends (Weblog) by Andy Warren on 01-17-2008
The DBA Routine Posted on SSC

This was fun to write, though it's hard to boil everything down to 10 big steps. I thnk as an industry we tend to forget that there are a LOT of us wearing multiple hats, working solo, just trying to get things done - and while we want to do things the right way, there isn't always clear guidance...

Posted to It Depends (Weblog) by Andy Warren on 11-30-2007
Trigger Trivia Posted on SSC

A short article but interesting I think, with some good comments already. I think in general triggers are under used, except in the cases where they are abused of course. Here's the article: http://www.sqlservercentral.com/articles/T-SQL/61483/

Posted to It Depends (Weblog) by Andy Warren on 11-13-2007
Replicate Stored Procedure Execution Published on SSC

Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the publisher are applied one row at a time on the subscriber using the system generated procs created on the subscriber. I actually tend to agree with the concept, opting for a vanilla implementation...

Posted to It Depends (Weblog) by Andy Warren on 11-05-2007

Page 1 of 2 (18 items) 1 2 Next >