Viewing 15 posts - 8,296 through 8,310 (of 19,560 total)
Ray K (10/12/2011)
anniversary(married nine years today!)
Congrats - I just passed 16 yrs last week.
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
October 12, 2011 at 8:45 am
Maxime.Gagne (10/12/2011)
It is indeed obscure, never heard of this SQL Collection but it works!I'll do some homework and research that collection.
Thanks a lot
It's actually COLLATION. This is your best...
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
October 12, 2011 at 8:29 am
Jeff Moden (10/12/2011)
SQLRNNR (10/11/2011)
Try this
SELECT MerchantID
from #tempSort
ORDER BY LEFT(merchantID,8) DESC,CASE WHEN ISNUMERIC(REVERSE(right(REVERSE(right(merchantid,LEN(MerchantID)-8)),3))) = 1 THEN 1 ELSE 0 end
Oh... be careful, Jason. REVERSE is terribly expensive compared to other...
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
October 12, 2011 at 8:28 am
Maxime.Gagne (10/12/2011)
I updated my original post with a more accurate 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
October 12, 2011 at 8:28 am
Chad Crawford (10/11/2011)
Some wild story about the bookstore not opening for another 15...
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
October 12, 2011 at 8:19 am
Try this
SELECT MerchantID
from #tempSort
ORDER BY LEFT(merchantID,8) DESC,CASE WHEN ISNUMERIC(REVERSE(right(REVERSE(right(merchantid,LEN(MerchantID)-8)),3))) = 1 THEN 1 ELSE 0 end
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
October 11, 2011 at 3:11 pm
jozhang (10/11/2011)
I am checking it now. Anyway, thank you very much!
Sorry couldn't be of more assistance - I hope you get it straightened 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
October 11, 2011 at 1:29 pm
I haven't used CozyRoc before. Have you checked this page for info?
http://www.cozyroc.com/ssis/sftp-task
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
October 11, 2011 at 1:19 pm
Stefan Krzywicki (10/11/2011)
Here's something fun for those of us unlucky enough to not be at PASS.
Sweet
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
October 11, 2011 at 1:15 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
October 11, 2011 at 1:13 pm
Add Desc after merchantid in your order by clause
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
October 11, 2011 at 1:02 pm
toddasd (10/11/2011)
How do you figure HoursOn for 2323 is 7?
I come up with ~5h55m on that one.
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
October 11, 2011 at 12:57 pm
The only way I have been able to achieve this is to use xp_cmdshell and tsql. I am sure there is a method using powershell or a script component...
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
October 11, 2011 at 12:52 pm
What queries have you tried so far?
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
October 11, 2011 at 12:46 pm
Please post the config screenshots for your sftp connection item.
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
October 11, 2011 at 12:45 pm
Viewing 15 posts - 8,296 through 8,310 (of 19,560 total)