This is a symptom of the bigger problem, which is that SQL Server...

I agree with the line "The more we understand each other and our respective responsibilities, the less friction we'll have because of these tendencies.", if that is meant to imply...

I also have concern with the line "IT staff may misinterpret the lack of technical knowledge among their creative right-brain colleagues as a lack of intelligence." but for a different...

I've been through the "what is a DBA?" question many times in my career. Personally I tend to think of a DBA as the production DBA, who's responsibility is...

As others have said, the CPU seldom is the bottleneck in a database server. The only interesting thing to me about newwer processors is the tendancy toward more efficiency....

Matt said it...

bob.willsie (9/10/2009)

---

...I typically write a string of queries that extract small chunks from the server and store them locally, then merge, extrapolate, etc. locally. I found this executes much...

bob.willsie (9/10/2009)

---

...I have read several SQL related posts that pretty much state "never allow anyone to connect to a SQL server using MS Access and ODBC.

However, I have never seen...

I always liked the abstraction of using a DSN from the actual connection that ODBC provides, and that you could easily deploy a DSN to a client computer in a...

mohaiv (9/8/2009)

---

I don't belive it...

The server can use index when the first part of the index is in the where clause.

I try it and MS SQL server realy use index...

I do have a home "server" with RAID mirroring, but it's not Windows server, it's running Ubuntu 8.04 and using Samba to create network shared resources that my Windows PCs...

I'd have to agree with being skeptical about new revolutionary ideas. Besides being rehashed old ideas, or just passing fads that won't necessarily catch on, from what I've seen...

I think the 30% of us (me included) that got it wrong just need to make sure we get our morning caffiene before trying to answer the questions 😉

DUMP is a desupported feature, and Microsoft plans on removing it, why would anyone be wanting to learn this now?

... but...