Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "sql server 2000"

4

Getting file size, space used and space free information for a SQL Server database

Sometimes you want to quickly see how many files a database has, how much space a file is using and how much space is free. You can use the sysfiles/sys.files views or compatible views for that. From SQL Server 2005 onward you can also use the sys.datab…

Read More...
2

SQL Server Support Windows Phone App released

A SQL Server Support Windows Phone App has been released to the store. This app will work on Windows Phone 7 as well as Windows Phone 8

Description from the site

Get quick access to SQL Server and SQL Azure troubleshooting content from Microsof…

Read More...
0

Getting the tables with the most rows from your database

Sometimes you want to quickly see what tables have the most rows in your database. This is especially rue if you inherited a new database and you want to know some stats about this database. Instead of doing a count(*) against every table, I usually just use the sp_spaceused stored procedure. this will run many times faster, usually it is instantaneous.

Read More...
0

Listing all your SQL Server databases ordered by size

To see all the databases with their size on an instance, you can use sp_helpdb. That works but returns the results in some random order. In my case I see master, model and
msdb followed by a couple of user database, then tempdb and then again some user…

Read More...
8

Getting the biggest tables in your SQL Server database

Sometimes you want to quickly see what the biggest tables are in your database. Maybe someone just gave you a brand new database and you want to see which tables take up the most space. I usually use the sp_spaceused stored procedure, it runs quickly and gives me the data that I need. Just be aware of these remarks

Read More...
4

SQL Advent 2012, here is what is coming

I decided to do a SQL Advent series of posts this year as well, this year I will focus on best practices. In case you are interested in last year’s posts, all of them are listed here: SQL Advent 2011 Recap

Here is what the preliminary 25 posts will l…

Read More...
1

How to search for data with underscores or brackets in SQL Server?

You can search for data in your tables by using the LIKE operator. The LIKE operator determines whether a specific character string matches a specified pattern. A pattern can include regular characters and wildcard characters.

Here is what Book On Li…

Read More...
0

You don’t need to shrink a database to get a smaller backup

Last weekend I decided to do some maintenance on one of our database to see if I can get some freespace back. I use compression for some of the older tables and also reindexed the tables with a higher fill factor. After I was done, I got over 200 GB of…

Read More...
3

Difference between a cross join and a full outer join

We are interviewing for some SQL developer positions and it seems that most people that I interviewed do not know the difference between a full outer join and a cross join.

Cross join
A cross join produces the Cartesian product of the tables involv…

Read More...
0

SQL Advent 2011 Recap

Here is a recap of all the 24 SQL Advent 2011 posts
Day 1: Date and time
In this post I covered the new date, datetime2 and time datatypes

Day 2: System tables and catalog views
In this post we took a look what the replacements are for the all s…

Read More...
« Previous PageNext Page »