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
989 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,401 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,521 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,731 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)
4,213 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,594 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,293 reads
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
By Steve Jones
fensiveness – n. a knee-jerk territorial reaction when a friend displays a casual interest...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers