Determine Tables Sizes in SQL Server

Everyone is worried about their database size. Even though storage is relatively cheap, if your database is growing linearly or exponentially, you’re going to run into issues down the road. One quick way to check things out is to look at your table sizes. I looked all over the web and found Mitch Sellers’ blog with several great SQL Table Size scripts. Here are 2 of the good ones from the comments: EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?'” This method is quick, but not very clean. You’ll get a separate result for each table, so you really cannot sort. Plus, I … Continue reading Determine Tables Sizes in SQL Server

Using Windows Media Center on a Dual Screen Setup with Windows 7 x64

If your PC came with Windows 7, chances are you already have Windows Media Center installed. Some PCs come with a built in TV tuner, or you can get an external TV tuner at a reasonable price at your favorite store. One of the neat things about having a TV tuner on your machine is is having the ability to watch live or recorded TV right on your machine via Windows Media Center. Of course, when you’re working on something else, you’re going to have to cover the TV image. Of course, when you have a multi monitor setup, you … Continue reading Using Windows Media Center on a Dual Screen Setup with Windows 7 x64

Querying an Oracle linked server fails

The other day, I needed to pull some data from an Oracle server on our network. The oracle server was set up as a linked server on my SQL Server 2005 machine. For some reason, the query didn’t work. Now, when working with an oracle linked server, you have to include the linked server name, the schema name and the table name. Also, you can use an alias just like any SQL Server table. But, the key thing is to include the schema and table name. The query looks something like this: select col1 from [OracleServer]..[schema_name].[table_name] For some reason, the … Continue reading Querying an Oracle linked server fails