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…
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 =…
Did you come across any situation where you wanted to make sure that the password you set for a SQL account is what you really…
SOLUTION: 1) Go to MSDB– Security –Users — UserName — User Name Properties — Assigned the ‘TargetServerRole’ in msdb 2) Run the query select pr.name,…
You must be logged in to post a comment.