Common QA for deploying SQL Server in a SAN Environment
Detailed question/answer paper on deploying SQL Server in a Storage Area Network (SAN) Environment.
2005-01-04
2,513 reads
Articles
Decorum in the Forums
One of the most valuable features of SQLServerCentral.com is the discussion forums, where many a DBA has found an answer to their question. Most times on the same day! While we do not moderate the forums, there are still some rules for posting that we hope everyone will take a moment to read.
2005-01-03
3,247 reads
Indexes: An Overview and Maintenance for Performance
SQL Server for the most part will maintain itself, updating statistics, choosing optimal query plans, and requiring minimal maintenance to keep running. However to optain optimum performance, a real DBA needs to spend some time checking and tuning indexes, rebuilding them as fillfactors change. This new article from Desiree Harris looks at how you can perform some of these tasks to keep your server performing at the optimum level.
2004-12-30
12,786 reads
Oracle Link
SQL Server is the best RDBMS, at least according to the current thinking at SQLServerCentral.com, and is fully capable of meeting all of your database needs. However not all database systems run on SQL Server and it seems that we often see data from some other system being consolidated on SQL Server for additional processing or reporting. DTS usually handles the load, but there are times that you might want create a linked server to an Oracle system for updating individual rows. New author Adria
2004-12-29
17,461 reads
Get all from Table A that isn't in Table B
A common requirement when building a data warehouse is to be able to get all rows from a staging table where the business key is not in the dimension table. For example, I may want to get all rows from my STG_DATE table where the DateID is not in DIM_DATE.DateID.
2004-12-29
2,168 reads
Becoming More Productive
Taking a break from SQL Server and DTS, author Haidong Ji shares a few tips and tricks to becoming more productive, whether as a DBA or developer. These hints and tips could help you separate yourself from the pack come review, raise, or interview time.
2004-12-28
10,120 reads
Tokenizing a String Using PARSENAME
SQL Server string manipulation using T-SQL leaves lots to be desired. Many postings and complaints about T-SQL deal with strings, but there are ways to work with it. Author Eli Leiba brings us a way to split out portions of a string that contains tokens with a user defined function. Read on to see how this is accomplished and the code used to perform the splitting.
2004-12-27
12,127 reads
SQL Server Hardware Performance Checklist
We take a look at each of the major components of a SQL Server's hardware, and examine what can be done to help maximize the performance of your hardware.
2004-12-27
2,856 reads
SQL Server: Compare Query Results - Part I
In the Database administration world, it is often necessary to run a query on the production box and then run the same query on the QA or UAT box and compare the results. In this article, I would like to introduce a method that takes advantage of an MS-DOS batch file and SQL Server utility, BCP.exe, to compare the query results executed on two different servers.
2004-12-24
1,828 reads
Getting the Most out of SQL Server 2000's Query Analyzer, Part I
So you open up the tool a hundred times a day. In this article by Brian Kelley, he shows you how to get the most out of some of the known and unknown features.
2004-12-23 (first published: 2002-02-21)
39,243 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
The Challenge of AI
Comments posted to this topic are about the item The Challenge of AI, which...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers