This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes
2003-03-14
2,224 reads
In this quick article by Jon Reade, he shows you how to correct an unusual error in SQL Server that may occur when you create a database.
2003-03-12
5,630 reads
This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.
2003-03-11
7,150 reads
The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
2003-03-10
9,943 reads
The first part of this series provides a road map for a very cool application using an under-utilized companion of the SQL Server 2000 database platform.
2003-03-07
8,262 reads
In this series by Quest Software's Kevin Kline, he shows you some tips to performance tuning T-SQL. This was contributed by Quest from their recent webcast. This white paper discusses various T-SQL discovery, optimization and tuning techniques using the SET and DBCC commands.
2003-03-06
2,669 reads
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
2003-03-04
8,818 reads
This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective.
2003-03-03
10,487 reads
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
2003-02-28
22,130 reads
If your shop is even close to the typical Micosoft SQL Server environment there are several people that can (and do!) make changes to the production environment, a change management system is in place, that change management system uses Source Safe to store database scripts, and what's in Source Safe does not match what's on the SQL Server. This utility by Bill Wunder will archive your SQL scripts and DDL into Source Safe easily and efficiently. All for the price of $0 (yes, free!).
2003-02-26
285 reads
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
Comments posted to this topic are about the item Lots of FKs
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Comments posted to this topic are about the item Can You Let Go of...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers