Viewing 15 posts - 14,866 through 14,880 (of 19,560 total)
Lynn Pettis (4/14/2010)
To the TinD I am going, fun you all can have.
It looks like you can come back now.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 1:13 pm
Did you add any breakpoints?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 1:12 pm
Mister Ken (4/14/2010)
UPDATEt1
SET t1.ID = NULL
FROM dbo.table1 t1
WHERE EXISTS(SELECT * FROM #table2 t2...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 1:09 pm
Mister Ken (4/14/2010)
Any ideas on using an external column within a derived table?
The external column throws an error every which way you try to configure it. My answer on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:45 pm
Have you checked statistics, execution plans, indexes? Have you checked for blocking? Do you have any traces running?
Please provide the query and actual execution plan - better answers...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:41 pm
I missed it as well until I copied it ans pasted to my query window - then it became obvious.
Also, I was surprised to see the sudden responses all while...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:37 pm
COldCoffee (4/14/2010)
Buddy, dint your subquery (which u used for the lookup alias) give the result u wanted?
The initial query would provide an error.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:33 pm
That looks similar to what we are using. Meaning - we use the same kind of setup but different accounts obviously.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:32 pm
Mister Ken (4/14/2010)
select #table1.field1, lookup.line_count
from #table1
inner join (
select field1, count(*) line_count from #table2 where field2 > #table1.field2 group by field1
) lookup
on...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:28 pm
select t1.field1, lkp.line_count
from #table1 t1
inner join (
select t2.field1, count(*) line_count
from #table2 t2
Inner Join #table1 tt
On tt.field1 = t2.field1
where t2.field2 > tt.field2
group by t2.field1
) lkp
on t1.field1 = lkp.field1
I believe...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:27 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:18 pm
Lynn Pettis (4/14/2010)
CirquedeSQLeil (4/14/2010)
bcsims 90437 (4/14/2010)
CirquedeSQLeil (4/14/2010)
Steve Jones - Editor (4/14/2010)
TaxesWhy bother?
Penalties
Willie Nelson
Celebrities and the super rich always seem to get special treatment, don't they.
Isn't that we all strive for?...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:17 pm
Alvin Ramard (4/14/2010)
jcrawf02 (4/14/2010)
I've been out of Twitter-touch lately, but did you guys see this? Library of Congress is archiving every single tweet ever made?
I wonder how they're doing...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:16 pm
View Definition will work for the procs. For the views, that subject is more delicate. Views are handled differently and thus would be subject to a different set...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 12:14 pm
A lot a bit for me. It sure is nice to dream about though.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 14, 2010 at 11:42 am
Viewing 15 posts - 14,866 through 14,880 (of 19,560 total)