| November 26, 2025 |
|
|
|
|
sys.dm_hadr_database_replica_states
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 19, 2025 |
|
|
|
|
sys.dm_exec_requests, sys.dm_hadr_automatic_seeding, sys.availability_databases_cluster, sys.availability_groups, sys.dm_hadr_physical_seeding_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| March 26, 2025 |
|
|
|
|
sys.dm_hadr_database_replica_states, sys.availability_replicas, sys.dm_hadr_availability_replica_states
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| February 10, 2025 |
|
|
|
|
SSISDB.Catalog.Executions, msdb.dbo.sysjobs , msdb.dbo.sysjobsteps
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| February 3, 2025 |
|
|
|
|
fn_virtualfilestats, sys.master_files
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 21, 2024 |
|
|
|
|
sys.availability_groups, sys.availability_replicas, sys.dm_hadr_availability_replica_states
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 16, 2024 |
|
|
|
| November 4, 2023 |
|
|
|
|
sys.dm_hadr_database_replica_states
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 24, 2023 |
|
|
|
|
sys.tables, sys.indexes, sys.index_columns, sys.columns
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 1, 2023 |
|
|
|
| July 23, 2023 |
|
|
|
|
sys.database_files, sys.filegroups
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 10, 2023 |
|
|
|
|
sys.query_store_plan, sys.query_store_query, sys.query_store_query_text, sys.query_store_runtime_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 4, 2022 |
|
|
|
| November 13, 2022 |
|
|
|
|
A Migration Performance Check Item
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 8, 2022 |
|
|
|
| September 12, 2022 |
|
|
|
|
MSdistribution_status, MSarticles, MSreplication_monitordata
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 6, 2022 |
|
|
|
|
sys.dm_database_encryption_keys
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 20, 2022 |
|
|
|
|
sysjobs, sysjobhistory, sysjobschedules, sysoperators
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 20, 2022 |
|
|
|
|
sys.dm_hadr_database_replica_states, sys.availability_replicas, sys.dm_hadr_availability_replica_states
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 10, 2022 |
|
|
|
|
sys.tables, sys.columns, sys.types, sys.partitions
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 8, 2022 |
|
|
|
|
sys.dm_os_ring_buffers, sys.dm_exec_requests, sys.dm_exec_query_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| March 10, 2022 |
|
|
|
| February 16, 2022 |
|
|
|
|
Column Statistics and Index Statistics
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| February 8, 2022 |
|
|
|
| January 3, 2022 |
|
|
|
|
sys.indexes, sys.dm_db_index_usage_stats, sys.dm_db_partition_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 11, 2021 |
|
|
|
| July 17, 2021 |
|
|
|
| April 4, 2021 |
|
|
|
|
Enter Short Description Here
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 28, 2020 |
|
|
|
|
sys.sql_modules, sys.objects
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 31, 2020 |
|
|
|
|
sys.availability_groups_cluster, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.availability_group_listeners, sysjobs
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| September 1, 2020 |
|
|
|
|
sys.dm_io_pending_io_requests
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 12, 2020 |
|
|
|
|
sys.availability_groups_cluster, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.availability_group_listeners
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 26, 2019 |
|
|
|
|
sp_estimate_data_compression_savings
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 14, 2019 |
|
|
|
|
msdb.dbo.sysjobservers, msdb.dbo.sysjobs
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 24, 2019 |
|
|
|
|
SQL Server VAS (Virtual Address Space)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 3, 2019 |
|
|
|
| January 30, 2019 |
|
|
|
|
Receive alerts on any SQL Jobs Failed
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 21, 2019 |
|
|
|
|
msdb.dbo.restorehistory, msdb.dbo.backupset, msdb.dbo.backupmediaset, msdb.dbo.backupmediafamily
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 15, 2019 |
|
|
|
|
Bitwise operators perform bit manipulations between two expressions of any of the data types of the integer data type category...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 6, 2018 |
|
|
|
|
sys.database_files, sys.dm_os_performance_counters, sys.dm_db_file_space_usage
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 3, 2018 |
|
|
|
|
Alter Database tempdb Modify File
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 3, 2018 |
|
|
|
|
Alter Database Modify File
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 23, 2018 |
|
|
|
| November 23, 2018 |
|
|
|
|
sys.objects, sys.database_permissions, sys.database_principals
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 1, 2018 |
|
|
|
|
Alter Database Remove File
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 31, 2018 |
|
|
|
|
msdb.dbo.backupset, msdb.dbo.backupmediaset, msdb.dbo.backupmediafamily
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| September 15, 2018 |
|
|
|
|
Output any differences with System Catalog Views
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| September 4, 2018 |
|
|
|
|
SQL_Handle, Plan_Handle, Query_Hash, Query_Plan_Hash, Query Cache Statistics, Plan Attributes
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 22, 2018 |
|
|
|
|
dbo.sp_validate_redirected_publisher, dbo.sp_Validate_Replica_Hosts_As_Publishers, dbo.MSRedirected_Publishers
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 19, 2018 |
|
|
|
| June 17, 2018 |
|
|
|
|
sys.dm_exec_query_stats, sys.dm_exec_sql_text, sys.dm_exec_cached_plans, sys.dm_exec_query_plan, sys.dm_os_tasks, sys.dm_os_workers, sys.dm_os_waiting_tasks
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 6, 2018 |
|
|
|
| May 22, 2018 |
|
|
|
|
[MASTER].sys.Servers, [MASTER].sys.linked_logins, [MASTER].sys.server_principals
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 18, 2018 |
|
|
|
| May 18, 2018 |
|
|
|
| May 14, 2018 |
|
|
|
|
master.sys.databases, master.sys.server_principals, msdb.dbo.sysjobs
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 6, 2018 |
|
|
|
|
Use a Driver table for Database List
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| April 29, 2018 |
|
|
|
| April 28, 2018 |
|
|
|
|
sys.master_files, sys.databases, sysaltfiles
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| April 28, 2018 |
|
|
|
| April 21, 2018 |
|
|
|
|
Use this DMV to determine which part of the query is running slow.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| April 13, 2018 |
|
|
|
|
Useful for SQL Server Database Migrations that use DETACH & ATTACH process
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| March 23, 2018 |
|
|
|
|
sqlserver.deprecation_announcement, sqlserver.deprecation_final_support
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| March 22, 2018 |
|
|
|
|
Enter Short Description Here
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| March 10, 2018 |
|
|
|
|
CREATE EVENT SESSION, ADD EVENT, ADD TARGET
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 23, 2018 |
|
|
|
|
sys.trace_events, sys.trace_subclass_values
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 18, 2017 |
|
|
|
|
sp_detach_db, sp_attach_db
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 12, 2017 |
|
|
|
|
Max Worker Time, Max Elapsed Time, Execution Counts, Last Elapsed Time
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 30, 2017 |
|
|
|
|
Execute against each Database in the Instance + Log Results + Check for any errors + RaiseError(Alert)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 29, 2017 |
|
|
|
|
sp_scriptpublicationcustomprocs (Transact-SQL)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 18, 2017 |
|
|
|
| November 9, 2017 |
|
|
|
| November 8, 2017 |
|
|
|
|
sys.stats, sys.stats_columns, sys.columns, sys.partitions, sys.objects
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 8, 2017 |
|
|
|
|
sys.dm_db_missing_index_group, sys.dm_db_missing_index_group_stats, sys.dm_db_missing_index_details
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| September 26, 2017 |
|
|
|
|
sys.tables, sys.schemas, sys.indexes, sys.partition, sys.allocation_units
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| September 9, 2017 |
|
|
|
|
Captures, Logs, Alerts & Reports for Microsoft SQL Server Transaction Replication Distribution Metrics.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 30, 2017 |
|
|
|
| August 25, 2017 |
|
|
|
| August 22, 2017 |
|
|
|
|
800+GB Transaction Log File
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 18, 2017 |
|
|
|
| August 18, 2017 |
|
|
|
|
sys.objects, INFORMATION_SCHEMA.ROUTINES
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 17, 2017 |
|
|
|
|
StateChangeEvent, State, MonitorView, ManagedType
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 30, 2017 |
|
|
|
|
sys.server_principals, sys.server_permissions, sys.sql_logins
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 29, 2017 |
|
|
|
|
sys.dm_server_services, sysprocesses, sys.databases
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 26, 2017 |
|
|
|
|
sys.dm_db_index_physical_stats, sys.indexes
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 24, 2017 |
|
|
|
|
sys.columns, sys.objects, sys.types
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 23, 2017 |
|
|
|
|
Removes residual information left on database pages because of data modification routines in SQL Server.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 21, 2017 |
|
|
|
|
msdb.dbo.backupset, msdb.dbo.backupmediafamily
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 19, 2017 |
|
|
|
|
sys.dm_os_windows_info vs sys.dm_os_host_info
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 12, 2017 |
|
|
|
|
sys.database, sys.master_files, sys.data_spaces, sys.dm_os_volume_stats, sp_send_dbmail
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 8, 2017 |
|
|
|
|
sys.database, sys.master_files, sys.data_spaces, sys.dm_os_volume_stats
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 5, 2017 |
|
|
|
| June 30, 2017 |
|
|
|
|
sys.objects, sys.partitions, sys.allocation_units, sys.indexes, sys.dm_os_buffer_descriptors
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 28, 2017 |
|
|
|
|
sp_readerrorlog, sp_helptext
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 25, 2017 |
|
|
|
|
A New DMF used to examine the structure of Transaction Log files and it is a replacement for DBCC LOGINFO. It returns VLF information of the Transaction Log Files.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 24, 2017 |
|
|
|
|
A New DMV to identify free disk space. It is a replacement for XP_FIXEDDRIVES.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 23, 2017 |
|
|
|
|
A New inline TVF to check if a file exists or not. It is a replacement for XP_FILEEXIST.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 20, 2017 |
|
|
|
|
New in SQL Server 2017, it contains information about the Wait Stats for Queries in the Query Store. Query Store is a great feature to help with performances issues related to Plan changes.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 19, 2017 |
|
|
|
|
SQL Server Configuration options are available to manage via SQL Server Management Studio Application (SSMS) or sp_configure stored procedure...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 14, 2017 |
|
|
|
|
sys.database_principals, sys.database_permissions, sys.schemas, sys.objects
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 7, 2017 |
|
|
|
|
Captures diagnostic data and health information about SQL Server to detect potential failures. The procedure runs in repeat mode and sends results periodically.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 7, 2017 |
|
|
|
|
This query returns all Replication SQL Jobs and reports on it's Last Run Time and Run Status...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 5, 2017 |
|
|
|
|
sys.dm_os_wait_stats - Returns information about all the waits encountered by threads that executed. Use this aggregated view to diagnose performance issues with SQL Server and also with specific queries and batches.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 3, 2017 |
|
|
|
|
Backupset - Contains a row for each backup set. A backup set contains the backup from a single, successful backup operation. Backupmediafamily - Contains one row for each media family.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 31, 2017 |
|
|
|
|
Log shipping allows you to automatically send transaction log backups from a PRI DB on a PRI Server to one or more SEC DB(s) on separate SEC Server(s)...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 29, 2017 |
|
|
|
|
With Time, With Uniqueidentifier
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| May 12, 2017 |
|
|
|
|
During recent testing of a new Microsoft Azure Cloud setup of SQL Server 2016 Standard running Always On Availability Groups Basic...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| April 11, 2017 |
|
|
|
|
Procedure Cache, Parameter Sniffing, SSMS Compare Execution Plans Tool, SSMS Live Execution Plan Tool
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| March 30, 2017 |
|
|
|
| March 29, 2017 |
|
|
|
|
msdb.dbo.sysmail_sentitems, msdb.dbo.sysmail_faileditems, msdb.dbo.sysmail_event_log, msdb.dbo.sysmail_configuration
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| March 16, 2017 |
|
|
|
|
Distribution.dbo.MSdistribution_history
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| February 2, 2017 |
|
|
|
|
Example - Transactional Replication Pending Commands
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 27, 2017 |
|
|
|
|
SQL Server Reporting Services(SSRS) is a Microsoft solution that provides customers with the ability to create, publish and manage reports...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 27, 2017 |
|
|
|
| January 18, 2017 |
|
|
|
|
sys.dm_hadr_availability_replica_cluster_nodes, sys.dm_hadr_availability_replica_cluster_states, sys.dm_hadr_availability_replica_states, sys.dm_hadr_database_replica_states, sys.availability_replicas
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 12, 2017 |
|
|
|
| January 3, 2017 |
|
|
|
|
Generates a Schema and Statistics only copy...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| January 1, 2017 |
|
|
|
|
Built-in T-SQL functions in SQL Server 2016
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 30, 2016 |
|
|
|
|
JSON_VALUE, JSON_QUERY, JSON_MODIFY, OPENJSON, FOR JSON
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 27, 2016 |
|
|
|
|
A new type of user table in SQL Server 2016
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 17, 2016 |
|
|
|
|
Inserting, Updating, and Deleting Data by Using MERGE
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 17, 2016 |
|
|
|
|
Pivoting the data based on a column values
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 13, 2016 |
|
|
|
|
IDENTITY, DBCC CHECKIDENT
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 13, 2016 |
|
|
|
|
sys.traces, fn_trace_gettable, fn_dblog, SSMS Report
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 9, 2016 |
|
|
|
|
Generate a List of Numbers, Generate a List of dates(DATEFROMPARTS, EOMONTH, MAXRECURSION), Navigate a Hierarchy
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 8, 2016 |
|
|
|
|
sp_helppublication, sp_helpsubscription, sp_addarticle, sp_addsubscription
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 6, 2016 |
|
|
|
|
Functionally equivalent to DBCC INPUTBUFFER
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 6, 2016 |
|
|
|
|
CTE, Row_Number(), Over(Partition by)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 5, 2016 |
|
|
|
| December 5, 2016 |
|
|
|
|
SUBSTRING Function w/ PATINDEX(Pattern Index Function) and a REGEX(Regular Expression)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 29, 2016 |
|
|
|
|
MSlogreader_history, MSlogreader_agents, sp_replcmds
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 4, 2016 |
|
|
|
|
MSdistribution_history, MSdistribution_agents
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 15, 2016 |
|
|
|
|
Analytic functions compute an aggregate value based on a group of rows. However, unlike aggregate functions, they can return multiple rows for each group.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 15, 2016 |
|
|
|
|
Ranking functions return a ranking value for each row in a partition
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 13, 2016 |
|
|
|
|
sys.databases, sys.master_files
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 7, 2016 |
|
|
|
| October 6, 2016 |
|
|
|
|
Create Login, Create User, sys.sql_logins , sys.database_principals
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 3, 2016 |
|
|
|
|
Alter Database FAILOVER, sys.dm_geo_replication_link_status, sys.dm_operation_status
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| September 9, 2016 |
|
|
|
|
information_schema.tables, sys.tables, replication
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| September 2, 2016 |
|
|
|
| August 28, 2016 |
|
|
|
| August 22, 2016 |
|
|
|
|
Transaction Log Size, Number of VLF(Virtual Log Files), Connection Details
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 10, 2016 |
|
|
|
|
SkipErrors, Validate Subscriptions
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 20, 2016 |
|
|
|
|
Distribution.sys.sp_MSget_repl_commands
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 17, 2016 |
|
|
|
|
Transactional Replication, Distribution.dbo.MSdistribution_history, Distribution Retention Period
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| July 14, 2016 |
|
|
|
|
Publication Name, Publication DB, Article Name, Distribution Name, Subscriber Name, Subscriber DB
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 30, 2016 |
|
|
|
| June 29, 2016 |
|
|
|
|
MSDN function dbo.agent_datetime for Date & Time, Filter out Replication Jobs
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 28, 2016 |
|
|
|
| June 22, 2016 |
|
|
|
| June 10, 2016 |
|
|
|
| May 9, 2016 |
|
|
|
|
Enter Short Description Here
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| April 13, 2016 |
|
|
|
| February 5, 2016 |
|
|
|
|
DBCC Show_Statistics, Set Statistics Profile, Set Statistics IO, Set Statistics Time, sp_updatestats, DBCC dropcleanbuffers, DBCC freeproccache
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| December 23, 2015 |
|
|
|
| November 23, 2015 |
|
|
|
|
Report Server Execution Log and the ExecutionLog3 View
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 8, 2015 |
|
|
|
|
Using T-SQL get the Total Elapsed Time, Percentage Completed & Estimated Completion Time...
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 7, 2015 |
|
|
|
|
Requires Storage Account, Container & Credential
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 2, 2015 |
|
|
|
|
sqlserver.sql_batch_completed, ring_buffer
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 2, 2015 |
|
|
|
|
sqlserver.rpc_completed, sqlserver.sql_batch_completed, ring_buffer
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| November 1, 2015 |
|
|
|
|
SQLQueryStress by http://www.datamanipulation.net/
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 12, 2015 |
|
|
|
|
Distributor, Publisher, Publications & Subscribers
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| October 7, 2015 |
|
|
|
|
Using ASCII (Transact-SQL)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 6, 2015 |
|
|
|
|
sys.master_files, sys.databases
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 5, 2015 |
|
|
|
|
Along with sys.messages & other resources
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| August 4, 2015 |
|
|
|
| August 2, 2015 |
|
|
|
|
Using T-SQL, find a stored procedure call within a SQL Server Job step(s)
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 28, 2015 |
|
|
|
|
Use T-SQL to find the lead blocking SPID and it's INPUTBUFFER contents.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 28, 2015 |
|
|
|
|
T-SQL Solution for Hashing Lookup Table records in a Microsoft SQL Server Database. Required for data level Change Detection/Control implementations.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 28, 2015 |
|
|
|
|
Use T-SQL to capture, filter & log Active SPID Execution Duration for all active requests inside the Microsoft SQL Server Engine.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|
| June 21, 2015 |
|
|
|
|
Concatenate Row Values in SQL Server using T-SQL's FOR XML and STUFF function.
|
| | | |
| | | |
|
Read More
|
| | | |
| | | |
|
Tags
TSQL
|
|
|