SQL Server 2012 CU3 Is Now Available !
The 3rd cumulative update release for SQL Server 2012 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the SQL Server 2012 hotfixes which have been available since the initial release of SQL Server 2012. This update contains hotfixes for issues that were fixed after the release of SQL … Continue reading
How to avoid windows REBOOT after any operation required restart ?
Issue : Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different names & versions, that I have created for different purpose & not required now. I start uninstallation of SQL server but after one uninstallation, second uninstallation gives errors of “Restart Computer”. It’s very difficult … Continue reading
Is Instance name SQLEXPRESS is fixed for Express edition only ?
A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide to test it. First I have tried to install SQL server Evolution Enterprise edition with instance name “SQLEXPRESS” & it worked. Now I tried to install SQL Server Express edition & It allows me … Continue reading
ReFS || next generation file system for Windows
Q) Why is it named ReFS? ReFS stands for Resilient File System. Although it is designed to be better in many dimensions, resiliency stands out as one of its most prominent features. It will come with Windows 8. Q) What are the capacity limits of ReFS? The table below shows the capacity limits of the … Continue reading
SQL Server 2000 || DBCC CHECKDB logs entried in T-log file
Issue : When running DBCC CHECKDB on SQL server 2000, We are facing t-log growth & blocking. Cause : DBCC CHECKDB does block in 2000 and earlier. The code for DBCC in 2000 was complex since it was working against a moving target (the database being modified), so to have a consistent database to check, … Continue reading