Monthly Archives: August 2012

How to crawl a quarter billion webpages in 40 hours | DDI

http://www.michaelnielsen.org/ddi/how-to-crawl-a-quarter-billion-webpages-in-40-hours/

Posted in SQL Server | Tagged | Comments Off on How to crawl a quarter billion webpages in 40 hours | DDI

Psuedodynamic sql

Posted in SQL Server | Tagged | Comments Off on Psuedodynamic sql

Psuedo dynamic sql

Posted in SQL Server | Tagged | Comments Off on Psuedo dynamic sql

Access Data Project on Windows 8 are -FAST-

Wow, I don’t know how Microsoft did it.. but Access Data Projects are FAST on Windows 8.. I can’t believe how much faster they are.

Posted in SQL Server | Tagged | 3 Comments

Improving Performance with SQL Server Indexed Views

Improving Performance with SQL Server 2008 Indexed Views SQL Server 2008 31 out of 54 rated this helpful – Rate this topic   SQL Server Technical Article   Writers: Eric Hanson, Susan Price Contributors: Gail Erickson, Lubor Kollar, Jason Ward … Continue reading

Posted in SQL Server | Tagged | 1 Comment

Office Store is open!

This is sad though.. I’m sure that Microsoft will focus on Powerpoint, Word, Excel.. and Ignore the best product in the MS Office suite– Microsoft Access rocks! http://www.zdnet.com/microsoft-opens-the-office-stores-doors-7000002257/

Posted in Access, SQL Server | Tagged | Comments Off on Office Store is open!

Database Tuning Advisor bug

I love the ability to profile SQL Server activity and then run the database tuning advisor. Unfortunately, sometimes I start this DTA advisor, and I let it run for a day, and it doesn’t complete.  Often, when I kill DTA in … Continue reading

Posted in SQL Server | Tagged | Comments Off on Database Tuning Advisor bug

Can Windows 2012 Server ReFS benefit the SQL OLTP workload? : Database

http://www.reddit.com/r/Database/comments/xp0oo/can_windows_2012_server_refs_benefit_the_sql_oltp/?sort=confidence

Posted in SQL Server | Tagged | Comments Off on Can Windows 2012 Server ReFS benefit the SQL OLTP workload? : Database

Entity Framework – 5200 lines of code in generated SQL

I’ve never understood the point of objects. If procedural code is FASTER then what is the point? I’ve also never understood the point of ORM mapping software. ANYTHING that generates 5200 line queries should be thrown onto the trash heap. … Continue reading

Posted in SQL Server | Tagged | Comments Off on Entity Framework – 5200 lines of code in generated SQL