I write about SQL Server…and occasionally something else.
-
I wrote this a while ago to bring back the contents of a particular wmi class using powershell. It was orginally only developed to have a quick look at some wmi class settings. However as I continue to find it…
-
Time Calculations (Rounding time to 00:00 or x minute)
This is a collection of sql code to enable the removal of time from a datetime, or the rounding to the nearest x minute (up or down) The rounding includes 5,6,10,15,20 and 30 minutes time periods, however the scripts are…
-
Simple Table and Index Breakdown
This script provides a breakdown with row count and partition information of tables and indexes. It is in essence merely a cut down version of the final Detailed Table and Index Breakdown script. http://gallery.technet.microsoft.com/scriptcenter/Simple-Table-and-Index-61f93894
-
Detailed Table and Index Breakdown
When I need to get a detailed overview of my database objects there are a number of scripts that I have written or adapted with varying degrees of depth. Primarily I wrote these scripts as a way to determine rough rowcounts,database…
-
Investigating CHECKPOINT
Investigating CHECKPOINT (Transact-SQL) Writes all dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer cache and modified, but not yet written to disk. Checkpoints save time during a later…
-
Database Created Version or Internal Database Version – dbi_createversion
Internal Database Version Sometimes you will see references to a database with a version of 611 or 655 or similar. These numbers refer to the internal database version and have little meaning at first glance, however with a lookup list…
-
What is the easiest way to compare data in a SQL Server table and fix any differences?
Sync Table Data It is the sort of problem that you often get; you have 2 tables and you want to make sure that the data matches, however there are millions of rows and lots of columns to deal with.…
-
SQL Updates
Please see the following resource for a complete list of updates. Where to find information about the latest SQL Server builds https://support.microsoft.com/en-us/help/957826/where-to-find-information-about-the-latest-sql-server-builds
-
What has changed in SQL 2008 R2 SP1?
Changes from SQL 2008 R2 to SQL 2008 R2 SP1 Here is my comparison of changes for the SQL 2008 R2 SP1 update. New Column(s) sys.dm_exec_query_stats http://msdn.microsoft.com/en-us/library/ms189741.aspx sys.dm_os_sys_info http://msdn.microsoft.com/en-us/library/ms175048.aspx New Stored Procedure(s) This procedure raises the number of partitions from…
-
Policy-Based Management Execution Mode
Policy-Based Management Execution Mode If you are on a SQL 2008 or later then you are probably aware by now of the ability to set up various policies to help manage/audit, and in some cases prevent or roll back changes.…
Join 900+ subscribers
Stay in the loop with everything you need to know.