<p>How much database performance overhead is involved with using C# and LINQ compared to custom optimized queries loaded with mostly low-level C, both with a SQL Server 2008 backend?</p>

<p>I'm specifically thinking here of a case where you have a fairly data-intensive program and will be doing a data refresh or update at least once per screen and will have 50-100 simultaneous users.</p>

[{'answer_id': 5475, 'author': 'Daniel O', 'author_id': 697, 'author_profile': 'https://Stackoverflow.com/users/697', 'pm_score': 1, 'selected': False, 'text': '<p>Have you tried removing the SSP using the command line? I found this worked once when we had a broken an SSP and just wanted to get rid of it.</p>\n\n<p>The command is:</p>\n\n<pre><code>stsadm.exe -o deletessp -title &lt;sspname&gt; [-deletedatabases]\n</code></pre>\n\n<p>The <code>deletedatbases</code> switch is optional.</p>\n\n<hr>\n\n<p>Also, check in Central Administration under Job Definitions and Job Schedules to ensure no SSP related jobs are still running</p>\n'}, {'answer_id': 7109, 'author': 'Daniel McPherson', 'author_id': 897, 'author_profile': 'https://Stackoverflow.com/users/897', 'pm_score': 2, 'selected': False, 'text': '<p>I suspect these are related to the SQL Server Agent trying to login to a database that no longer exists. </p>\n\n<p>To clear it up you need to:\n 1. Go to SQL Server Management Studio\n 2. Disable the job called <code>&lt;database name&gt;_job_deleteExpiredSessions</code></p>\n\n<p>If that works, then you should be all clear to delete it.</p>\n'}, {'answer_id': 97256, 'author': 'Aidenn', 'author_id': 15346, 'author_profile': 'https://Stackoverflow.com/users/15346', 'pm_score': 4, 'selected': True, 'text': '<p>As Daniel McPherson said, this is caused when SSPs are deleted but the associated \njob are not and attempt to communicate with the deleted database.<br><br>If the SSP \ndatabase has been deleted or a problem occurred when deleting an SSP, the job may \nnot be deleted. When the job attempts to run, it will fail since the database no \nlonger exists.</p>\n\n<p>Follow the steps Daniel mentioned:<br>\n1. Go to SQL Server Management Studio <br>\n2. Disable the job called SSPNAME_JobDeleteExpiredSessions, right click and choose Disable Job.</p>\n'}]
['https://Stackoverflow.com/questions/4782', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/177/']