SQL Server Articles


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

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 […]

Migrating from Oracle to SQL Server

I was involved in a recent project to migrate an Oracle database to Microsoft SQL Server 2000, and successfully migrated all Oracle objects to SQL Server. This experience has encouraged me to write an article on Oracle to SQL Server 2000 migration. In this article, I will explain how to transfer Oracle Objects, including constraints […]

SQL Server 2000 I/O Configuration in a SAN/NAS Environment

Some of the most common SQL Server performance problems involve the I/O subsystem. Since SQL Server’s main function is to manipulate data, and that data resides either in memory or on the I/O subsystem, any I/O performance problems will result in SQL Server performance problems. Much of the design of the SQL Server RDBMS is […]

An Exclusive Interview with Author Fernando Guerrero On How to Get the Most of ADO.NET and SQL Server

Read the SQL-Server-Performance.Com Book Review Fernando Guerrero, SQL Server MVP (Most Valuable Professional), is the author of the Que book, Microsoft SQL Server 2000 Programming, and is currently writing a book on ADO.NET and SQL Server for Apress. He is the Principal Technologist and SQL Server Product Consultant for QA, which is the leading IT […]

Sample SQL Server Disaster Recover Plans

Continues…
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 |