What is Statistic in Sql Server Part - 3
Yes ! Auto update stats causing Performance issues??
What is Statistic in Sql Server Part - 1
What is Statistic in Sql Server Part - 2
What is Statistic in Sql Server Part - 2
Interview Question : Does sp_updatestats update the statistics of a table if I just run it or does it use specific formula??
What is Statistic in Sql Server Part - 1
What is Statistic in Sql Server Part - 3
SQL Server Installation Add Features is not Showing All Instances
Today we get a request to install SQL server reporting services for 4 of 8 of the instances on a server.
As usual we pick our sql 2012 dump and start installing. When we reached to Add feature page of installation we were not able to see 4 of 8 instances in drop down as in screen shot
As usual we pick our sql 2012 dump and start installing. When we reached to Add feature page of installation we were not able to see 4 of 8 instances in drop down as in screen shot
Windows update can't check for updates because the service is not running
Patching does have its own issues, hard to predict
This time I was doing windows updates
Control panel --> System and security --> Windows update -->check for updates
This time I was doing windows updates
Control panel --> System and security --> Windows update -->check for updates
The image file is valid , but is for a machine type other than the current machine
While patching SQL server 2005 SP1 to SP2, we face below error
Error: The image file is valid , but is for a machine type other than the current machine
This error clearly states that patch file is good, the issue is with my machines
SQL Server System Databases
Many people does know about system databases but no one remembers detailed version and get confuse in tricky questions. So I have put this in points
Master Database :
Script to find sql server version on multiple instances using Power shell
Script to find sql server version on
multiple instances using Power shell
Subscribe to:
Posts (Atom)