That should install on Windows XP, vista and all other desktop versions of windows. You just need to install the server components. When you get to the feature selection, make...

If you want your own server then you need to install the server components of SQL as well as the client. The client tools are just interfaces to work with...

If you only installed the client tools, there won't be a local server. It may be the default that SQL brings up, it's assuming that you installed a local server,...

I haven't got too much on my schedule next week. I'm sure I can find a couple hours.

I think...

Not in an inner join. In an outer they may produce different results

Bru Medishetty (12/4/2009)

---

Alvin Ramard (12/4/2009)

---

Bru Medishetty (12/4/2009)

---

I am not sure what did he mean by this

Does SQL Server supports any...

Do you really need dynamic SQL? Your question indicated there were two possibilities - the detailed and the high level report. If that's the case, use if - else with...

Why is this urgent?

http://sqlinthewild.co.za/index.php/2009/11/24/the-most-optimal-join-type/

http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/

As I said, the buffer cache (usually called the buffer pool) is divided into the data cache and the...

SQL's not stupid enough to store a column...

Got any options checked in the maintenance plan?

What's the server (and IO) load at the two times?

Now that I read it again, it's a 2-for-1.

When did replication gain a failover...

Dave Mason (12/4/2009)

---

[font="Arial"]I prefer to avoid the IF/ELSE scenario for queries. Eventually, you'll have to "fix it" in two places. Plus, you open up the possibility of two...

Not helped by someone who doesn't appear to know the difference between an operating system kill process and a SQL...

Atul DBA (12/4/2009)

---

I am not sure about you OS. You can use the /F option with KILL command to make it forcefully kill the process. If you have TaskKill utility...