It depends on your system, the business requirements, the types of transactions... There's no one right answer. I manage systems that if I saw blocks going past 10 seconds I'd...

That's a huge topic and one that you're unlikely to get a complete answer in a post like this. First question, slow as compared to what? From what you're saying,...

I'm not logged in from home, putting in extra time, working on extra projects and especially I'm not cruising the boards at SSC... CRAP!

You guys are all getting about 20 people per meeting. We're getting ready to start our fourth year and still only have about 10 per. It's tough.

Roy Ernest (8/28/2009)

---

Just wanted to let you all know that we had our first Pass Chapter meeting yesterday Yea...!!!. It went fine...:-) We had more people than I expected. I...

Not yet. They must know who the nice people are.

Steve S (8/28/2009)

---

The data is read-only to the users. The only thing that updates the data is the daily data load we do.

I was thinking about an 'Active\Active' clustering...

I'm sure the article will kick up more mud. Interestly enough, most of the Agile projects at my company have failed. The constant redesigns and refactoring was leading to little...

Try this instead:

SELECT *

FROM table1

WHERE SomeDate BETWEEN CAST('2009-01-01 00:00:00' AS...

Lowell (8/27/2009)

---

Grant Fritchey, who contributes a ton of time helping people here on SSC wrote a couple of ebooks that you can download for free right here on SSC:

SQL...

I'd recommend the Inside SQL Server series. You'll be hard pressed to find better information. Specifically I'd suggest getting "T-SQL Querying" by Itzik Ben-Gan, "The Storage Engine" by Kalen Delaney...

We've been doing an A/B switch with a database rename. Downtime is measured in seconds, but it's absolutely there. I'm not aware of a way to do this without impact...

j.bradshaw (8/27/2009)

---

Still no data. The mapping seems fine. Script is there. But can't see anything in a Performance view. Then I thought i would take a look at what the...

I would suggest using the dynamic management view sys.dm_tran_locks. That will show what is locking, the type of locks, the session holding the lock... You get the idea.

Oops. I forgot to add a link to the blog.

Here it is.[/url]