Very cool, and I must ask, did you do this for fun? 😀 Pretty amazing. The more I learn the more I feel there's so much out there...

Hard to maintain it's really not an option when it comes to working with databases, you got to do what you got to do. Data entered by users can...

This is the script I use to rebuild/reorganized my indexes. Again modify when needed.

/*

Script copied from http://msdn.microsoft.com/en-us/library/ms188917.aspx

and modified to fit our environment

CHECK FOLLOWING TO MAKE SURE THE...

Try the script below to find out the fragmentation information. Hope it's a good start. Modified the values to fit the specs in your environment.

/*

Display statistics for...

Have you considered replication? That might be an option.

That would work if all you had was the date in different formats. However, the main purpose that I had to write the scripts was because we have a...

Are you trying to do something like this?

Select ROW_NUMBER() OVER(ORDER BY FirstName, LastName) AS RowNumber, FirstName, LastName

Output

RowNumber FirstName ...

This article is very easy to follow, I have one "small" problem though. I have to problems setting up my server (which I'm testing using just that one server...

Thank you for your time. I hate for you to waste it like this.

Duuhhh!!! You were right, once I figured out what it was it all made sense. Well, we do use some of the red gate software products, especially red gate...

Thank you. I'll make sure to post an answer if I ever figure this out.

Just tried something here and it's still very weird. Since my PC's name is hard to remember I created an alias for the SQL Server instance. So when...

We have a site license so it's only new to this machine, would that count? This is a brand new machine and new installation, the intellisense used to...

This is a brand new installation, both SQL Server 2008 R2 and SSMS are on the same machine. The only database right now that I have on this system...

I apologize for leaving out the main point of my question. Intellisense is not working in MS SQL Server Management Studio.