Viewing 15 posts - 18,616 through 18,630 (of 19,560 total)
Even when not working, you're still working (around the house, or at the house in your office). And if you're truly not working, then there is SSC - which...
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
December 18, 2009 at 8:47 pm
Nice one. Thanks for jogging the memory. I use sql so rarely to query the file-system that I forgot about this one.
It would work well with xp_getfiledetails.
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
December 18, 2009 at 8:21 pm
Sorry, are you asking a question for help on a specific topic or just looking for help in general?
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
December 18, 2009 at 8:05 pm
Jack is accurate in his statement.
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
December 18, 2009 at 5:57 pm
and the udf's
udf_GenBatchID
udf_GetApplicationID
And, has the job ever worked?
Anything change that would have caused it to start failing?
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
December 18, 2009 at 5:24 pm
How about the sql for the job that runs this monster?
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
December 18, 2009 at 5:21 pm
I'll still be working too, minus a few days off around each of the holidays.
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
December 18, 2009 at 5:16 pm
Please post the "master" proc.
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
December 18, 2009 at 4:38 pm
I was initially leaving out the 2/3 comparison due to this looking like a homework assignment. I was hoping to leave out just enough he would finish it up.
But...
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
December 18, 2009 at 4:25 pm
BTW...Thanks Jack and Andrew for pointing it out.
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
December 18, 2009 at 4:14 pm
When tested against the data provided I got distinct records on my end. I scaled the testing up and started seeing what you guys saw.
Here is the revised:
;
With custvisits...
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
December 18, 2009 at 4:08 pm
24tjf (12/18/2009)
If I am selecting from the temp table, i.e. MemberID: xxx has had 4 visits (all at the same store) [Not in the example]
Then the query...
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
December 18, 2009 at 3:45 pm
Please don't double post
Post any responses to http://www.sqlservercentral.com/Forums/Topic836660-1292-1.aspx
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
December 18, 2009 at 3:28 pm
Based on the available information, I did the following:
Create Table #StoreVisit (StoreID int, MemberID int, DateVisited datetime)
go
Insert into #StoreVisit(StoreID,MemberID,DateVisited)
Select 888,100100,'2009-01-25'
Union All
Select 888,100100,'2009-02-15'
Union All
Select 999, 200200,'2009-07-01'
Union All
Select 777, 200200, '2009-09-25'
Union All
Select...
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
December 18, 2009 at 3:13 pm
Yes it will work.
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
December 18, 2009 at 3:02 pm
Viewing 15 posts - 18,616 through 18,630 (of 19,560 total)