Viewing 15 posts - 3,616 through 3,630 (of 19,560 total)
Can you post the definition of your sql audit that is failing with the sql login?
You can script it and post that script.
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
February 18, 2014 at 7:36 pm
Do you have code and/or execution plan for this procedure?
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
February 18, 2014 at 7:19 pm
Can you run the dmf to get index frag info for a larger table alone? While this one is running?
Wondering if it just decided to get hung and stalled.
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
February 18, 2014 at 7:17 pm
dwain.c (2/18/2014)
Now you're going to need to help me out a little. Can you explain how the first 2 rows of that sample data gets translated to this (your...
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
February 18, 2014 at 7:11 pm
How is your memory looking on that server?
Do you have any signs of some memory pressure?
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
February 18, 2014 at 3:27 pm
Jeff Moden (2/18/2014)
SQLRNNR (2/18/2014)
How important is the data to your company/client? Do they have an RTO/RPO specified? In other words, what is 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
February 18, 2014 at 3:23 pm
Here is a script that I use for that kind of stuff
http://jasonbrimhall.info/2014/01/21/table-hierarchy-updated/
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
February 18, 2014 at 3:16 pm
The real answer is "It Depends"
How important is the data to your company/client? Do they have an RTO/RPO specified? In other words, what is the maximum allowable amount...
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
February 18, 2014 at 3:01 pm
Greg Edwards-268690 (2/18/2014)
Koen Verbeeck (2/18/2014)
Steve Jones - SSC Editor (2/18/2014)
Ed Wagner (2/17/2014)
EL Jerry (2/17/2014)
Have you noticed the community has grown over 1.7M members?
Congratulations to Steve et al...
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
February 18, 2014 at 2:55 pm
Luis Cazares (2/18/2014)
Sean Lange (2/18/2014)
OCTom (2/18/2014)
Answer: "I'm...
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
February 18, 2014 at 2:06 pm
What patch level and edition of SQL Server 2012?
Is this just opening the queries in a disconnected state or is it disconnecting all open queries?
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
February 18, 2014 at 10:00 am
I agree, the second is joining incorrectly on detailid instead of orderid.
In addition, I would through an Order By on both of those queries so the results are easier 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
February 18, 2014 at 9:47 am
crookj (2/18/2014)
WotD - reciprocating
saw
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
February 18, 2014 at 9:15 am
I love getting stammering responses to questions like "What do you like to do?"
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
February 18, 2014 at 9:13 am
Well done on the first article. Also, very useful information from Grant.
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
February 18, 2014 at 9:10 am
Viewing 15 posts - 3,616 through 3,630 (of 19,560 total)