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
847 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 Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers