sp_help_partition
If you are using partitioned tables, this may come in handy. I’ll keep it short and just post the code....
2010-08-08
1,728 reads
If you are using partitioned tables, this may come in handy. I’ll keep it short and just post the code....
2010-08-08
1,728 reads
This blog series will cover several different methods to collect drive information from a Windows server that is running SQL...
2010-06-29
2,625 reads
SSIS-DTS Package Search 2.0.18 has been released. This is a bug fix release that addresses a problem with the search...
2010-06-08
809 reads
The DTS support in SQL Server 2005 and 2008 is excellent (almost). Typically the packages and jobs do not need...
2009-11-02
1,315 reads
The download page for SSIS-DTS Package search presents three choices:
SSIS-DTS Package Search for SQL Server 2000 on Windows x86SSIS-DTS Package...
2009-08-12
1,456 reads
My primary development machine for the past 3 years was a 32 bit Toshiba Satellite notebook running XP named PROBE-DROID....
2009-06-04
848 reads
Denny Cherry wrote a blog post recently discussing whether to run anti-virus software on Sql Server machines. He said you...
2009-05-20
772 reads
When creating a table with a column that will hold the name of a stored procedure that feeds an EXEC...
2009-04-30
1,427 reads
2009-04-28
1,474 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers