SQL server 2012 does not start Today is not a good day. Ha ha not like that 🙂 Usual I opened SQL server DENALI to play something it doesn’t open (start) it at all. It’s throwing error. Probably you know what I will do I went configuration manager checked the service is started or not. It shows stopped. I tried to start the server but, it’s not start it. I checked the event viewer log and the SQL error log I got lots of error. Event viewer logs: The SQL Server (SQL2011) service terminated with service-specific error %%945. There is insufficient memory available in the buffer pool. SQL server error…
-
-
Merge join Vs Hash join Vs Nested loop join
 This month’s TSQL Tuesday party is being hosted by Stuart R Ainsworth (Blog| Twitter). I am very glad to write my first blog post as t-SQL Tuesday post on my newly designed website. SQL server has three types of internal joins. I know most of folks never heard this join type because it’s not logical join and it’s not often used in their codes. Then, when it will be used? Well the answer is “it depends”. This means it depends upon the record sets and indexes. The query optimizer will be smart and always try to pick up the most optimal physical joins. As we know SQL optimizer creates…
-
SQL Server 2008 SP2 cumulative update 9
SQL Server 2008 latest cumulative updates 9 build 10.50.1804 available now. You may download and test it Cumulative Update 9 for SQL Server 2008.
-
SQL Server Denali CTP3 Download
Microsoft has given the SQL Server Denali CTP3 (Community Technology Preview)  for public preview. You can download the SQL Server Denali CTP3 here. http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx I’m very interested to see the SQL Server Denali new Features.
-
SQL Server 2008 SP2 cumulative update 5
SQL Server 2008Â SP2 10.50.2418.0 latest cumulative update 5 available now. You may download and test it. Cumulative Update 5 for SQL Server 2008 Service Pack 2 http://support.microsoft.com/kb/2555408