Viewing 15 posts - 2,881 through 2,895 (of 6,401 total)
As I say, this is a MS SQL forum, not a MySQL forum, I do not know MySQL.
The example I gave was for MS SQL, you will need to find...
January 14, 2013 at 3:51 am
Ok, so your in simple, thats ok just would dictate the way to go when purging.
So the options are
1 - Add more disk space
2 - Purge data and perform...
January 14, 2013 at 3:39 am
Hi
This is a Microsoft SQL server forum, not a MySQL forum.
While a number of people here may have MySQL experience, you may be best posting this on a dedicated MySQL...
January 14, 2013 at 3:37 am
Use msdb.dbo.sysmail_delete_log_sp and msdb.dbo.sysmail_delete_mailitems_sp to delete from the two tables.
January 14, 2013 at 3:14 am
Add more space - if possible
Purge data - to release space from inside the data files, will need to be done in small chunks due to it needing to log...
January 14, 2013 at 2:59 am
There is remote query timeout setting in SQL but that only takes affect if you are quering a remote server using something like linked servers, there is nothing in SQL...
January 14, 2013 at 2:39 am
As far as I know, connection pooling is done in the app as its an application thing, not a SQL thing.
As for the time out, that is set at the...
January 14, 2013 at 2:22 am
Do not cross post, it fragments replies.
All replies here please http://www.sqlservercentral.com/Forums/Topic1406204-150-1.aspx
January 14, 2013 at 1:48 am
Have you debugged the query using the parameters that dont work in the report directly against the databases to see what the performance of the query with them paramateres is?
January 14, 2013 at 1:47 am
fatinnadiah88 (1/13/2013)
Step ID1
ServerSRIN_SVRA
Job Name1 Year Backup Maintain BDSBPM.Subplan_1
Step NameSubplan_1
Duration00:00:34
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user:...
January 14, 2013 at 1:40 am
Have you debugged to code to ensure that all connection object are being closed, dissposed and set to nothing. 12000 SPIDs for 15-20 active at anyone time seems a...
January 14, 2013 at 1:31 am
APA0876 (1/11/2013)
anthony.green (1/11/2013)
January 14, 2013 at 1:28 am
I would strongly recomment reading through the stairways section on SSIS.
But every task is control flow.
Only task that is data flow enabled is a DFT.
I would strongly recommend trying to...
January 14, 2013 at 1:25 am
ALTER DATABASE XXX SET NEW_BROKER WITH ROLLBACK IMMEDIATE
First stop everything that uses service broker in MSDB, like DBMail or anything you have created manually.
January 14, 2013 at 1:22 am
For the time being you could setup replication yourself (for real time reporting) or enable CDC (change data capture) and then you can transfer out the changed data nightly to...
January 14, 2013 at 1:17 am
Viewing 15 posts - 2,881 through 2,895 (of 6,401 total)