This is a big enough topic that I don't think a post here is going to help much. What I'd do, were I you, is dig into the subject...

Windows domain authentication can't chain to more than one computer. What you have to do is use "Be made using the login's current security context.", and then set up...

majorbloodnock (5/29/2008)

GSquared (5/28/2008)

I guess that would be an inner join... and has the usual performance...

I guess that would be an inner join... and has the usual performance problems associated...

I have to admit, I was tempted to answer "Access", just for the humor of it. 🙂

I've never been very fond of multiple-choice tests for validating anything. What they really measure, in my experience, is the ability to take tests.

Personality tests are a laugh. ...

I think both matter, pretty much equally.

nagarajanmm (5/22/2008)

Thanks for the reply.

My problem here is the Attributes in the Container are dynamic. Also the Ticket information would be spread across multiple tables. In that case, I...

Good article (of course).

I decided to try an experiment on your big numbers CTE (mainly because I'm bored this morning).

First, I ran it exactly as presented in the article, and...

Another advantage to separate databases is, what if one client calls in and says, "hey, we FUBARed our data and need you to restore from last night's backup"? If...

Another thing you might test on it is using an indexed view with the aggregates already in it. That's one of the things they're good for.

I ran your test code, and I think what you're trying to do can be done using the Running Totals code from [ulr]http://www.sqlservercentral.com/articles/Advanced+Querying/61716/[/url]. Instead of a running total, you...

I'm going to hazard a guess that it's a custom-built function.

The data you're looking for can usually be found in sys.sql_modules, in the definition column.

select definition

from sys.sql_modules

where object_id = 1

Use...

I'm definitely interested in your test results on that.

It looks to me like you could join on the various criteria of the ticket and the container.

select Container.ID

from dbo.Ticket

inner join dbo.Container

on ticket.severity = container.severity

and ticket.priority...