I'd suggest getting a copy of the book "Microsoft SQL Server 2008 Internals" by Kalen Delaney. This is a huge topic, as was already noted, and just can't possibly be...

Just adding another thought...

Most app developers that need to support multiple platforms are taking advantage of ORM tools like Hibernate, nHibernate, LINQ, Entity Framework, etc., to perform the work for...

I'm with Paul, obviously it would be better to have multiple machines, but if you can't, multiple instances will at least simulate the results. This way you avoid the issue...

Even though both operators have the word SCAN in them, there is no real comparison between a Constant Scan and an Index/Cluster/Table Scan.

Usually, but not always, an Index/Cluster/Table Scan is...

It really depends on the situation, but for most of us, no, this is a waste of time & effort. I've been working for a company for almost nine years....

The best way to deal with sudden issues on the database is to prepare beforehand. Know how to look for contention. Know how to look at the processses that are...

I've honestly never tried it that way, so I'm not sure where to go. If you know which procedure is giving your problems, I just work with it on my...

Traditionally it's considered bad form to hijack someone elses question. Also, when you do this, the only people that are aware of the new question are those that are already...

It really depends on what the error is. Not all errors cause a loss of connection, so you'll still see the RPC or Batch completion event.

Profiler isn't necessarily the place...

You can make the data file any size you want, but then it will consist mostly of free space. Right click the database and check the properties. That's an easy...

NOLOCK is what is known as dirty reads. It prevents shared locks from being placed on data. This can speed up access. BUT, it also means that you can get...

If the calculation is really simple, say adding two columns, then no, storing it doesn't really make sense, but if the calculation is complicated, then it makes more sense to...

rafael_si (5/20/2010)

---

Thanks a lot for you reply. I was thinking that "schemabinding" had something to do with index use becase I can't create an cluster index (sql server 2005) without...

mtassin (5/20/2010)

---

Grant Fritchey (5/20/2010)

---

I'm sorry to disagree with you here, but dynamic queries do get cached. And if you build them using the parameterized approach, they can get reused too....

It depends on the query and your goal. SCHEMA_BINDING and indexed views are different critters. An indexed view is, effectively, a second table because the query that defines it is...