Viewing 15 posts - 4,861 through 4,875 (of 19,560 total)
Oftentimes yes it will make that adjustment. Occasionally it may miss on it because it is checking so many different possible query plans in split second to find a...
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
March 13, 2013 at 1:50 pm
Chris Harshman (3/13/2013)
Grant Fritchey (3/13/2013)
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
March 13, 2013 at 1:44 pm
Replication works wonders for that.
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
March 13, 2013 at 1:42 pm
You are dealing with a Debbie Downer.
XE is far more than what Grant said and obviously far more than Debbie said. XE can get you information about spinlocks, latches,...
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
March 13, 2013 at 1:38 pm
That text does not appear usable or searchable. I don't know why they would want to store or search it. But if the business requests it, sure store...
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
March 13, 2013 at 1:29 pm
Did you change it through Configuration Manager or through the services control panel?
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
March 13, 2013 at 12:29 pm
Jeff Moden (3/13/2013)
That got me thinking. Why is this data removed? I'm sure some of the data is stored in memory and automatically reset, but is this the best way...
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
March 13, 2013 at 12:28 pm
Welsh Corgi (3/13/2013)
Seemita Das (3/13/2013)
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
March 13, 2013 at 12:09 pm
GilaMonster (3/13/2013)
If there's absolutely no backup whatsoever, export all the documents, lists, etc from sharepoint (not a SQL data export), then drop and recreate...
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
March 13, 2013 at 11:36 am
Are you asking if there is a way to fix without losing data?
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
March 13, 2013 at 10:58 am
Vikas.Shinde 10262 (3/11/2013)
Can we see that particular table in database is affected by which ssis task or which job perform on that table??
You should start a new thread for this...
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
March 13, 2013 at 9:09 am
Are all of the packages performing tasks related to Oracle or something else?
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
March 12, 2013 at 11:48 pm
Short answer is - yes it is possible.
You have three subqueries each aliased as "Summary." If you take each of those subqueries and Alias them to Summary1, Summary2, and...
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
March 12, 2013 at 11:46 pm
How many records is this query returning?
Also, please post the actual execution plans, table definitions and sample data please.
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
March 12, 2013 at 11:41 pm
Here is an example of something that has already been done.
It might not be exactly what you want, but give it a look and see if it will work.
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
March 12, 2013 at 11:29 pm
Viewing 15 posts - 4,861 through 4,875 (of 19,560 total)