Viewing 15 posts - 10,216 through 10,230 (of 19,560 total)
Ninja's_RGR'us (5/3/2011)
SQLRNNR (5/3/2011)
Ninja's_RGR'us (5/3/2011)
GilaMonster (5/3/2011)
I've seen someone cause 4 hours additional downtime during...
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
May 3, 2011 at 3:47 pm
It looks fine. Have you tried removing the leading space and the trailing space?
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
May 3, 2011 at 3:26 pm
Have you verified that the smtp server is accepting mail from your server? It might be as simple as checking the smtp server configuration and values in your variables.
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
May 3, 2011 at 2:50 pm
Ninja's_RGR'us (5/3/2011)
GilaMonster (5/3/2011)
I've seen someone cause 4 hours additional downtime during a disaster...
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
May 3, 2011 at 2:45 pm
You're 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
May 3, 2011 at 2:03 pm
Not necessarily an issue in AD but somewhere down the pipe some permissions are granted to that group that are not granted to the original 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
May 3, 2011 at 1:41 pm
WayneS (5/3/2011)
This MSDN link might help explain it a bit better
That was very handy.
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
May 3, 2011 at 1:40 pm
That would be it. Parentheses are optional.
From the link you posted.
In approach four, I talk about "processing groups" and intermediary results, but I don't actually know what is going...
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
May 3, 2011 at 1:22 pm
Koen Verbeeck (5/3/2011)
SQLRNNR (5/3/2011)
Koen Verbeeck (5/3/2011)
SQLRNNR (5/3/2011)
Tsk tsk :hehe:
If it is any consolidation, you're not the only one who contractors are trying to screw over...
(it was you who told us...
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
May 3, 2011 at 1:12 pm
I wouldn't say that it is a common thing. I hadn't seen anything like it until 8-9 months ago. It is done because of some criteria 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
May 3, 2011 at 1:10 pm
Koen Verbeeck (5/3/2011)
SQLRNNR (5/3/2011)
Tsk tsk :hehe:
If it is any consolidation, you're not the only one who contractors are trying to screw over...
(it was you who told us about your contractor...
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
May 3, 2011 at 1:08 pm
Something like this?
Select *
From sometable st
LEFT JOIN stable2 ac
LEFT JOIN stable3 nc
ON ac.somefield = nc.somefield
AND ac.somefield + 1 = nc.somefield
ON st.somefield = ac.somefield
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
May 3, 2011 at 1:06 pm
Koen Verbeeck (5/3/2011)
Steve Jones - SSC Editor (5/2/2011)
Brandie Tarvin (5/2/2011)
I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about to throw stones at...
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
May 3, 2011 at 12:58 pm
Since they had the issue prior to virtualization, it could be that something with the local groups is causing the issue. Have you checked the local security groups for...
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
May 3, 2011 at 12:36 pm
Until recently I was biased against them having had extremely bad experiences with them. I have seen an implementation where it seems to work rather well. Thus, 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
May 3, 2011 at 12:34 pm
Viewing 15 posts - 10,216 through 10,230 (of 19,560 total)