A developer found a columnstore index cannot be created on a large history table in SQL Server 2014. The surprise cause: computed columns in the table.
Duplicate Entry for Key PRIMARY in wp_options: Fix With REPAIR TABLE
A duplicate entry for key PRIMARY on INSERT INTO wp_options made my blog slow and stopped scheduled posts. After four hours of trial and error, REPAIR TABLE wp_options fixed the corrupted table. Here is the log line, the command and a script that repairs every table.
How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088
Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?
SQL SERVER – Setup Screen Not Launching While Updating a Patch
Double clicking a SQL Server patch just flashed a window and vanished. SqlSetup.log in the %temp% folder showed why the Setup Screen was not launching.
SQL SERVER – How to Increase the SSMS Grid Font Size?
Presenting SSMS results to a big room? Zoom does not work on the results grid, but Tools, Options, Fonts and Colors lets you raise the grid Font Size.
SQLAuthority News – New SQL in Sixty Seconds Video
Today I am going to discuss the new SQL in Sixty Seconds Videos which I have released. Let us learn about them together. Do not forget to subscribe.
SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user
A customer moving from Oracle kept getting Error 18456, Severity: 14, State: 5 from Java and from SSMS. Here is how we found the real cause.