Activity overview
Latest activity by unclebiguns
FIgured this out. It was the CopyTo. removed the CopyTo and the log backups went back to under 2 minutes. / comments
FIgured this out. It was the CopyTo. removed the CopyTo and the log backups went back to under 2 minutes.
Log Backups Taking 2-3hrs to complete and should take minutes
I have a case where my log backups using SQLBackup are taking 2-3hrs to complete and they should take less than minute according the data in backupset.In backupset the largest difference between ba...
David Atkinson wrote:
What would you say a sensible limit was? We'd rather avoid adding options if at all possible.
David Atkinson
Red Gate Software
Actually 150 is probably a good choice for display. Could paging be implemented? Even a a message saying 150 of N displayed would be better because there is nothing in the application that tells you that there are more than what is being displayed.
In my case I was searching for references to a second database because there are those who want to move those functions into the current database. Most procedures and functions have references to this database so I wanted to get a number and generate a list. I can do it using T-SQL, but SQL Search could have been perfect, if it returned all the rows (at least a count) and if I had a way to export to csv or excel. So I'd suggest keeping the display limit to 150 and adding a total found count and a way to export all results. / comments
David Atkinson wrote:
What would you say a sensible limit was? We'd rather avoid adding options if at all possible.
David Atkinson
Red Gate Software
Actually 150 is probably a good choice for ...
I just ran up against this limit as well and was going to start a thread about it.
I'd love to see this be configurable as I have a database with over 1000 sp's and I'm trying to identify a call to another database within the sp's and I hit the 150 limit. / comments
I just ran up against this limit as well and was going to start a thread about it.
I'd love to see this be configurable as I have a database with over 1000 sp's and I'm trying to identify a call to...
I am having the same problem when I start a job and then close the job progress window. I have also sent at least one error report in.
Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 6.1.7600.16385
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.7600.16385
Microsoft .NET Framework 2.0.50727.4952
Operating System 6.1.7600 / comments
I am having the same problem when I start a job and then close the job progress window. I have also sent at least one error report in.
Microsoft SQL Server Management Studio 10.0.4000.0
Micro...
SQL Server Compact Edition
Are there any plans to support SQL Server Compact Edition?
I'm experiencing similar slowness problems with SQLPrompt 5. For me it appears to happen when I have a long SQL script open, particularly with CTE's and or temp tables in the script. It also happens in Visual Studio 10.
Here are some errors in the SQLPrompt log from today:
29 Dec 2010 20:53:31,489 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
29 Dec 2010 20:58:00,290 [9] ERROR RedGate.SqlPrompt.Engine.LogService - LogService caught unhandled exception in AppDomain: 'Thread was being aborted.'
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout)
at System.Threading.Thread.Sleep(Int32 millisecondsTimeout)
at RedGate.SQLPrompt.CommonUI.Controls.SpinnyThing.SpinnyWidget.?
/ comments
I'm experiencing similar slowness problems with SQLPrompt 5. For me it appears to happen when I have a long SQL script open, particularly with CTE's and or temp tables in the script. It also happ...
Put Join At end of Line
In SQLRefactor I had an option to put the JOIN at the end of the line. With SQLPrompt 5 I can't find this option. Is it still there? If not, I'd love to have it added.
Brian,
I will still send the error logs, but knowing where to look helped me solve the problem. I had chosen in the beginning to encrypt the connection to the SQL Server and it worked at the beginning, but changing the credentials apparently caused this to fail as I know get a certificate chaining error. By not encrypting the connection I SQL Response now connects properly. / comments
Brian,
I will still send the error logs, but knowing where to look helped me solve the problem. I had chosen in the beginning to encrypt the connection to the SQL Server and it worked at the begin...
Yes, I restarted the alert repository service and I rebooted the PC (my workstation) that it is installed on. / comments
Yes, I restarted the alert repository service and I rebooted the PC (my workstation) that it is installed on.