Delete all rows from all user tables. Create stored procedure and execute the procedure to get rid of all rows from all tables. This will not drop your tables. Be very careful what you wish for!
2004-10-06 (first published: 2004-01-20)
107 reads
This script displays all tables in a database that has identity columns.
2004-10-06
151 reads
This article contains guidelines compiled by examining the .NET implementations of shipping .NET applications and analyzing the common performance mistakes that we found. The guidelines discuss selecting .NET objects and methods, designing .NET applications, retrieving data, and updating data.
2004-10-06
3,043 reads
A simple script created to summarize locking by spid, by database, by type with more user friendly descriptions. You can also run for a specific spid. Hope it's useful.
2004-10-05 (first published: 2004-01-27)
496 reads
The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database.
With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.
2004-10-05
1,758 reads
Returns the number of records within a table without having to perform COUNT.
2004-10-04 (first published: 2004-02-03)
852 reads
In this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features.
2004-10-04
2,632 reads
2004-10-01 (first published: 2004-02-16)
138 reads
This is a UDF that counts the days between two dates ignoring weekends and corporate holidays (as supplied in a lookup table). This ignores the time component but could be adjusted should you need to. If both days are on the same work day then the elapsed days is considered 1. If started Monday and […]
2004-09-30
441 reads
2004-09-30 (first published: 2004-02-16)
97 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