Group by Date without Time in MSSQL

Have you ever tried counting your data per day. Lets say you have a customer service Database and you want to query all the days and how many customer service request did you get per day. If you already know the GROUP BY function then you already have an idea on how to do it. [...]

How to query table sizes of a DB in MSSQL 2005

Part of my job is to make sure that our database is optimized all the time. Sometimes you need to actually take a look of which tables in the database are causing the slow downs. This query will list all the tables of your DB as well as the number of records it has, size [...]