(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.
How to Read the Transaction Log 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
Why shouldn’t I shrink my database log file?
(Kenneth Fisher) TL;DR: It’s pretty pointless and can cause performance issues.
Error while impersonating an user in SQL Server Analysis Services
(Krishnakumar Rukmangathan) Hi folks, recently I came across an interesting issue related to impersonation in SSAS and I thought of sharing with you.
DBCC CLONEDATABSE Enhancements in SQL Server 2016 SP1
(Rajendra Gupta) Microsoft SQL Server 2016 recently launched SQL Server 2016 SP1 and in this tip we will explore the enhancements to DBCC CLONEDATABASE.
Parsing nested JSON in customized SQL Tabular format – MSDN TSQL forum
(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.
Log wait stats over time
(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.
SQL SERVER – Maintenance Plan – Backup Files Not Getting Deleted
(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.
How to copy Table Structure Without Data in SQL Server
(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