Microsoft’s SQL Server 2012 (AKA SQL Server code-name ‘Denali’), new details have been released http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx. 1. What is new in SQL Server 2012? SQL Server 2012 will provide Mission Critical Confidence with greater uptime, blazing-fast performance and enhanced security for mission critical workloads; Breakthrough Insight with managed self-service data exploration and stunning interactive data visualization capabilities; Cloud On Your Terms by enabling the creation and extension of solutions across on-premises and public cloud. The main editions of SQL Server 2012 with licensing & pricing model are: Enterprise – $ 6,874 (Per core) Business Intelligence – $ 8,592 (Per server) Standard – $ 6,874 (Per core) $ 898 (Per…
-
-
SQL server could not start cannot find object or property (0x80092004)
SQL server could not start cannot find object or property (0x80092004) Recently I got a call from my team the users couldn’t connect the SQL server and it’s throwing error. As always, I checked the SQL server status via configuration manager and noticed the server 2008 r2 stopped. I tried to start the SQL server but it’s not started and its shows could not start the service. I went to the application log it has so many error messages. Event viewer Errors: Could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems. Could not start the network…
-
AWE has removed from SQL server 2012
AWE has removed from SQL server 2012 AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit servers. To use more than 4GB memory you have to buy 64 bit servers. A small organization may suffer because of this feature has removed from the next version. For more look the following links SQLOS Team’s post : SQL Server Memory Manager Changes in Denali http://sqlblog.com/blogs/sqlos_team/archive/2011/01/04/sql-server-memory-manager-changes-in-denali.aspx MS’s post : Features Not Supported in the Next Version of SQL Server http://msdn.microsoft.com/en-us/library/ms143729.aspx
-
SQL server 2012 Denali not starting there is insufficient memory available in the buffer pool
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…