Viewing 15 posts - 7,741 through 7,755 (of 19,560 total)
You can create a linked server for that. Coordinate with firewall team and create the connection.
You can also create an export/import job that exports the data from one and...
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
November 28, 2011 at 10:59 pm
Try using aliases between your derived tables, nested tables and outer tables. This would help significantly for us to understand - but also will straighten out what you are...
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
November 28, 2011 at 10:27 pm
You can try doing an alter proc if the proc exists. Else you can script out all perms and then reapply perms post script update.
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
November 28, 2011 at 10:11 pm
Log shipping could work
SSIS could work
Please give us more details as to what you are trying to accomplish.
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
November 28, 2011 at 10:07 pm
By those standards, I don't qualify either.
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
November 28, 2011 at 2:38 pm
Evil Kraig F (11/28/2011)
SQLRNNR (11/28/2011)
Evil Kraig F (11/28/2011)
GSquared (11/28/2011)
Brandie Tarvin (11/28/2011)
GSquared (11/28/2011)
But, Yahoo Babel Fish wins first prize with:... in fact c' is a work of plunger.
I just love...
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
November 28, 2011 at 1:48 pm
Evil Kraig F (11/28/2011)
GSquared (11/28/2011)
Brandie Tarvin (11/28/2011)
GSquared (11/28/2011)
But, Yahoo Babel Fish wins first prize with:... in fact c' is a work of plunger.
I just love this part. @=)
Yep! ...
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
November 28, 2011 at 1:39 pm
Pam Brisjar (11/28/2011)
SQLRNNR (11/28/2011)
To get to parameters - select manage from the dropdown error for the report in question.
Yeah, I stumbled on that just before you posted (see above). 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
November 28, 2011 at 10:18 am
To get to parameters - select manage from the dropdown error for the report in 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
November 28, 2011 at 9:45 am
Pam Brisjar (11/28/2011)
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
November 28, 2011 at 9:42 am
Nice job Roy.
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
November 28, 2011 at 9:40 am
Nice hot topic button Andy. If you are already under a fair amount of stress, adding this outside stress compounds the problem. Being able to communicate the cause...
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
November 28, 2011 at 9:39 am
Dev (11/28/2011)
SQLRNNR (11/28/2011)
HokeyJockey 😉
Stocky
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
November 28, 2011 at 9:29 am
You are welcome. I hope it continues to work well.
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
November 28, 2011 at 9:28 am
Thanks Hugo
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
November 28, 2011 at 9:26 am
Viewing 15 posts - 7,741 through 7,755 (of 19,560 total)