Viewing 15 posts - 12,751 through 12,765 (of 19,560 total)
Elliott is spot on.
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 26, 2010 at 5:13 pm
This should work fine for you. This will copy over the most recent version of the DTS package. I recently used it for several hundred packages.
SELECT T1.*
Into...
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 26, 2010 at 5:12 pm
typically these kinds of operations require data copy. Furthermore there will be code changes and permissions changes. This should require substantial planning.
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 26, 2010 at 4:12 pm
Brandie Tarvin (8/26/2010)
CirquedeSQLeil (8/26/2010)
Should I stay or should I go now?There's a song for that...
Strictly for the song's sake. Gonna re-attack this problem in a week - from...
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 26, 2010 at 12:07 pm
Stefan Krzywicki (8/26/2010)
CirquedeSQLeil (8/26/2010)
The argument on what is history is: I just want to be able to change the data if I want to.
At that point, I'd tell them...
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 26, 2010 at 12:04 pm
Stefan Krzywicki (8/26/2010)
On a side note, why busses? Why aren't people in these theoreticals brought up in too many meetings ever hit by taxis, trucks, private cars, trains, boats, airplanes,...
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 26, 2010 at 12:01 pm
We all have a role to fill at times in our lives. Sometimes it's a high level role, and at times it's a low level role. Each of us brings...
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 26, 2010 at 11:57 am
Jack Corbett (8/26/2010)
CirquedeSQLeil (8/26/2010)
How do you convince somebody that archive data should not be changed?
Data integrity didn't work
Point in time visibility did not...
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 26, 2010 at 11:45 am
Brandie Tarvin (8/26/2010)
CirquedeSQLeil (8/26/2010)
How do you convince somebody that archive data should not be changed?<Headthunk><Headthunk>
HAHA
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 26, 2010 at 11:42 am
Stefan Krzywicki (8/26/2010)
CirquedeSQLeil (8/26/2010)
How do you convince somebody that archive data should not be changed?
Data integrity didn't work
Point in time visibility did not...
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 26, 2010 at 11:41 am
@Kit - Arnold is on his way
@ray and @Gail - nice angle. I should have thought of that. Sox and California privacy should be able to win that...
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 26, 2010 at 11:36 am
So here is my question of the day
How do you convince somebody that archive data should not be changed?
Data integrity didn't work
Point in time visibility did not work
Reporting consistency did...
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 26, 2010 at 11:26 am
GSquared (8/26/2010)
Oh, and since I got rid of the beard, I've updated my picture. 🙂
You look more attractive that way 😉
Oh, and welcome back
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 26, 2010 at 11:25 am
Here is an example of how to do that
Dim conn As New SqlConnection(Config.GetConnectionString("SiteSqlServer"))
Dim command As New SqlCommand("set arithabort on;", conn)
...
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 26, 2010 at 11:01 am
I am finally getting around to "Kelly's Heroes"
We'll see how the thread recommendations prove to be.
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 26, 2010 at 10:57 am
Viewing 15 posts - 12,751 through 12,765 (of 19,560 total)