Viewing 15 posts - 106 through 120 (of 965 total)
Without the graph its really hard to say. Save the deadlock xml as a text file and attach it to your response and it will be easier to help...
December 20, 2010 at 1:38 pm
blakmk,
What is the @@VERSION of the server that you got that error on? The bug that caused invalid deadlock XML to occur was fixed in one of the latest...
October 13, 2010 at 7:08 am
Another benefit of the backup/restore method over attach/detach or offline/online could be that the backup does not flush the plan cache for the database considered.
For moving files between two...
September 24, 2010 at 11:46 am
Mad Myche (9/24/2010)
September 24, 2010 at 10:10 am
Nils Gustav Stråbø (9/24/2010)
Jonathan Kehayias (5/27/2009)
When you attach without the log file, it is rebuilt, which can leave your database incosistent, not a good thing to do.
I don't even think...
September 24, 2010 at 7:32 am
amarshall-568002 (9/24/2010)
I didn't think you could move the log file with alter... unless you used enterprise or developer version of SQL.Amy
You can use ALTER DATABASE MODIFY FILE for log files...
September 24, 2010 at 6:59 am
I would begin to suspect something associated with UAC here, or the fact that you are targeting a x64 SQL Install with a x86 build of the DLL? I...
August 18, 2010 at 5:01 pm
mitega (8/18/2010)
Sorry but I don't know the configuration to well... it is another company that takes care of that.I don't think that the virtual server has dedicated resources.
This would be...
August 18, 2010 at 4:58 pm
The 'remote access' sp_configure option doesn't affect the ability to connect to the SQL instance from a different computer, it affects the ability to execute remote stored procedures, or have...
August 17, 2010 at 11:09 am
That isn't actually a full blown version of Visual Studio, and the only thing it can do is develop SSIS, SSRS, and SSAS solutions, it can't develop code in C#,...
August 17, 2010 at 11:01 am
If you are properly maintaining your log by doing Transaction Log backups at regular intervals, the log file should not be growing out of control like that unless you have...
August 17, 2010 at 8:43 am
You can reference them and it be SAFE, but to do so you have to manually edit the csproj file for the project. To do this create a new...
August 17, 2010 at 8:22 am
Ummm... you only use sp_OACreate for OLE Automation not SQLCLR. If you registered the SQLCLR assembly in the database, you then have to create the necessary Function/Stored Procedure...
August 17, 2010 at 7:20 am
Without further details about how your VM is configured, its impossible to offer anything intelligent to look at. What is the difference in configuration CPU/Memory/DiskIO between the physical server...
August 17, 2010 at 7:16 am
The other thing to check is:
Did you deploy both assemblies to the same database? It would be pretty easy to deploy one of them to a different database and...
August 17, 2010 at 7:13 am
Viewing 15 posts - 106 through 120 (of 965 total)