Viewing 15 posts - 10,546 through 10,560 (of 19,560 total)
Jeffrey Williams-493691 (4/6/2011)
The job_id is stored in the table: sysmaintplan_subplans and 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
April 6, 2011 at 3:58 pm
You could see performance gains if you did get an SSD. Better yet, try getting a fusionIO card. Check them out at fusionio.com[/url]. Think of an SSD...
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
April 6, 2011 at 3:40 pm
annasql (4/6/2011)
I did a check in AD, the SID of our domain account doesn't match the one in the group above mentioned.So that didn't explain the relationship.
While in AD 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
April 6, 2011 at 12:56 pm
What Do you have in the Microsoft SQL Server Program Group?
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
April 6, 2011 at 12:34 pm
Dogmatix
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
April 6, 2011 at 12:33 pm
Excellent
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
April 6, 2011 at 12:27 pm
So, from where are you unable to connect? Do you also have an unnamed instance installed? If you only have a named instance, then you have to connect...
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
April 6, 2011 at 12:25 pm
To export them to the file system from msdb, this is probably the most efficient method
http://sev17.com/2011/02/importing-and-exporting-ssis-packages-using-powershell/
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
April 6, 2011 at 12:19 pm
This should get you the JobOwners along with the PackageOwners. I wrote it so it will work in 2008 (adapt for 2005 by referencing the script Jeff provided) 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
April 6, 2011 at 12:09 pm
Saphira
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
April 6, 2011 at 11:33 am
Brandie Tarvin (4/6/2011)
CirquedeSQLeil (4/6/2011)
Never heard of G-Force other than the Disney Guinea Pig movie.
I heard Disney was doing G-Force and got all excited.
Then I found out it was about guinea...
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
April 6, 2011 at 11:22 am
GSquared (4/6/2011)
CirquedeSQLeil (4/6/2011)
GSquared (4/6/2011)
CirquedeSQLeil (4/6/2011)
GSquared (4/6/2011)
CirquedeSQLeil (4/6/2011)
GSquared (4/6/2011)
Lynn Pettis (4/6/2011)
Stefan Krzywicki (4/6/2011)
CirquedeSQLeil (4/6/2011)
Roy Ernest (4/6/2011)
GilaMonster (4/6/2011)
Lynn Pettis (4/6/2011)
Star Trek (the Original)My mother loves both that and Thunderbirds.
Gail, Low blow aimed...
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
April 6, 2011 at 11:14 am
GSquared (4/6/2011)
CirquedeSQLeil (4/6/2011)
GSquared (4/6/2011)
CirquedeSQLeil (4/6/2011)
GSquared (4/6/2011)
Lynn Pettis (4/6/2011)
Stefan Krzywicki (4/6/2011)
CirquedeSQLeil (4/6/2011)
Roy Ernest (4/6/2011)
GilaMonster (4/6/2011)
Lynn Pettis (4/6/2011)
Star Trek (the Original)My mother loves both that and Thunderbirds.
Gail, Low blow aimed at Lynn......
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
April 6, 2011 at 11:09 am
So the application does a network discovery or would the users have to know what the database server name is?
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
April 6, 2011 at 11:08 am
Durza
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
April 6, 2011 at 11:06 am
Viewing 15 posts - 10,546 through 10,560 (of 19,560 total)