Category Archives: Database

Fastest way to Count Millions of Rows in an Extremely Large Table

SELECT COUNT(*) from tableName can take lot of minutes to execute row count information   but if we use this query then it would take hardly 1-2 seconds to return row counts even if the table has millions of rows. SELECT¬†SUM(st.row_count) FROM sys.dm_db_partition_stats st WHERE object_name(object_id) = ‘HugeTable’   Try it ūüôā Note: sys.dm_db_partition_stats : […]

Continue Reading...

Free Microsoft SQL Server Tools

Management Studio Alternatives and Add-ons Microsoft SQL Server Management Studio Express¬†– This is MSDE replacement and is FREE, use it also to manage your SQL 2000 boxes in one interface. SSMS Tools Pack –¬†http://www.ssmstoolspack.com¬†– Lots of SSMS enhancements, Highly Recommended and Express compatible too! Quest TOAD¬†– Free version has debug capability I am told.¬†MySQL Version¬†available […]

Continue Reading...

Third Party SQL Profiler for Microsoft SQL Server 2005/2008 Express Edition

SQL Server 2005/2008 Express Profiler Microsoft SQL Server family includes free Express edition, that is fully functional, however has some disappointing limitations which prevent from using it in development process. One of them is absense of profiling tools, standard SQL profiler is not included. However, now you have an ability to use express edition for […]

Continue Reading...

Alternatives to Microsoft’s SQL Server Management Studio

¬†1.) ¬† ¬†LINQPad¬†¬† ¬† ¬†Tired of querying in antiquated SQL?   Well, you don’t have to!¬† LINQPad lets you interactively query databases in a modern query language: LINQ.¬† Kiss goodbye to SQL Management Studio! LINQPad supports everything in C# 4.0 and Framework 4.0: LINQ to Objects LINQ to SQL and Entity Framework LINQ to XML […]

Continue Reading...
www.000webhost.com