I'm curious why SIMPLE mode. It's usually a bad idea.

As far as specs, it's hard to know unless you know what SQL is being run. One person on the box,...

I agree with Lynn. A SELECT might blog an insert/update/delete from committing, but that doesn't mean more log records. The SELECT is not logged.

I can start a tran, do...

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