Monthly Archives: May 2013

union vs or clause

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on union vs or clause

increase the retention for SQLAgent

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  

Posted in SQL Server | Tagged | Comments Off on increase the retention for SQLAgent

create view syntax(column1, column2, column3)

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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on create view syntax(column1, column2, column3)

Power View for Cubes

  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 … Continue reading

Posted in SQL Server | Tagged | Comments Off on Power View for Cubes

SQL Express on Windows 8 isn't locking MDF database files

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?  

Posted in SQL Server | Tagged | Comments Off on SQL Express on Windows 8 isn't locking MDF database files

LightSwitch HTML Client Runtime Updated

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 … Continue reading

Posted in Web Development | Tagged , , , | Comments Off on LightSwitch HTML Client Runtime Updated

Was Dijkstra wrong? Is GOTO good for novice programmers?

.. 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, … Continue reading

Posted in SQL Server | Tagged | Comments Off on Was Dijkstra wrong? Is GOTO good for novice programmers?