Viewing 15 posts - 1 through 15 (of 192 total)
Well - in this case, at a rough guess, I'd try getting rid of the temp tables and refactor the query to use derived tables instead. This way, you're...
September 21, 2010 at 9:44 am
Bhuvnesh (9/20/2010)
Some more information about the concerned database :1. Data file growth has been set to : 1 MB.
...
While it's not related to the specific question you raised...
September 21, 2010 at 3:59 am
Hi,
Gail Shaw has an excellent article on here covering how to post queries relating to performance issues in order to give people the information they need...
September 21, 2010 at 2:17 am
Can you back up sucessfully manually?
September 16, 2010 at 2:29 am
Are there any quotas set on the target location?
Do you have error messages from the SQL Server logs and NT logs relating to this which you could post (having removed...
September 3, 2010 at 7:10 am
So just to double check - if the backup job is running the backup, then deleting the previous backup once it's complete, you still have room on the share for...
September 3, 2010 at 6:12 am
Could the issue potentially be that the two backup processes are overlapping?
If the backup process first does the backup, then deletes any previous backups once this is complete, and runs...
September 3, 2010 at 4:33 am
You're welcome, glad to help
August 27, 2010 at 8:12 am
Restore from backup?
I'd also check for hardware related faults to see if you may have issues on this machine which could lead to further corruption in this or other databases...
August 27, 2010 at 6:33 am
Unless you have explicitly disabled it, you already have the default trace running as - by default - it is enabled
August 27, 2010 at 4:01 am
Personally my preference for this is a UML deployment diagram, identifying the servers concerned with the sources, destinations and package(s) used.
There is a tool available calles SSIS Documentor which integrates...
August 27, 2010 at 2:08 am
Bhuvnesh (8/22/2010)
Jim McLeod (8/22/2010)
August 25, 2010 at 5:55 am
Rowcount operator on the query identifying whether there is erronious data, with two flows with Expression and constraint based upon the process completing sucessfully and the value of the variable...
August 11, 2010 at 4:07 am
If you have the default trace running (it's enabled by default - so unless you've psecifically switched it off, it is) then the information is available in there.
Have a look...
July 14, 2010 at 9:48 am
richard-674310 (2/22/2010)
I'm interested in your statement that team fit is important. I happen to agree with you.
You might want to consult your HR department on this - if...
July 6, 2010 at 2:36 am
Viewing 15 posts - 1 through 15 (of 192 total)