Feb 20 2009
Index-Index-Index-Index-GOOSE! (Part One)
Overview of the statistical indexing DMVs and DMFs for SQL Server. sys.dm_db_index_operational_stats, sys.dm_db_index_usage_stats, and sys.dm_db_index_phyisical_stats.
Tips and Tricks
Dec 1 2008
Problems With Installing SQL Server 2008 Management Studio Not Necessarily The Fault of SQL 2005 Express Tools
Problems with installing SQL Server 2008 Management Studio? Maybe it’s not SQL 2005 Express Tools as you’re being told by the installer.
Dec 1 2008
Using Dynamic SQL in Cursor Versus sp_MSforeachdb
sp_MSforeachdb yeilds unexpected results when you exclude databases compared to cursors.
Dec 1 2008
xp_logininfo
Need to determine what domain users are associated with an Active Directory Group that has rights to your SQL Database. Use xp_logininfo.
Dec 1 2008
Table Space Calculation, Redux
I’ve been asked if there was a SQL 2000 version of the Table Space Calculation code I posted the other day. The answer is yes. It only required that I change the @Results table variable to a temp table, #Results. This will work on SQL 2000, 2005 and 2008. While I was at it, I modified the code to report back results in Mb (who cares for Kb anyhow?)
Dec 1 2008
Determine Space Consumption At The Table Level
Yesterday, I was asked about how much space certain tables were consuming in one of the databases I support. I created the following query to provide that information.
1 2
