Below workaround will help you incase if you wanna control SQL agent job steps based on a SQL query output. For eg: Suppose you have…
Below Query will help you read live file level Disk read and write information. WIll behandy for performance tuning capacity planning. select db.name,files.filename,* from sys.dm_io_virtual_file_stats(NULL,…
Once we had an issue in our environment. We had a maintenance activity on the Database server during a weekend and the server was shutdown…
Issue It’s quite common that we use detach-attach method to migrated SQL server databases from Windows Server 2000 or 2003 to Windows server 2008. During…
Issue Soon after installing reporting services for my SQL server 2012 on Windows 7, I got the error “User ‘DOMAIN\username’ does not have required permissions. Verify that sufficient…
I had a terrible issue with my wordpress website www.sherbaz.com. I was unable to submit any post for a long time because of this issue.…
Questions Explain SQL Server Failover Clustering? How do we check index Fragmentation? TSQL syntax for Index rebuild and reorg. Difference between the two. How users…
The Attached SQL Query can be safely used for rebuilding or reorganizing all indexes in a particular database based on the fragmentation level. Note: The…
Run below Query. And once the query executes completely, go through the SQL Server Error log to see the results. declare databases cursor for select…
Command: xp_readerrorlog parameter 1, parameter 2, parameter 3, parameter 4 Parameter 1: To specify the errorlog number. Starts from 0. 0 = current, 1 =…
You must be logged in to post a comment.