Monthly Archives: April 2013

notes on parallel processes in MS SQL

Determine the MAXDOP (Maximum degree of Parallelism) on machines with t_SQL: select * from sys.configuration where name = ‘max degree of parallelism’ NB: DBCC check DB or check indexes will not run in parallel except in Enterprise regardless of the MAXDOP setting … Continue reading

Posted in Uncategorized

notes on SQL data compression

be very afraid – i just went to edit this post – and the original was totally gone.  WTF. There is going to be a webinar on data compression by Jes Schultz-Borland of Brent Ozar’s group, and i wanted to get … Continue reading

Posted in Uncategorized

size of tables in database

quick script to go through the tables of a database and count the number of rows in each. use databaseNameSET NOCOUNT ON DBCC UPDATEUSAGE(0) — DB size.EXEC sp_spaceused — Table row counts and sizes.CREATE TABLE #t ( [name] NVARCHAR(128), [rows] … Continue reading

Posted in Uncategorized

simple ad from powershell

a nice post from Norman Drews on two approaches to AD access from Powershell Option one is to use the AD module provided by Microsoft. You can see if  you have it with get-module -listavailable FYI i mistyped that since … Continue reading

Posted in Uncategorized