I'm sure this one will be unanimous. I work for a company that is sensitive to the needs of their employees and I have three 19” monitors. I am not...

I just started a new job that's a combination of SQL Server administration and development. After evaluating the various backup options we're looking to purchase SQLBackup and SQL Log Rescue...

As far as internet advertising goes, I don't mind it as long as it is relevant to the content I am looking at and doesn't distract me from getting the...

That was a very well written article and presents a great example of making the right choice for the given situation. Hurcane does provide a solution that meets the requirements...

I don't have any problem with the page-peel ad; actually, I think it's kind of neat. I am running FireFox and it does not seem to lag for me, even...

I'm going slightly adjacent to the main topic but I don't get why people equate "Open Source" with "unsupported". How many of you get much of your support from Microsoft?...

Won't it be nice when Kerberos is easier to set up. Then we can just do single sign-on and not worry about storing any credentials outside AD. If anyone knows...

The Data Access Application Block in the Enterprise Library makes use of the Configuration Application Block to store the connection information. The Configuration block can be used with the Cryptography...

Here is how I would answer the original question:

select s.* from Students s

where not exists

  (select 1 from StudentExam se

  

If you follow Neil's advice and keep a reference to the Database object then the "slight performance hit" should only apply the first time the procedure is called. This is...

I wouldn't say that G.M., except for average employees. There is something to be said for having a stake in the company as a direct employee. I believe that the...

Mark,

Where are you updating the stored value? I have used this a few times and have not seen any impact on scalability but it may not have been under a...

Why not just store the sequence number in a table and perform an update statement like this (assumes a table called SequenceTable exists and has two columns, CurrentSequenceNumber [int or...

The classes would be awesome! From what I have seen, most managers only want to send DBAs to a SQL Server class/conference though. In reality, developers probably need it more...

I have avoided posting on this hotly debated topic in the past but there is a major point that both DBAs and developers overlook. Whether to use RI in production is a...