Viewing 15 posts - 13,576 through 13,590 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 30, 2008 at 11:26 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 30, 2008 at 11:23 am
majorbloodnock (5/29/2008)
GSquared (5/28/2008)
majorbloodnock (5/28/2008)
Matt Miller (5/28/2008)
Clustering your tied shoes might be tricky though.......:hehe::P
He, he.
Three-legged race, anyone?
I guess that would be an inner join... and has the usual performance...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 29, 2008 at 7:46 am
majorbloodnock (5/28/2008)
Matt Miller (5/28/2008)
Clustering your tied shoes might be tricky though.......:hehe::P
He, he.
Three-legged race, anyone?
I guess that would be an inner join... and has the usual performance problems associated...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 28, 2008 at 12:39 pm
I have to admit, I was tempted to answer "Access", just for the humor of it. 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 27, 2008 at 12:53 pm
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. ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 23, 2008 at 1:36 pm
I think both matter, pretty much equally.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 23, 2008 at 7:06 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 22, 2008 at 8:11 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 22, 2008 at 7:42 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 21, 2008 at 1:48 pm
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 21, 2008 at 1:33 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 21, 2008 at 1:31 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 21, 2008 at 1:24 pm
I'm definitely interested in your test results on that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 21, 2008 at 1:22 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 21, 2008 at 1:21 pm
Viewing 15 posts - 13,576 through 13,590 (of 14,953 total)