Viewing 15 posts - 151 through 165 (of 204 total)
Yes your right I don't want to end up with two values in the category table with the same textual value even if they did have different IDs. The natural...
November 20, 2007 at 3:26 am
Hi Thanks for replying I was getting a bit confused myself at the time of writing that.
Currently we have a table that uses an identity field for the PK. We...
November 19, 2007 at 8:30 am
Sorry forgot the UPDATE Statement in the middle!!
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
UPDATE CATEGORIES
SET CategoryPK = CategoryPK + 1
SELECT Max(CategoryPK) as NewCategoryPK FROM CATEGORIES
So if multiple requests access it they would...
November 16, 2007 at 8:11 am
The website is classic ASP connecting to SQL Server 2005 using an ADO connection string such as
DRIVER={SQL Server}; SERVER=MYSERVER; DATABASE=MYDB; uid=MYUSER; pwd=MYPASSWORD;
I have a data helper class that runs...
September 7, 2007 at 9:27 am
Thanks for your advice
How can I find out why the query optimiser chooses one index over another? What steps can I go through
to find out why the nclidx_tbl_JOBS_SiteFK is not...
September 7, 2007 at 3:32 am
Thanks for the advice
The web application builds up the SQL in a string as it has to look in another recordset to see which columns to return and supply in...
September 6, 2007 at 8:25 am
Hello thanks for your response but could you please explain point 3
"Try changing the order of table to JOIN and a OPTION (FORCE ORDER, MAXDOP 1) to the...
September 4, 2007 at 5:25 am
Hello. The error is actually being returned on the line that executes the SQL
eg set objRS = objCon.Execute(strSQL)
And the error reported is a DB Timeout so it seems that it...
September 4, 2007 at 2:33 am
I would but I don't really want hundreds of stored procs that basically all do the same thing but with different combinations of the same where clause parameters. Thats why...
August 24, 2007 at 4:32 am
Hi thanks for the responses.
The problem with having multiple procs per SELECT is that if you also notice from my first post I want to replace all those CASE statements...
August 22, 2007 at 6:54 am
Thanks for the advice.
If using sp_executesql recomplies on each call would it not be best to just keep the existing mutli if statement proc but add WITH RECOMPILE at the...
August 20, 2007 at 7:05 am
Hi thanks for that trick. I didn't realise you can just click n drag columns around in the management console in 2005! I've never been able to do it before...
June 29, 2007 at 11:44 am
Yes the MSDB is set up correctly with a level of 90 and I managed to create the assembly and udfs which can be accessed from the db I am...
June 29, 2007 at 10:33 am
Hi I have just found out when trying to install a CLR .NET assembly that enables use of Regular Expressions through User Defined Functions that our production server (2005) is...
June 29, 2007 at 8:24 am
Viewing 15 posts - 151 through 165 (of 204 total)