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 2005"

0

Listing all RESTORE and BACKUP operations currently going on your SQL Server

Sometimes you want to quickly see if there are any databases or logs being backed up or restored at this moment. I blogged at one point how you can check how much longer the restore will take here: How much longer will the SQL Server database restore ta…

Read More...
9

BULK INSERT data where the row terminator is a linefeed in SQL Server

I like to use BULK INSERT or bcp as much as possible, this is especially true if all I need to do is dump the file into a table. For more complex things I will go the SSIS route. Files are generated by all kinds of systems these days, these can be Windo…

Read More...
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...
4

Discovering new things (for me) in SSMS

One of the good things about working in technology is that you always will discover new things. The other day I created a blog post: Listing all your SQL Server databases ordered by size. Buck Woody replied to me on twitter that this is also built into…

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...
9

Setting up SQL Server Database Mail with gmail

If you want to mess around with Database Mail from your laptop and you don’t have a mail server, you can configure gmail for that purpose. It is pretty easy to setup, I will show you the screen from the wizard as well how to do it in T-SQL. I prefer T-SQL because I can run the same setup now on multiple machines

Read More...
3

Use the sys.database_mirroring DMV to quickly check if the databases are in principal or mirror role and what state they are in

I have been using mirroring for about three years now and I must say it is one of the best features that have been added to SQL Server. We used to do plain old replication and log shipping in the past but almost all of those have been replaced by mirror…

Read More...
« Previous PageNext Page »