Useful tips for everyday
What is Resource_semaphore wait type? Description: This wait type is when a thread is waiting for a query execution memory grant so it can begin…
Where are audit logs stored in Windows? system32\config The event logs are located in Windows or WINNT directory under %WinDir%\system32\config. These files end in .…
What is the command for average in SQL? AVG() function is an aggregate function that calculates the average value of a numerical dataset that returns…
How do I connect to a database using PowerShell? One way to figure out if your computer can reach a SQL database and that your…
How do I copy a production database to a test system? Fundamentals: Cloning a production database to a test server Take the database off line.…
How to optimize large SQL Server inserts, updates and deletes? These are the IO results: Table ‘MyTestTable’. Scan count 1, logical reads 65415, physical reads…
How do I create a SQL server connection? Steps Install the SQL Server Management Studio software. This software is available for free from Microsoft, and…
What to do if MySQL failed to start error? Correcting the configuration errors – Any errors in the configuration file my.cnf or table corruptions are…
Can SSMS connect to Azure database? Get started using SQL Server Management Studio (SSMS) to connect to your Azure SQL Database and run some Transact-SQL…
What does CTE stand for in SQL Server? What is a Common Table Expression. A Common Table Expression, also called as CTE in short form,…