SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Server System Architecture, 2002

Continues…

Eliminate the Use of Temporary Tables For HUGE Performance Gains

As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM clause of a SELECT statement. By using derived tables instead of […]

Interview with Tim Hayes, dbPAL Developer and CEO of IT-Map

Learn about the “big picture” of SQL Server-based software development from an industry veteran. Tell us a little about yourself. How did you get involved in databases? I started my IT career back in 1975 – at the time when I thought I was a late entrant into the game. Now, I guess you could […]

SQL Server 7.0 and 2000 Trace Flags

Trace flags are used to temporarily enable or disable specific SQL Server database functions, allowing you to change default database behavior or to observe hidden database behavior, and will remain in effect until they are either manually turned off or SQL  Server is restarted. Keep in mind that most trace flags are undocumented and Microsoft can and will […]

How 11GB of SQL Server Data Mysteriously Disappeared, and How I Ended Up Better Off than Before

The previous weekend, I had spent most of it working, upgrading a SQL Server 7.0 cluster to a SQL Server 2000 cluster. Fortunately, the rather complex upgrade went without a hitch. What made the upgrade complex was that the cluster held a 31GB ERP database that was used on a 24/7 basis, and unplanned down-time […]

Inside SQL Server Maintenance Plans

Like a lot of database administrators who manage many SQL Server databases, I have problems with maintenance and administration tasks. Some of these are massive jobs, which have to be created and maintained to be sure that databases are robust and reliable. One of the tools I use often to make my life a little […]

Some Useful Undocumented SQL Server 2000 Trace Flags

In this article, I want to tell you what should you know about some undocumented SQL Server 2000 trace flags, and how you can use them for administration and monitoring of SQL Server 2000. Trace flags are used to temporarily set specific server characteristics, or to switch on or off a particular behavior. You can […]

Manage Multiple SQL Server Installations and Databases with OSQL

At one point in time I was tasked with running over 70 databases on more than a dozen servers without any of the costly third-party tools that exist to accomplish such tasks, and I often get asked how can you handle such large numbers of databases. This is a short article that will show you […]

Auditing Your SQL Server Environment, Part II (Reviewing Role Memberships)

Over the last few years, I have been a roving SQL Server DBA contractor, tending to work contacts in small and mid-size companies that involved organizing, documenting and then tuning/optimizing existing SQL Servers in those companies. I have noticed one very disturbing truth over the years; no one seems to document anything. In fact, I […]

Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator’s Guidebook

Carl Speshock has been a DBA in the Houston area for over 6 years, and is moving back to Oregon, although he will continue to maintain some presence in Texas. Most recently, he has consulted to Shell Oil Products USA and Shell Services International. In addition to this book, he has authored an article on […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |