Tag Archives: SQL Server

Data Transformation Quirk

In SSIS when creating a Data Flow Task, you’ll usually want to have a destination for your data. From everything I’ve read, if your package is running on the same server as your destination, you’ll want to use SQL Server … Continue reading

Posted in 2008, SQL Server, SSIS | Tagged , , | Leave a comment

Intellisense

Adding Intellisense to SQL Server Management Studio is a wonderful improvement. If you’ve used Visual Studio, you know what Intellisense is. For everyone else, Intellisense checks what you’re typing and gives you suggestions of valid options based on context. It … Continue reading

Posted in SQL Server 2008 | Tagged , , , | Leave a comment

Aliases

Aliases seems to be something people don’t think much about. They learn that you can call a table or a column something else for reference elsewhere in your query and they go about using it. Sure, sometimes they can’t understand … Continue reading

Posted in 2008, SQL Server | Tagged , , , | 2 Comments

How much data is there?

We’re all familiar with trying to figure out just how much data is in our database. To get approximately how much memory the whole database takes up you can open SQL Server Management Studio, right-click on the database name you’re … Continue reading

Posted in 2008, SQL Server | Tagged , , | Leave a comment

Set Statistics

Any time you’re developing queries in SQL Server, whether they’re single use or intended for inclusion in a stored procedure that’ll be run frequently, you want to know how well your query is running. If it is intended for production, … Continue reading

Posted in 2008, SQL Server | Tagged , , , | Leave a comment

The Best Feature

The best way to learn a programming language, environment or database system is to use it. If you have the chance to play with it, everything you read in the books and on-line about it will make more sense. You’ll … Continue reading

Posted in 2008, SQL Server, Visual Studio | Tagged , , | Leave a comment

Indexes

Never underestimate what the right index can do for you. I was running a query that limited results by an integer representing a date range and it was taking around 37 minutes to run. I didn’t think it all that … Continue reading

Posted in 2008, SQL Server | Tagged , | Leave a comment

Odd bug

This blog won’t all be bugs, but they’re foremost in my mind right now. I’m fortunate to be on a job right now where I get to use the latest software. We have SQL Server 2008 R2 installed on our … Continue reading

Posted in 2008, SQL Server | Tagged , | Leave a comment

Installing SQL Server 2008

Last year I was starting a new contract and needed to install SQL Server 2008 on the machine they’d provided me. This was a machine that had been used by someone before and instead of reimaging it, they just uninstalled … Continue reading

Posted in 2008, SQL Server | Tagged , | Leave a comment