Hi - does anyone know of any way (startup parameters maybe?) that I can downgrade SQL 2005 developer edition to SQL 2005 Workgroup edition? This is...
Hi again - 2 questions in quick succession. I want to be able to monitor if anyone modifies Jobs. I have created a quick trigger to prove it's...
Hi guys - good to speak to you all again. New job new situation. Trying to clean up the administration plan in here and have encountered the...
I have just uninstalled SQL Server 2000 and reinstalled it. I don't understand how what I experienced can even be possible but here's the situation:...
Guys, I'm trying to find out specific information on Data Types and NULL values performance wise. I can find plenty of information on the web...
We have a situation where there are a bundle of categories for different aspects of a row. There are 3 category columns to group on. The data also...
I have programmed against Access a bundle of times before but always through ADO using either ODBC or OLE DB. I never noticed any major differences...
I have a requirement to insert a continuous stream of data in a sql table. There is a data feed with the main columns of concern here being the...
I read somewhere that Temp tables - if you take aside the time taken to create them - are far faster than permanent tables for inserts, updates, and...
Separate names with a comma.
