This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.
2003-05-22
1,874 reads
Joe discusses why he prefers command line tools over GUI, then launches into a how-to about querying sysperfinfo to resolve performance issues. Couple nice sample queries included!
2006-04-21 (first published: 2003-05-14)
32,862 reads
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
2005-08-26 (first published: 2003-04-23)
48,501 reads
We've all seen the numbers published about how well very db vendors do on the TPC tests - have you ever visited the site that sponsors the tests? Or looked to see what hardware and software configuration was used to achieve the score? Lots of good information on this site!
2003-04-10
825 reads
Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.
2003-03-30
18,800 reads
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 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
Disk space is getting cheaper everyday. Why should you worry about the amount of space your data is consuming? This article by Neil Boyle presents some great reasons why you should be concerned.
2003-02-21
10,059 reads
In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance?
2002-11-14
7,101 reads
In this article new columnist Christoffer Hedgate offers his advice on what performs better, COUNT(*) or COUNT(column).
2002-09-23
17,581 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
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...
We want to setup a gateway db to host stored procedures which use tables...
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...
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers