Viewing 15 posts - 3,226 through 3,240 (of 19,560 total)
Do you have permissions to run powershell scripts?
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, 2014 at 3:12 pm
gen-pop
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, 2014 at 12:16 pm
While XE can provide you some of this info, the better approach is to set up a Server and Database audits (http://technet.microsoft.com/en-us/library/cc280386.aspx[/u]).
And yes, a DBA with sysadmin can alter 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 7, 2014 at 9:46 am
Jeff Moden (4/5/2014)
So, yeah... I agree... hardware and hardware tuning are important but, if you really want to make an improvement, remember what most people won't even consider because hardware...
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 7, 2014 at 9:39 am
You need to include a from clause in your 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
April 4, 2014 at 10:29 am
Can you provide more information on what your rules for performing the update 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
April 4, 2014 at 9:13 am
Sanz (4/3/2014)
Any way to figure out which database is the one involved ?
Read that article, it goes through the troubleshooting steps to help you resolve the issue.
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 4, 2014 at 7:45 am
MyDoggieJessie (4/3/2014)
Good Lord Jason :w00t: ...
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 4, 2014 at 7:43 am
mishka
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 4, 2014 at 7:41 am
Stewart "Arturius" Campbell (4/4/2014)
Interesting question, thanks.I have never found the need to have more than one distributor per instance of SQL server, but good to know that it is possible
I...
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 4, 2014 at 7:36 am
Sean Lange (4/4/2014)
TomThomson (4/3/2014)
Steve Jones - SSC Editor (4/3/2014)
Revenant (4/3/2014)
Sean Lange (4/3/2014)
Greg Edwards-268690 (4/3/2014)
it was clear they had no idea what they wanted or needed.But finish it by Friday.
This 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 4, 2014 at 7:29 am
dwain.c (4/3/2014)
Many thanks to Steve for syndicating my blogs on SSC:And my apologies for making you work so hard at it.
Well well well, another blog to read. I don't...
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 4, 2014 at 7:26 am
Here's an article on that error and how to troubleshoot 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
April 3, 2014 at 1:15 pm
FWIW, I managed 4500 servers at a previous job with over 10,000 databases.
I recently managed over 200 servers for various clients with total DB size over 50TB.
It all kind of...
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 3, 2014 at 1:09 pm
Ed Wagner (4/3/2014)
crookj (4/3/2014)
Revenant (4/3/2014)
Ed Wagner (4/3/2014)
JAZZ Master (4/3/2014)
SQLRNNR (4/3/2014)
rigoloLaugh
Cry
Baby
Girl
Daddy
Mommy
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 3, 2014 at 1:06 pm
Viewing 15 posts - 3,226 through 3,240 (of 19,560 total)