Grant Fritchey (12/16/2009)

From what I can see this person has tried to demonstrate some work, but good googly moogly, who is going to read all that stuff & eval it?...

What about something like this?

SELECT

a.provcode

,COUNT(DISTINCT acctno) AS 'Patient...

I agree with Steve & Lynn, I'm confused.

Based only on what you've said, I'd say the answer is no, you can't use the WHERE clause of the outer query within...

In order to prevent a user from seeing only certain columns, you'll need to either limit the users access through a view or a stored procedure. If you give them...

Two things come to mind, but I'm not sure either is applicable. It could be contention, other processes interfering with yours, although I would think you'd either see errors or...

Whoa!

From what I can see this person has tried to demonstrate some work, but good googly moogly, who is going to read all that stuff & eval it? Anyone want...

There is no way to hack in and retrieve the 'sa' password.

First question is, are you running read_uncommitted? If so, you might need to reconsider that choice. I don't recommend using that connection setting for most systems anyway.

If the read is...

I've used Idera's Diagnostic Manager and Microsoft's Operations Manager both to moniter servers in disparate locations. They work fine as long as they can connect to the machines. Our situation...

However, joining tables across servers, let alone across oceans, can be very problematic from a performance standpoint. Frequently with linked servers you'll see all the data from the first server...

It really depends. We have systems still being worked on in VB6 that are connecting to SQL Server 2008, so there's not magic requirement that says you must move up....

I'm sorry, but the question is a bit vague. I'm assuming you're tasked with doing this at work and you've never done it before.

First, you need to differentiate between new...

It's very difficult to tell precisely what's occurring when only looking at images. There is a lot of information contained within an execution plan, not simply the graphics. In the...

Tables, foreign keys, you name it and we've got it in source control.

The reason we don't use projects and SSMS is simply because there's no way to automate a build...

You also need to be very careful about versioning and labelling your code so that you always know what state the source is in. Then, you only ever build the...