After finishing a recent project we received this feedback from the customer. As a community health center with many competing priorities and limited resources, we sought out Stedman Solutions for help with optimizing, maintaining, and upgrading our aging SQL infrastructure. We’ve engaged with Steve and Derrick for several SQL-related projects, including an initial assessment and optimization, and a “forklift” upgrade …
Occasionally I have come across the need to save the output from a query to a varchar value, for instance varchar(max). There are lots of ways to do this, could you use a cursor and just append to a string each loop through the cursor, but there is an easier way. Examples of a need to do this would be …
SQL Server Alert System: ‘Severity 20 – Fatal Error In Current Process’DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: 192.168.1.xxx] With SQL Server alerting turned to for some of …
Part of good server monitoring it to have alerts enabled for a number of different errors to know when things go bad. The problem is we were getting the following error every time the server was restarted. SQL Server Alert System: ‘ERROR 824’ occurred on \\MyServerNameDESCRIPTION: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xe660dd36; actual: 0xcd481907). …
Recently while working on a SQL Server for a client I came across the following error when I attempted to view the SQL Server logs in SSMS. From there I decided I needed to track this down, so I attempted to run the sp_readerrorlog stored procedure, which also failed, but it provided more informaiton. The full error message was: Msg …
Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I needed to find queries that were being run against a SQL Server that were in Serializable mode. The way that it works is the first section runs and creates the temp table, then the second part loops for 500 tries …
Should I upgrade from SQL Server 2008 and SQL Server 2008 R2 now that it is at end of life? On July 9, 2019 SQL Server 2008 and 2008 R2 reached their end of life for support. Technically what this means is that 2008 and 2008 R2 have reached the “Extended Support End Date”. This means that Microsoft will no …
You may be configuring SQL Mail for the first time or the thousandth time and you come across the following cryptic message. Date 8/xxxxxx03 AM Log Database Mail (Database Mail Log) Log ID 40 Process ID 56316 Mail Item ID 14 Last Modified 8/ xxxxx 03 AM Last Modified By sa Message The mail could not be sent to the …
Here is a quick script that I find myself using frequently to find the largest tables on an entire SQL Server instance.
It is interesting, when working with many different clients, the questions about installing Windows Updates and SQL Server updates comes up and often the discussion leads to the pros versus cons of each. The need to apply updates and the balance with the business requirements. Pros and Cons of Windows and SQL Server updates on Production SQL Servers: PRO: Service …
Latest Service Packs – To Install or Not to Install? Read more »