SQL Server Articles


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

Fun with Numbers in Transact-SQL Queries

Continues…

Speed Up SELECT DISTINCT Queries

Many people use the DISTINCT option in a SELECT statement to filter out duplicate results from a query’s output. Take this simple PUBS database query as an example:SELECT DISTINCTau_fname,au_lnameFROM authorsIn a simple SELECT from one table (like the one above) this is the easiest and quickest way of doing things.However, with a more complex query […]

Create and Manage SQL Server Stored Procedures using Transact-SQL

As we learn more about SQL Server and Transact-SQL, it is easy to become overwhelmed with the amount of information out there. I can recall hundreds of times when I have said, “I know there is a (stored proc, DBCC command, SQL statement, etc.) out there that does that, I just can’t remember its name.” […]

Troubleshooting SQL Server Full-Text Search Problems

Should you have problems with the SQL Server full-text search, review this troubleshooting checklist to help find potential solutions. 1. Check the hardware requirements For SQL Server 7.0, you should have: Alpha AXP, Intel or compatible platform Pentium 166 MHz or higher 64MB RAM or more (recommended) 180MB hard disk space For SQL Server 2000, […]

Use This SP to Generate a SQL Server Job Report

Have you ever wanted to create a report listing all of the SQL Server jobs on your SQL Server 7.0 or 2000 servers? This is easy if you use the stored procedure I have created just for this purpose. The stored procedure, called sp_JobSchedule_rpt, creates this report by joining the sysjobs and sysjobschedules tables and […]

A Comparison of SQL Server 7.0 with SQL Server 2000

Should you stick with SQL Server 7.0, or spend the big bucks to move to SQL Server 2000? To help you make your decision, here are some things to think about. Hardware and Software Requirements ComparisonTo install SQL Server 7.0, you should have the following hardware: Alpha AXP, Intel or compatible platform. Pentium 166 MHz […]

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