Viewing 15 posts - 6,841 through 6,855 (of 19,560 total)
Here's a starter query.
SELECT DISTINCT j.name
FROM msdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobsteps js
ON j.job_id = js.job_id
WHERE js.subsystem = 'SSIS'
This relies on the job step having been defined as an SSIS task. ...
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
February 24, 2012 at 9:54 am
You could use a linked server from the SQL Server side and retrieve the data from Oracle via stored proc. In that stored proc join the data and then...
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
February 24, 2012 at 9:02 am
big show
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
February 24, 2012 at 8:13 am
mark.hammond (2/24/2012)
Good grief! Talk about using a sledgehammer to drive a tack.
You're welcome to post your more simple elegant solution. As was stated in the onset of the...
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
February 24, 2012 at 7:55 am
Rob Sonders (2/24/2012)
Could you post the Script Task code in C# please.
If somebody out there knows how to do that, they are welcome to post it. I don't have...
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
February 24, 2012 at 7:52 am
Koen Verbeeck (2/24/2012)
Great article, thanks.
Thanks Koen
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
February 24, 2012 at 7:51 am
Unless you are using shared datasets, it looks like you will need to get that info by extracting the xml for each report and querying the xml.
Here is a blog...
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
February 23, 2012 at 4:21 pm
I can see size as a cost measure. We charged at a prior place for amount of time spent supporting the user base and projects along with routine maintenance.
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
February 23, 2012 at 1:16 pm
You are welcome.
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
February 23, 2012 at 1:00 pm
sqlfriends (2/23/2012)
This other server that is your report server is different. In that case, you need to make sure you have your reporting services key backed up (can 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
February 23, 2012 at 12:58 pm
It seems you are looking for a scale out deployment.
Here is some info and references.
http://technet.microsoft.com/en-us/library/ms156453.aspx
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
February 23, 2012 at 11:11 am
sqlfriends (2/23/2012)
Thanks, when you say change the compatiblity, you mean change to 2008 (100) correct?
yes
Also I have another server, which hosts reporting server and its databases, I need to upgrade...
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
February 23, 2012 at 11:06 am
If you have a new box, install SQL 2008 R2 on that box. Restore the database(s) from backup. Then change the compatibility level and test the application against...
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
February 23, 2012 at 10:54 am
Welsh Corgi (2/22/2012)
SQLRNNR (2/22/2012)
Welsh Corgi (2/22/2012)
If so how do you mange it?
I want to move to 2008R2 but 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
February 23, 2012 at 10:42 am
Welsh Corgi (2/22/2012)
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
February 23, 2012 at 10:41 am
Viewing 15 posts - 6,841 through 6,855 (of 19,560 total)