I bet many of SQL developers have attempted or have written SQL code like this: select a.* from tblA a join tblB b on a.DiscoverySerialNo = b.SerialNo or a.DiscoverySerialNo = b.DiscSerialNo You must have noticed that code like this takes longer than usual, or even worse, never returns result. I haven’t analyze this so cannot […]
increase the retention for SQLAgent by default it clears history after 100 lines or something dumb USE [msdb] GO EXEC [dbo].[sp_set_sqlagent_properties] @jobhistory_max_rows=10000, @jobhistory_max_rows_per_job=1000 GO
I’ll be the first person to admit- I’ve ALWAYS been a huge fan of views (instead of sprocs) because they really make things EASIER. I’ve originally read about the importance of using views 12 years ago when I was playing around with Analysis Services. I’m starting to finally use this notation- I wish I had […]
Power View for Cubes By Ivan Paniagua, 2013/05/21 In this article I will evaluate the latest functionality provided by Microsoft SQL Server 2012 – Power View for Multidimensional Models. This SQL Server 2012 Community Technology Preview (CTP) release allows connections between Power View and Multidimensional Models (cubes), in addition to the Tabular Models […]
SQL Express on Windows 8 isn’t locking MDF database files http://dba.stackexchange.com/q/37566?atw=1 #sqlserver I still cannot believe that this is true. How can we get someone at Microsoft to verify that this is the intended behavior?
Microsoft has updated the HTML client runtime in LightSwitch, its lightweight Web development tool. “Runtime Update 1”, as it’s called, is a bug and compatibility fix for the latest versions of jQuery, jQueryMobile and datajs. The update adds support for jQueryMobile 1.3 and jQuery 1.9, according to this blog posting from the LightSwitch team. “Embracing the mobile-first, […]
.. programming education .. may by chance have thrown the baby out with the bathwater, just as the reform maths educators did with calculators in schools. In the old days, before calculators, children had to learn to do long multiplication, for example 431 × 27, using pencil and paper. This was a bit of a chore, now […]