SQL Server Articles


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

An Interview with Simon Galbraith, Marketing Director of Red Gate Software, on Major Trends in the SQL Server Market

What do you see as the major trends affecting the SQL Server market? SQL Server is becoming one of Microsoft’s biggest businesses. As it becomes bigger and more important, I think we’ll see a number of changes that affect users, Microsoft, and the market in which Red Gate participates. The main market for SQL Server […]

Taking a Proactive Approach with SQL Server Agent

SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is often overlooked as one of the main tools for SQL Server management. Its purpose is to ease the implementation of tasks for the DBA, with its full-function scheduling engine, which allows you to schedule your own jobs […]

How to Find a SQL Server Database Object

How many times, we as a SQL developer or DBA, find ourselves shuffling through objects in Enterprise Manager, or expanding the left pane of Query Analyzer, trying to find a table or view for which we have no clue, except a nearly correct name, and the only way we would know that it is the […]

Pros & Cons of Using SELECT, Views, and Stored Procedures in SQL Server

When I first started using SQL Server as a novice, I was initially confused as to the differences between the SELECT statement, views, and stored procedures. They all seemed to perform more or less the same task (retrieve data), and I wanted to know the pros and cons of using each. Why would SQL Server […]

SQL Server 2000 Table Hints

As you advance in your skills as a Transact-SQL developer, or SQL Server database administrator, there will come a time when you need to override SQL Server’s locking scheme and force a particular range of locks on a table. Transact-SQL provides you with a set of table-level locking hints that you can use with SELECT, […]

Some Useful Undocumented SQL Server 7.0 Trace Flags

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

Keep Your SQL Servers Synchronized with SQL Compare and SQL Data Compare

Managing multiple versions of the same database across different environments (i.e. Development, Test, Production, and Disaster Recovery site) is perhaps one of the most important and least favorable Database Administrative duties. Whether it’s synchronizing database objects or actual data, creating utilities to perform this obligatory task is somewhat of a dreaded chore. I mean, think […]

Are SQL Server Temp Tables Really Necessary?

You will find articles on this website, as well as others, advising you to avoid the use of temporary tables to maximize the performance of your queries. I agree with the articles, but would like to add that sometimes you cannot avoid the use of a temporary table. For those of you who have not […]

An Exclusive Interview with Edward Whalen Co-Author of Microsoft SQL Server 2000 Performance Tuning

Read the SQL-Server-Performance.Com Book Review Edward Whalen is the co-author on four SQL Server books from Microsoft Press: SQL Server 7 Administrator’s Companion, SQL Server 7 Performance Tuning Technical Reference, SQL Server 2000 Administrator’s Companion, and SQL Server 2000 Performance Tuning Technical Reference. He has also authored four Oracle books. Edward Whalen is also vice […]

Can Amazon Serve Customers and Protect Privacy at the Same Time? (What Data Should DBAs Keep and Discard)

One of the biggest challenges for DBAs and programmers is deciding when to keep information and when to discard it. Good records are both the product of a natural, protective instinct, and a requirement for many businesses. That’s why websites and businesses need detailed tracking information to offer the most customization and assistance.But this information […]
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 |