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. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
The Hide Instance option in SQL Server allows you to hide a specific instance of SQL Server from the list of available instances on the network. This can be useful for security purposes, as it can help to reduce the attack surface of your SQL Server installation by making it more difficult for attackers to discover the existence of the …
Securing SQL Server: Hide Instance Server Setting Read more »
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 exclusive, and the best approach will depend on the specific needs of your application and the characteristics of your dataset. Learn the techniques to boost your SQL performance……….. With our FREE SQL Server Performance Tuning Email …
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. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …
There are several methods you can use to detect corruption in your Microsoft SQL Server database: * Use the DBCC CHECKDB command: The DBCC CHECKDB command is a database consistency checker that scans the entire database and its associated objects to identify and report any corruption. Running DBCC CHECKDB is the most comprehensive way to detect corruption in your SQL …
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 is no private client information to expose here. For this month, here are the details. CXPACKET PREEMPTIVE_OS_PIPEOPS ASYNC_NETWORK_IO SP_SERVER_DIAGNOSTICS_SLEEP OLEDB MEMORY_ALLOCATION_EXT XE_LIVE_TARGET_TVF LCK_M_SCH_S CXCONSUMER LCK_M_SCH_M Our daily monitoring product scans your SQL Server hourly and …
Common Waits Reported by Daily Monitoring This Month Read more »
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 on SQL Server allows you to create stored procedures, triggers, and functions using languages such as C# and VB.NET. The “CLR strict security” option is an important security feature of CLR that allows you to …
Today Microsoft released a new update for SQL Server. SQL Server 2008 –
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 patched. SQL Server 2022 GDR SQL Server 2019 CU19 SQL Server 2017 CU31 then GDR SQL Server 2016 SP3 then GDR then GDR SQL Server 2014 SP3 then CU4 then GDR then GDR
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 tricks to get more performance out of your SQL Server. Become part of this exclusive group of subscribers learning to put the horse power back into their SQL Server. What You Get: Free weekly emails …