I have to agree with Nigel on this one: it is a good thing for a DBA to be a control freak. It's not unusual for performance issues to...

quote:

---

For other professions, doctors, lawyers, accountants and engineers, the certification is statutory. That is, the government, usually states, manage the certification. With...

Reaching here as well, but you said you tried a batch command and it failed... Can you successfully run xp_cmdshell from say Query Analyzer? Something simple such as a...

What version and service pack is your SQL Server? I'm assuming when you say you upgraded Enterprise Manager, you're speaking of a client system.

Also, under what set of client...

I'm in the same boat as Steve. Have my MCSE, but haven't had the time to work towards the MCDBA. Good thing Microsoft decided to keep NT 4.0...

It's not the db, but the firewall/router where the access needs to be configured. Basically, an access list would be created that only a request to port 1433 from...

We have been burned by people claiming certs, so we actually have set up a pretty rigorous interview as well. My manager is a developer (he's the resident VB...

How are you running isqlw? As a command line utility or are you essentially "shelling out" to it so that the user can type commands?

If command-line, here's something from...

How about apps that REQUIRE case-sensitive databases that are on the open market? There's a certain HR package that I've grown to loathe that requires case sensitivity. Grrr!

K....

Which version of SQL Server are you using? I'm assuming 7.0, but I want to verify. Also, are you using ASP, Cold Fusion, etc?

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

If you are just looking at finding all constraints, regardless of type, use the INFORMATION_SCHEMA.TABLE_CONSTRAINTS view. It only returns information on objects the user has permissions to, but if...

I bought the SQL 2K book. It covers, as would be expected, some of the performance enhancements that are found in SQL 2K.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

This is because the 'PerformanceBased_PerCent' isn't yet available. The aliased field can't be used by your expression. You'll find that the aliased column is also unavailable in the...

Your first query:

quote:

---

SELECT *

FROM tbl1

LEFT OUTER JOIN tbl2 ON tbl1.key = tbl2.key

WHERE tbl2.filter = 1

AND tbl2.key IS NULL

---

K. Brian Kelley
@kbriankelley