Viewing 15 posts - 10,321 through 10,335 (of 19,560 total)
WITH
E1(N) AS ( --=== Create Ten 1's
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
April 26, 2011 at 12:16 pm
PSB (4/26/2011)
This doesnot return any data!
Please provide sample data. You'll notice that the query is the same thing you have - just broken into two phases.
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 26, 2011 at 11:56 am
I would seriously ponder taking less money to be able to telecommute because of all of the benefits it could bring.
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 26, 2011 at 11:51 am
Grant Fritchey (4/26/2011)
nico van niekerk (4/26/2011)
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 26, 2011 at 11:50 am
Brandie Tarvin (4/26/2011)
SQLRNNR (4/26/2011)
Brandie Tarvin (4/26/2011)
SQLRNNR (4/26/2011)
Steve Jones - SSC Editor (4/26/2011)
RainWe have SNOW
Send some to Florida, please.
Working on that. Do you want it shipped to you via SSIS?
Depends....
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 26, 2011 at 11:44 am
See if this works any better.
with preprocess as (
Select internalid,txn.Terminal,txn.ActivityDate,datepart (hh,ActivityTime) As ActivityHour
FROM dbo.ABCD txn
WHERE ActivityDate >= '3/1/2011' AND ActivityDate < '4/1/2011'
)
select distinct Terminal,ActivityDate,ActivityHour
From preprocess
Where ActivityHour >= 23 and...
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 26, 2011 at 11:41 am
Brandie Tarvin (4/26/2011)
SQLRNNR (4/26/2011)
Steve Jones - SSC Editor (4/26/2011)
RainWe have SNOW
Send some to Florida, please.
Working on that. Do you want it shipped to you via SSIS?
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 26, 2011 at 11:36 am
Post the table structure please - along with PK and indexes.
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 26, 2011 at 11:30 am
Stefan Krzywicki (4/26/2011)
Brandie Tarvin (4/26/2011)
SQLRNNR (4/26/2011)
Brandie Tarvin (4/26/2011)
GAH! (headdesk,headdesk)Someone please help. I'm about to format my hard drive in a fit of pique. http://www.sqlservercentral.com/Forums/Topic1098759-148-1.aspx
FWIW - I hate those kinds of...
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 26, 2011 at 11:28 am
Brandie Tarvin (4/26/2011)
SQLRNNR (4/26/2011)
Brandie Tarvin (4/26/2011)
GAH! (headdesk,headdesk)Someone please help. I'm about to format my hard drive in a fit of pique. http://www.sqlservercentral.com/Forums/Topic1098759-148-1.aspx
FWIW - I hate those kinds of errors in...
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 26, 2011 at 11:23 am
Intriguing question - thanks
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 26, 2011 at 10:30 am
Brandie Tarvin (4/26/2011)
GAH! (headdesk,headdesk)Someone please help. I'm about to format my hard drive in a fit of pique. http://www.sqlservercentral.com/Forums/Topic1098759-148-1.aspx
FWIW - I hate those kinds of errors in SSIS
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 26, 2011 at 10:24 am
I would have the same kind of questions. Did anything in the proc change at all?
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 26, 2011 at 10:24 am
I asked very early on for your process, and then Dave has asked again in a more clear way for the same info.
We really need to see the script to...
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 26, 2011 at 10:20 am
Steve Jones - SSC Editor (4/26/2011)
Rain
We have SNOW
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 26, 2011 at 10:16 am
Viewing 15 posts - 10,321 through 10,335 (of 19,560 total)