-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
This is a handy script to pull info related to CPU and Memory. SELECT cpu_count AS [Logical CPUs] ,cpu_count / hyperthread_ratio AS [Physical CPUs] ,physical_memory_in_bytes / 1048576 AS ‘mem_MB’ ,virtual_memory_in_bytes…
Recently I observed an issue where we were trying to shrink a database file [Shrinking is not recommended in Production environment as it will cause fragmentation] and SQL Server was…
You might have encountered an issue where SQL Server setup will be in hung state during ‘Setting File Security’ phase.This is a known issue and is documented by Microsoft :…
Today I learned about the command line features available for SSMS.You can use these features as per your requirement and this will really improve your productivity :
The paths to SQL Server Agent subsystem DLL’s are stored in table msdb.dbo.syssubsystems, hence when you do a restore of MSDB database you have to follow the below process to…
Have you got the habbit of doing RDP to the server and launch tools like SSMS and run scripts ? If your answers is ‘YES’,then it would be good to…
Lets start the month with some best practice’s. Microsoft® SQL Server® 2008 R2 Best Practices Analyzer will allow you to scan your sql server instance and will report potential issues.There is…
Cloud & SQLSailor 