Viewing 15 posts - 10,486 through 10,500 (of 19,560 total)
Nice question. 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
April 11, 2011 at 3:21 pm
sing4you (4/11/2011)
crookj (4/11/2011)
WOTD - defibrillatorJoe
broken heart
Braveheart
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 11, 2011 at 3:09 pm
Stefan Krzywicki (4/11/2011)
WayneS (4/11/2011)
Stefan Krzywicki (4/11/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
April 11, 2011 at 11:05 am
I think there could be enough info. Have you presented this to a Usergroup or two?
Would you like to give it a go via livemeeting for my UG?
Presenting to...
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 9, 2011 at 10:49 am
You could use the upgrade assistant. I would look into doing a side by side upgrade so as to have a fallback option.
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 9, 2011 at 8:01 am
Here is a brief intro for the solution. Basically a solution is similar to using a "solution" inside of visual studio.
Read this article to get more on the brief...
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 8, 2011 at 4:14 pm
WayneS (4/8/2011)
Jeffrey Williams-493691 (4/8/2011)
WayneS (4/8/2011)
One thing to keep in mind - if you create scheduled maintenance plans, the jobs it creates are owned by the person creating the MP.
I handle...
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 8, 2011 at 3:58 pm
annasql (4/8/2011)
And I see in sql server 2008 there is a sql agent service account, NT AUTHORITY\SYSTEM.Is it better to change job owner to this account?
No.
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 8, 2011 at 3:56 pm
Gros gras grand grain d'orge, tout gros-gras-grand-grain-d'orgerisé, quand te dé-gros-gras-grand-grain-d'orgeriseras-tu? Je me dé-gros-gras-grand-grain-d'orgeriserai quand tous les gros gras grands grains d'orge se seront dé-gros-gras-grand-grain-d'orgerisés.
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 8, 2011 at 3:16 pm
Much the same as Dan. Having sa as the Job owner does not require anybody to login to SQL Server with the account nor for anybody to even know...
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 8, 2011 at 2:40 pm
How exactly are you trying to upload the file currently?
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 8, 2011 at 2:17 pm
Are you asking if there is a GUI app available that allows you to write a stored procedure just by drag and drop?
That would be an ORM - and those...
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 8, 2011 at 2:00 pm
try c:\windows\temp or your user temp directory for those logs.
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 8, 2011 at 1:56 pm
No it means that the email reached your exchange server and you opened the email in your Outlook. In your Outlook it translates the fully qualified name (in 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
April 8, 2011 at 1:50 pm
well you could continue to use xp_sendmail but SQL 2005 and Outlook 2003 don't play nicely. Also, that means installing application software on the server - which isn't an...
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 8, 2011 at 1:33 pm
Viewing 15 posts - 10,486 through 10,500 (of 19,560 total)