Viewing 15 posts - 4,861 through 4,875 (of 19,564 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...
March 13, 2013 at 1:50 pm
Chris Harshman (3/13/2013)
Grant Fritchey (3/13/2013)
March 13, 2013 at 1:44 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,...
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...
March 13, 2013 at 1:29 pm
Did you change it through Configuration Manager or through the services control panel?
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...
March 13, 2013 at 12:28 pm
Welsh Corgi (3/13/2013)
Seemita Das (3/13/2013)
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...
March 13, 2013 at 11:36 am
Are you asking if there is a way to fix without losing data?
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...
March 13, 2013 at 9:09 am
Are all of the packages performing tasks related to Oracle or something else?
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...
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.
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.
March 12, 2013 at 11:29 pm
Viewing 15 posts - 4,861 through 4,875 (of 19,564 total)