I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

July 2009 Blog Posts

SQL Server 2005 – Fast Running Totals solution with ordered CTE update?

The Running Totals problem is as old as accounting. In SQL Server there are different ways of calculating it and the general consensus is that it is one of the few problems best handled with a cursor. I still say it’s best handled in the presentation layer though. Being the SQL geek I am I can’t accept a problem in SQL Server which has a cursor for a solution (just kidding). Note that I didn’t put any indexes on the tables so we can’t rely on them for any kind of ordering. The base table...

posted @ Tuesday, July 28, 2009 11:48 AM | Feedback (16) | Filed Under [ SQL Server ]

How to check when was SQL Server installed with a T-SQL query

Today on twitter Lori Edwards (@loriedwards) asked how can you check when was SQL Server installed with a T-SQL query. Otherwise this is pretty simple by looking at the creation time of master database (provided you never had to restore it). But i wanted to find a nice way of doing this without resorting to any xp_ stored procedures. Of course this is possible by looking into the sys.syslogins compatibility view: SELECT createdate as Sql_Server_Install_Date FROM sys.syslogins where sid = 0x010100000000000512000000 -- language neutral ...

posted @ Thursday, July 16, 2009 6:55 PM | Feedback (4) | Filed Under [ SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET