Viewing 15 posts - 1,936 through 1,950 (of 19,560 total)
Ed Wagner (10/3/2014)
Pain
Gain
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 3, 2014 at 8:04 am
ramana3327 (10/3/2014)
If that job is running the ssis package. How to start the process. Do we need to create that ssis package under the new...
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 3, 2014 at 7:56 am
jcrawf02 (10/3/2014)
I'd congratulate Jason and Jack, but then I'd have to read more posts where they thanked me, so I'll pretend I congratulated you if you pretend you thanked me?
Deal:cool:
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 3, 2014 at 7:52 am
You do need to fully test for performance. While some queries may perform worse, there are many cases where the query will perform much much better.
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 2, 2014 at 6:38 pm
ramana3327 (10/2/2014)
Thanks LNNRAny precautions we may have to follow?
Any constraints we may face in this process?
Look at my previous post.
And it is SQLRNNR. NOT LNNR;-)
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 2, 2014 at 4:02 pm
No precautions that would be any different than moving the job any other way. The same considerations always have to be taken into account when you move a 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
October 2, 2014 at 3:46 pm
You would have to change one of the plans to perform copy_only backups.
Before switching to a version to implement differentials, are you sure you will be able to get 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 2, 2014 at 3:44 pm
My preference is to script it and execute the script on the new server - very easy and takes little time or effort.
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 2, 2014 at 3:38 pm
sapsucker
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 2, 2014 at 2:02 pm
Ed Wagner (10/2/2014)
djj (10/2/2014)
Ed Wagner (10/2/2014)
SQLRNNR (10/2/2014)
sinewTendon
Bone
Bad
Sheep
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 2, 2014 at 12:14 pm
Useful information imho. It would be nice to have the msdn article on the topic clarified a bit.
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 2, 2014 at 11:49 am
Thanks for the update Steve.
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 2, 2014 at 11:03 am
sinew
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 2, 2014 at 10:34 am
Stefan Krzywicki (10/2/2014)
SQLRNNR (10/2/2014)
Stefan Krzywicki (10/2/2014)
SQLRNNR (10/1/2014)
Stefan Krzywicki (10/1/2014)
SQLRNNR (10/1/2014)
Jack Corbett (10/1/2014)
If you aren't on Twitter you may have missed that Jason Brimhall (SQLRNNR) got awarded MVP today.
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
October 2, 2014 at 10:25 am
Stefan Krzywicki (10/2/2014)
SQLRNNR (10/1/2014)
Stefan Krzywicki (10/1/2014)
SQLRNNR (10/1/2014)
Jack Corbett (10/1/2014)
If you aren't on Twitter you may have missed that Jason Brimhall (SQLRNNR) got awarded MVP today.Thanks Jack:-D
Hey! Congratulations!
Thanks Stefan....
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 2, 2014 at 9:00 am
Viewing 15 posts - 1,936 through 1,950 (of 19,560 total)