Home » SQL Server (Page 50)
Category Archives: SQL Server
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
Check List for SQL Server Connectivity Issue !
SQL Server connectivity is the most common issue & below mention errors is also common at time of connectivity issue. Error : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server … Continue reading