Viewing 15 posts - 13,006 through 13,020 (of 19,560 total)
Jack Corbett (8/4/2010)
WayneS (8/4/2010)
Jack Corbett (8/4/2010)
Just made my first "real" forum post in awhile. Had to pick a thread where Mr. Celko has already weighed in. http://www.sqlservercentral.com/Forums/Topic963903-391-1.aspx
Then it looks...
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
August 4, 2010 at 9:48 pm
Alvin Ramard (8/4/2010)
I once programmed one that would display the time in different formats: hex, binary, BCD, roman numerals, octal, and the good old base ten...
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
August 4, 2010 at 3:11 pm
Going back to a topic from a few days ago - here is a very pleasant post.
http://www.sqlservercentral.com/Forums/Topic960157-1292-1.aspx#bm963812
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
August 4, 2010 at 2:14 pm
Steve Jones - Editor (8/4/2010)
I vote no. I like my watch. I don't want to have to buy a new one that has 10 digits.Plus I have this cool clock:
I...
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
August 4, 2010 at 2:02 pm
Have you considered using SSIS to do this? You can select the data from one database and insert that data through a control flow item into a different db...
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
August 4, 2010 at 11:10 am
Brandie Tarvin (8/4/2010)
Lynn Pettis (8/4/2010)
Actually, this would probably be good material for an article. :smooooth:
Uh-huh. Sounds to me like you're trying to get Jack to write an article so...
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
August 4, 2010 at 11:06 am
I don't understand why you are inserting into your table, then deleting, and then inserting again.
It seems you should eliminate the delete and last insert. Historical numbers make more...
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
August 4, 2010 at 11:03 am
Thanks for the question.
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
August 4, 2010 at 10:56 am
Interesting solution. Thanks for sharing it with us.
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
August 4, 2010 at 10:45 am
How do you have your connection manager configured?
Are you using a configuration file with your package?
Is the package stored on the server that is executing the agent job?
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
August 4, 2010 at 10:43 am
I too have been programmed to be out of touch with my emotions - it is in the job description.
Awesome.
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
August 4, 2010 at 10:35 am
dbowlin (8/4/2010)
Brandie Tarvin (8/4/2010)
And my phrase for the day."Official Secrets Act"
HA!
I am waiting for the Unofficial Secrets Act. It will be proof positive that everyone in government has lost...
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
August 4, 2010 at 8:27 am
Kit G (8/4/2010)
dbowlin (8/4/2010)
Brandie Tarvin (8/4/2010)
And my phrase for the day."Official Secrets Act"
HA!
I am waiting for the Unofficial Secrets Act. It will be proof positive that everyone in government...
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
August 4, 2010 at 8:22 am
Thanks Stefan, another great article on uses for a tally table.
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
August 3, 2010 at 11:11 pm
The Dixie Flatline (8/3/2010)
BBQ diplomacy. You gotta love it.Unless of course you're vegan.
I apologize to all fundamentalist vegans.
No offense taken. I am a Vegan...
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
August 3, 2010 at 11:06 pm
Viewing 15 posts - 13,006 through 13,020 (of 19,560 total)