Pages
Posts by category
- Category: Administration
- Read specific errors using temp table
- How to find SQL Server Cluster information
- How to find orphan database files
- How to work with a certificate in SQL Server
- Database Email and system objects
- How to find the missing foreign key indexes
- Availability group fail-over
- Kill all user processes for a database
- How to use extended events to catch all error in SQL Server
- How to find /change SPN configuration
- How to change SQL Server collation
- How to find SQL Server proxy login
- How to find the currently running queries in SQL Server
- How to get Service account information in SQL Server using scripts
- How to find SQL server listening port
- How to find login information in SQL Server using T-SQL
- How to create a login trigger
- How to generate a script to get all SQL mail configuration using T-SQL
- How to find SQL Server Job history
- How to kick out all user from SQL server database
- Sql server Database list with Size
- Find TOP 50 unused indexes in a database
- Transact-SQL syntax not supported in Azure SQL Database
- Dedicated hosting provider name with Price calculator
- How to add active directory linked server
- Generate Scripts from existing email configurations
- How to find deleted object detail in SQL server default trace
- Category: Agent Job
- Category: Backup-Restore
- Database Snapshots (SQL Server)
- Restore database in SQL Server TSQL Statement
- How to find a backup task by percentage complete
- SQL Server find database without backup from a given date
- Backup History using TSQL
- Reading the transaction log in SQL Server
- SQL Server database backup history
- How to find log file used space in SQL server
- Category: DB Design
- Category: DB Information
- Get tempdb version store space usage by database
- How to check what databases are accessible?
- Get QueryStore Options for this database
- Database performance information
- Find all comments in SQL server for all kind of objects
- Foreign Key scripts
- Get VLF count for all databases
- Get CPU utilization by database
- Last VLF status of the current database
- Get database file info
- Suspect Pages table in SQL server
- Track data changes using CDC in SQL Server Enterprise edition
- Log space usage for the current database
- Tables dependency order
- Database property
- SQL Server Tables and row counts
- SSIS catalog database read
- Find the average size of rows in tables
- List all assemblies in a database
- How to find Cross-database dependency
- Get database scoped configuration values for the current database
- Get current database files information
- All user-created statistics
- Category: Error-Warning
- Category: Features
- Category: General
- SQL Server database design
- Dynamic Data Masking in SQL Server
- How to work with Temporal Tables in SQL Server
- Tables without a Clustered Index (Heap)
- How to find SQL server Object dependency
- How to find SQL Server installation Date
- SQL Server Q/A (high availability)
- How to calculate Easter date
- Database files information using query
- Query statistics for a single table
- IO Statistics in SQL Server using Query
- Find all constraints that need to be entrusted.
- Database model
- How to work with a collation
- How to and where to use inbuilt objects in SQL server
- How to get all database-level information using T-SQL
- How to check the writeable copy of the database in the availability group SQL server
- How to read the SQL log file using TSQL
- Database side pagination
- Standard RegEx in SSMS
- SQL Server Management Studio (SSMS) Shortcuts
- Still some developer use improper data type when designing database.
- SQL Server services
- SQL Server Version and code name
- Know about SQL Server edition
- Category: HA-DR
- Category: Help Query
- Category: Performance
- Query Plan read using T-SQL
- CPU utilization trends
- Determine which scalar UDFs are in-lineable
- Get Memory Clerk Usage
- Check Memory pressure on the server
- Get lock waits for the current database
- Columnstore index physical statistics
- Get IO Statistics by database
- Get input buffer information for the current database
- Find single-use, ad-hoc, and prepared queries
- Get top average elapsed time queries
- Get the most frequently executed queries for this database
- How to read the SQL Server query plan file using TSQL
- Get top total worker time queries
- How to read Deadlock from system health of SQL server
- Page Life Expectancy (PLE) value for each NUMA node
- Finding a SQL Server running Task with percentage complete using DMVs
- Top Procedures By Total Logical Reads
- Top Procedures By Total Worker time
- Memory Grants Pending value
- I/O Statistics by file for the current database
- How to find SQL Server procedure statistics.
- Get top total logical reads queries
- Top Procedure by execution count
- Top Procedures By Avg Elapsed Time
- How to find similar index in SQL Server Query
- Get UDF execution statistics
- Find require index on tables
- Top Query by average input/output usage for the current database
- Possible Bad NC Indexes
- Top Procedures By Total Physical Reads
- Query Statistics
- Find missing index warnings from cached plans
- Buffers used by current database objects
- Get index fragmentation information
- Get most frequently modified indexes and statistics
- Tables that don’t have Primary Key
- Category: Powershell-cmd
- Category: Query Type
- Category: Remote Query
- Category: Security
- Category: Server Informantion
- Hardware information from SQL Server
- Check all drive space on the server
- Resource Governor Resource Pool information
- Get any memory dumps from SQL Server
- Manufacturer information inside SQL server
- Read Windows Registry from SQL server
- SQL Server Services information
- SQL Server NUMA Node information
- Get Server properties
- Get Volume statistics (Storage Partition)
- SQL Socket & Core information
- List of all global trace flags that are enabled
- SQL Configuration Values
- SQL Information
- Get TempDB files count
- Get a count of SQL connections by IP address
- Find Server property using TSQL code
- Find SQL Server collation
- Server OS information
- Category: SSIS
- Category: SSMS
- Category: Table Info
- Get in-memory OLTP index usage
- Tables with more than 30 columns (wide tables)
- Re-assign the identity of all the tables.
- Tables with Identity columns
- Tables with at least one LOB (max) column
- Get fragmentation info for the tables
- Tables with at least one TEXT, NTEXT, IMAGE column
- Tables with more than 5 indexes
- List objects with space used information
- Find objects that use compression
- Tables with INSTEAD OF triggers
- Tables with at least two triggers
- Tables contains XML columns
- Get Table names, row counts, and compression status
- Index Read/Write stats
- Get table property
- Category: Uncategorized
- Category: XML-JSON
Archives
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- May 2021
- April 2021
- March 2021
- February 2021
- January 2021
- December 2020
- November 2020
- October 2020
- September 2020
- August 2020
- July 2020
- June 2020
- May 2020
- April 2020
- March 2020
- February 2020
- January 2020
- December 2019
- November 2019
- October 2019
- September 2019
- August 2019
- July 2019
- June 2019
- May 2019
- March 2019
- January 2019
