Viewing 15 posts - 19,231 through 19,245 (of 19,560 total)
Jeffrey Williams-493691 (10/29/2009)
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 29, 2009 at 4:48 pm
If you are looking in the derived column transformation task, you should be able to see a list of expression groups in the top right of the properties.
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 29, 2009 at 3:37 pm
Have you tried to use an expression in the precedence constraint coming from the sql task?
The idea would be to fork your flow based on the expression result. If...
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 29, 2009 at 3:35 pm
Have done it in the past successfully without issue.
Does it truly need to be SQL2K, or can it be a database on 2K5 in Compatability 80?
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 29, 2009 at 3:27 pm
Alvin Ramard (10/29/2009)
CirquedeSQLeil (10/29/2009)
GilaMonster (10/29/2009)
Woot....
...
My Ex's would probably answer: "She's a woman. She knows how to multi-task."
😉
S.O.M.:-D
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 29, 2009 at 3:08 pm
GilaMonster (10/29/2009)
CirquedeSQLeil (10/29/2009)
How do you find the time? School, articles, SSC, writing books, work...
School?
It's 11pm and I'm just starting on a report that'll likely take 2-3 hours. Answer your...
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 29, 2009 at 3:07 pm
Bob Hovious 24601 (10/29/2009)
.... not to mention practicing martial arts and conquering the galaxy.
Agreed.
I have time for work, other work, and my kids - outside of that it gets slim...
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 29, 2009 at 3:05 pm
CooLDBA (10/29/2009)
I need the _recordId from Recordset Destination, is there a way that I can put these_recordId in a table, is that possible?
Sure you can. RecordID would be another...
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 29, 2009 at 3:02 pm
GilaMonster (10/29/2009)
Articles finished, slides finished, demos finished. Packing half done (laptop, books, cables and important documents still to do). Just 2 reports to finish and I think one of those...
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 29, 2009 at 2:59 pm
Alvin Ramard (10/29/2009)
Can we hit 10,000 on Nov 18th? That's when this thread turns 1 year old.
Yes, if we know how? 😉
Two major obstacles - Pass and SQL Connections.
It...
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 29, 2009 at 2:57 pm
Lynn Pettis (10/29/2009)
Is it just me today or are OP's purposely posting things today that are as clear as mud?
Must be something to do with the time of year.
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 29, 2009 at 2:54 pm
Sounds like a title and a question of duties supplied by the company. It could very well be a Developer, it could be a DBA, or a Database Architect.
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 29, 2009 at 11:56 am
Gianluca Sartori (10/29/2009)
Maybe it's the same math that states that if I eat an egg and you don't eat at all, each of us had half egg.:-)
Hmmm, still feeling a...
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 29, 2009 at 11:12 am
In that case - according to my math this is post 899999
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 29, 2009 at 11:10 am
Gianluca Sartori (10/29/2009)
....ooops! It's 8924 bottles!I was using 50 posts per page...
you guys lost me in the posts - i show 8914 for Gianlucas last - and this is 8915ish?
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 29, 2009 at 11:03 am
Viewing 15 posts - 19,231 through 19,245 (of 19,560 total)