by David | Feb 4, 2013 | Database, Development
Seems there´s still some issues you have to struggle with in Entity Framework even though the latest releases have made it actually possible to work with. This time I got a problem whilst trying to retreive av bunch of items logged with the same timestamp. Entity...
by David | Dec 7, 2012 | Database, Performance
Stuck without writing rights in a big database? Only allowed to dbo_reader?Then this baby is for you: DECLARE @myTable AS TABLE (rowid int, name varchar) This neat little row can be used instead of temp-tables to store subsets of data to increase the performance of...
by David | Dec 7, 2012 | Database, Performance, Statistics
When using large databases it might be interesting to keep an eye out on what of your tables that actually consumes all that disk. There´s a lot of resources on this out there but I thought I´d repeat it anyways since its such a neat little thing: EXEC...
by David | Aug 22, 2012 | Database, Development, Performance, Statistics
Gudday! These days I´m doing a lot of low-level performance testing and sooner or later you always end up checking your code performance against the database performance and this time I was chasing milliseconds. So, here I am with some SQL wanting to check exactly how...
by David | Jul 31, 2012 | Database, Debugging, Deployment, Performance, Statistics
Hi, I know this information is spread around the web a bit here and a bit there so I´m just adding already existing content but I need to save this somewhere I can find it again so here it goes. It´s a pain trying to look through or get statistics from IIS using the...
by David | Mar 5, 2012 | Database
Thought I´d inform about a nice little procedure I found today. I failed to remove a database since there were still users connected. Obviously, I was the one keeping a connection but that doesn’t mean I know where I´m keeping that open connection 🙂 Just run...
