(Tim Radney) Over the past year, I have presented many sessions on Azure SQL Database as well as authoring numerous articles and blogs. I’m often asked if database maintenance is still an important factor when using Azure SQL Database. Yes – tasks such as index maintenance, statistics updates, and c
Tag: sql server
SQL SERVER – My Thoughts – Autogrow of File ‘SQLAuth_Log’ in Database ‘SQLAuth’ was Cancelled by User or Timed Out After 30020 Milliseconds
(Pinal Dave) If you are seeing this error in the ERRORLOG on your production server then you must read this blog. I have collected some information about the message and its causes. Let us learn about Autogrow of file.
(Greg Larsen) Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Well there is a way to read the transaction log file using an undocumented function. In this article, I will show you how to browse the transaction log using this undocumen
(Kenneth Fisher) TL;DR: It’s pretty pointless and can cause performance issues.
(Krishnakumar Rukmangathan) Hi folks, recently I came across an interesting issue related to impersonation in SSAS and I thought of sharing with you.
(Rajendra Gupta) Microsoft SQL Server 2016 recently launched SQL Server 2016 SP1 and in this tip we will explore the enhancements to DBCC CLONEDATABASE.
(Manoj Pandey) Basically I have a JSON file output that I want to put into a SQL table, but no matter what syntax I try it doesn’t seem to be working.
(Tibor Karaszi) SQL Server keep statistics for where it waits. This statistics can be find using various DMVs, the most famous of them is probably sys.dm_os_wait_stats. This DMV has accumulated wait stats for each type since you started SQL Server.
(Pinal Dave) Sometimes it is important to read the documentation before assuming things based on the text. This blog is the result of one of my quick interaction with a client who had an issue with Maintenance Plan which they created for backup files.
(NEERAJ Sharma) In some situations we need to create table from another table for many reasons, for example, We need to make some changes in the table`s schema, and we want to keep the original schema as a backup or we just want a look a like table, where we can put some data as backup in future etc