I have a webapp in Asp.net 1.1 with SqlServer 2005 Express Edition. It's a typical small website with 1.000 registered users and 100 articles (most textual) published. This thing is on a Pentium 4 single-processor machine with 512mb of RAM which hosts both the SQL and the IIS. The site has only 600...

I have been given ownership of this 2005 database with a large number of tables. Speed has been a problem so I looked at % defragmentation on the indexes and found that most were over 50%, some as high as 98%. I rebuilt the indexes using a script I wrote but some refuse to reduce their level of defragmentation...

Hi, Have you check statistics and did you ran index tuning wizard if it has something to suggests you!! IMO you should compare the Execution plan on both the machine and try to rectify the difference if it has any...

Hi, You have to change the owner for the view defination to another user, and ensure that their would be no object mapped to this particular login/user (jefftest) and then you can remove it.

Hi, IMO you should change the connection to Dev/Test box and ask your application/package developer to test if it is executing well.

Hi, You can assign SQLAgentUserRole to it, please refer http://msdn.microsoft.com/en-us/library/ms188283.aspx Regards

If you are using SQL 2K5 and good in CLR, and CLR procedure deployment is possbile. Then go for that. String concatenation is faster in .Net. But in your case I think as you are using ASP, so I dont think it is possible. Or Use one scalar UDF, that will concatenate your string values. In that way you...

I have the following view's select statement - I have indexes on all the columns used in the joins and wheres and still - "select *" on this view is taking 2 minutes for getting 3493 rows. I see an "INDEX SPOOL" in the query execution plan. I broke it down to multiple views and...

Dear All, I'm new in this forum, and quiet new also in SqlServer also, so please be gentle! In my program, I use a .mdf database that is about 3Go. This DB contains about 1 million records. My problem is that, in my program, the first access to the database (ie the first request) is slow. On my test...

I have to genrate a Store procedures script from SQL sever 2000 when i try to execute these script on Sql Server 2005 it gives the following Error "Msg 15157,Setuser failed because of one of the following reasons: the database principal 'nust' does not exist, its corresponding server principal...