Ways to Increase SQL Server Performance
There are many ways to increase SQL performance, some of the most common and effective include: It’s worth noting that these methods are not mutually… Read More »Ways to Increase SQL Server Performance
SQL Server Wait Type: LCK_M_SCH_M
The LCK_M_SCH_M wait is an important locking wait to understand in SQL Server. Wait statistics, in the context of SQL Server, refer to the amount… Read More »SQL Server Wait Type: LCK_M_SCH_M
SQL Server Corruption: How To Detect Corruption
There are several methods you can use to detect corruption in your Microsoft SQL Server database: * Use the DBCC CHECKDB command: The DBCC CHECKDB… Read More »SQL Server Corruption: How To Detect Corruption
Common Waits Reported by Daily Monitoring This Month
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there… Read More »Common Waits Reported by Daily Monitoring This Month
Securing SQL Server: Securing CLR
CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR… Read More »Securing SQL Server: Securing CLR
New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2008 –
SQL Server – Security Patches
In the last day or two Microsoft has released several updates with security patches. If you have SQL Server running anywhere, please make sure it’s… Read More »SQL Server – Security Patches
Exclusive SQL Performance Tuning Training
Steve and the team at Stedman Solutions, LLC have put together an email based performance tuning course where each week you can get tips and… Read More »Exclusive SQL Performance Tuning Training
SQL Performance Training Opportunity
Why is SQL Server performance important? SQL performance is important because it directly affects the speed and efficiency of a database system. Poor performance can… Read More »SQL Performance Training Opportunity
SQL Server Wait Type: SLEEP_MEMORYPOOL_ALLOCATEPAGES
Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: SLEEP_MEMORYPOOL_ALLOCATEPAGES