Viewing 15 posts - 9,331 through 9,345 (of 19,560 total)
tilew-948340 (7/22/2011)
"PolciyAdministrator is not a role in the msdb database"Almost half of the people thought it was a role :w00t:
So very good question! Thanks!
Thank you
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
July 25, 2011 at 10:43 am
db-1061069 (7/22/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
July 22, 2011 at 4:49 pm
Without knowing the innards of the proc, I would venture a guess at ownership chaining.
Does this proc attempt to insert/update records in a different database?
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
July 22, 2011 at 4:45 pm
BCC-493036 (7/22/2011)
Welsh Corgi (7/22/2011)
If a Server Blue Screen or "Crashed" you are not going to get an Alert.You are wrong. The alerts will be sent out from monitoring system.
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
July 22, 2011 at 4:36 pm
If interested, here is a script that should work well for you.
http://jasonbrimhall.info/2010/05/19/tablespace-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
July 22, 2011 at 4:22 pm
SVR (7/22/2011)
I am new to sql server administration. And I was asked this question in one of my interview.
You are unable to connect to sql server....
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
July 22, 2011 at 4:15 pm
Jeff Moden (7/22/2011)
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
July 22, 2011 at 4:10 pm
Unless you had auditing enabled on the server - nope.
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
July 22, 2011 at 4:06 pm
And along the note that Gail mentioned, read this blog post.
http://sqlserverpedia.com/blog/sql-server-2005/can-you-dig-it-%E2%80%93-missing-indexes/
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
July 22, 2011 at 4:03 pm
For grins - checked the default trace - it's not there.
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
July 22, 2011 at 3:12 pm
Did you by chance have auditing turned on?
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
July 22, 2011 at 3:03 pm
Revenant (7/22/2011)
SQLRNNR (7/22/2011)
. . . It also doesn't hurt to try to expand the market favorably since many employers try to expand it to the bottom end of that curve.
......
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
July 22, 2011 at 2:42 pm
cengland0 (7/22/2011)
Ninja's_RGR'us (7/22/2011)
So what are your negotiation tips / tactics?
I haven't been on the Market for a new job for 10 years. I have no desire to leave my...
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
July 22, 2011 at 1:59 pm
Good editorial.
I stopped asking for many things long ago due to blanket denials. Things like books - I usually just go buy it myself if I need/want it. ...
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
July 22, 2011 at 1:55 pm
Tom.Thomson (7/22/2011)
SQLRNNR (7/22/2011)
Spring CleaningWhat's the Windows equivalent of
rm -r *
??
FDISK THEN FORMAT
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
July 22, 2011 at 1:17 pm
Viewing 15 posts - 9,331 through 9,345 (of 19,560 total)