Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links



Search this Blog


Post Categories


August 2006 Blog Posts


Have you tried out YourGMap? It allows you to plot multiple locations on one map (Google Maps) and publish it to the Internet for others to see.  We are currently using it to plot the houses that we've looked at or need to look at in search for our new home.  Our real estate agent probably has a similar tool but I doubt it's as efficient as this one. 

posted @ Tuesday, August 15, 2006 2:32 PM | Feedback (2) | Filed Under [ Other ]

UPDATE STATISTICS stored procedure

Here's the stored procedure that I use to update statistics on a database.  I don't use sp_updatestats as it doesn't allow you to change the number of rows to sample.  I typically run it weekly on the databases that I support.  CREATE PROC isp_UPDATE_STATISTICS(@dbName sysname, @sample int)AS SET NOCOUNT ON DECLARE @SQL nvarchar(4000)DECLARE @ID intDECLARE @TableName sysnameDECLARE @RowCnt int CREATE TABLE ##Tables( TableID INT IDENTITY(1, 1) NOT NULL,  TableName SYSNAME NOT NULL) SET @SQL = ''SET @SQL = @SQL + 'INSERT INTO ##Tables (TableName) 'SET @SQL = @SQL + 'SELECT [name] 'SET @SQL = @SQL + 'FROM ' + @dbName + '.dbo.sysobjects ' SET @SQL...

posted @ Monday, August 14, 2006 3:26 PM | Feedback (0) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET