Get lots of memory, and fast I/O. Beyond that, you need to examine code carefully and test. I'm not sure we can give you general tips without more details, or...

What doesn't work for you? Have you checked out FineBuild for SQL Server (http://www.codeplex.com/SQLServerFineBuild/)?

SSIS doesnt' connect to anything. The packages have connection strings. You can possibly set up an alias and aim it for 1433, or an FQDN in DNS and then point...

What advice would you like? What are you confused about? There are companies using Teradata, lots more using SQL Server.

It's not a good or bad move, it's a "what do...

Likely it's a Powershell add-in issue. I'll see if I can get some visibility to this.

I typically would look for INSIDE SQL SERVER for the best explanation of how this works. It seems to me that there was good information in there on how the...

Likely there is no one answer for how to fix this.

Connect is the place to raise this, and then post a link here, on your blog, etc. Try to get...

You could use a series of CTEs to help you. Each one could contain a query that you've written and then join them. This is a good CTE intro: Common...

What do you mean, in terms of SSRS actually providing data? The SQLSaturday site uses it in places, but it's for the admin side.

Most places that seem to use it...

Only changes are logged in the transaction log. A SELECT will not cause problems in the transaction log. It could cause tempdb issues, and possible tempdb log problems, but not...

I think we'd like to help you, but you can't post a hundred lines of SQL and expect a lot.

Strip down the code to the begins and commits for...

As with any generalization, it's only true some of the time.

We are all people. However are are also unique, and we each tend to do certain things, tendencies, leanings, etc....

I'm one of those that does think everyone should learn a low level language. I'm not sure I'd say assembler, but I think everyone should still have to spend some...

Excellent, Bob. Be sure to say "hi" when you're there, register with SSC3D and come to the Mon night party.

These events are setup and run by local people in each area. Ask your local user groups, and volunteer to help.

We will try to send someone to speak and...