the first thing I would do is try to stop calling objects by the same name ;-)
Have you tried:
CREATE INDEX xStartDate on MainFull (StartDate)
Secondly, you are going to link to another table on a field called "StartDate", what field type is this?
As for SQL Server, surely a company like yours has the resources to supply SQL Server on a shared resource basis? That is to say, you either get just a database in a SQL Server where others have their Databases, or an Instance on a server where others have their Instances.
If getting a resource in a shared environment is not the real problem but the price is... just between you, me and the internet, I know some projects that get an old workplace machine and temporary Administrative Access for the machine, long enough to install SQL Server Express (including tools). In an environment which has heavy regulatory requirements this could be a sacking offence but some people find it easier to ask for forgiveness than permission. 0:-)
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (5)|
Save time and get your email on the go with the Yahoo Mail App
Get the beautifully designed, lighting fast, and easy-to-use, Yahoo Mail app today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.