I read an article regarding huge performance increases using Quickshift SQL Accelerator. This sounds great but quickshift.com no longer exists...
Read Only Databases can not be shrunk. My Log Shipped Database has many GB of data unused in the data file and the transaction log. Is there anyway...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
In the ERP system, the way you create a new company is to create a new db, then use the erp system to populate the DB with tables So I am creating a...
I can not change the table fields from char to nchar - if i change any data fields at all I invalidate my support agreement I am purely from a SQL...
The DB is for the ERP system. It will sit as another company within our ERP. The ERP connects to one SQL DB which tells it where all of the...
Unfortunately I can not change any of the table structures of our ERP system so I can not change from char to nchar
I have a SQL 2000 Server set up with Latin1_General_BIN collation. I need to allow polish characters on this server but am unaware of how to allow...
I would love to go for a higher edition of SQL but I have been asked to keep the price down so any db expenditure isn't really an option. I think I...
I am planning on using a SQL Server Express 2005 instance on a dedicated web host. This will contain multiple DBs all under the 4gb limit. What...
I am not sure about yourt asp security issues - i presume any username specified in the asp connection string would have to be an NT account to be...
If you are linking ADSI as a server this becomes a bit different: run the following script to add your linked server: EXEC sp_addlinkedserver...
The login context is the login which you pass through your sql connection string i.e: Provider=sqloledb; Data Source=SERVER1; Initial Catalog=master;...
The user you are connecting as through the asp page has not got permission to the tables you are querying on the remote server. Also check the...
2 different executions: IIS: Richmond-Demo SQL Server making Call: Richmond-Demo Linked Server: RSQL Execution time - 1 second with 15%CPU uage on...
I'm not sure if it's because i'm not explaining this correctly or not. The issue is not the ASP. I run the asp on the testserver which links from...
Sorry, I don't see how this helps. The performance tips relate to queries on two different servers. As I have stated above, when the query is ran...
I have an asp page which queries a stored procedure to return a recordset. The procedure queries a local table and table on a linked server. The...
Separate names with a comma.
