Here is my replacement for sp_spaceused, I have altered it so that if no table is past in using the @objname parameter it loops through all the tables which is alot easyer than running the old one for each table and it displays the data one result set. So should be easyer to create a […]
2007-08-23
1,042 reads
I wrote this script to compare record counts between a live database and a restored copy to test backups, I thought people might find it useful. What You need is to just copy the script and run it against your database.
2007-08-21
1,420 reads
To run with the pack in terms of performance, productivity, and competition, servers that are long in the tooth have to be put out to pasture regularly. But there might be (and usually is) some life left in these early retirees, and they can still be put to good use.
2007-08-17
4,108 reads
Three different ways that you can get the count of the rows in a table.
2011-06-16 (first published: 2007-08-16)
6,559 reads
How many cores (or hardware threads) can your code harness to get its answers faster?
2007-08-16
2,251 reads
Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]
2011-09-14 (first published: 2007-08-15)
2,773 reads
Service-Component Architectures (SCA) provide a programming model for implementing Service-Oriented Architectures (SOA)
2007-08-14
2,344 reads
Usually in business applications it is necessary to maintain the history of the data being modified for auditing purposes or for later analysis. Proven way to achieve this is to create a log table for each datatable with an additional column "Action" to indicate what the user has done on the data (either insert, update […]
2007-10-26 (first published: 2007-08-09)
6,234 reads
Just one way of testing for a linked server based on data within your database.
2011-09-16 (first published: 2007-08-07)
2,631 reads
Ensuring that our careers grow is something that each of us must take charge of and Andy Warren brings us one of the ways in which you can do this: create a plan. Andy talks about how you can structure a plan at different stages of your career.
2007-08-07
5,333 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers