Viewing 15 posts - 1 through 15 (of 20 total)
January 19, 2010 at 7:47 pm
I can see that the execution plan is no longer retrieving the image column. I know the avg. reads will go down significantly considering only the non-clustered indexes are being...
January 18, 2010 at 4:18 pm
Thanks a lot! That works perfectly. You are the man. :hehe:
January 18, 2010 at 2:07 pm
Persisted computed columns are different from what you are talking about.
You are talking about Non-Clustered indexes (correct me if I am wrong.) They are only pointers to clustered index. If...
January 18, 2010 at 7:10 am
I know but I am having to work with what is there. When SQL Server parses the query, it is retrieving all the images that satisfy the first condition i.e....
January 17, 2010 at 9:49 pm
sounds very interesting!!! let me login to my business machine and see if that reduces the execution plan.
Aww man.. it says "the text, ntext, and image data types cannot be...
January 17, 2010 at 9:25 pm
SQL Server is designed to handle data in set format. Handling data on a row by row basis requires a lot of times the use of cursors and cursors have...
January 17, 2010 at 7:42 pm
That was the first thought that came to my mind. I could add a persisted computed column that does a textvalid(imagecolumn) and stores it in a separate column of data...
January 17, 2010 at 7:38 pm
Did you try rebooting server?
Sometimes starting and stopping sql server services wont help.
January 8, 2010 at 10:17 pm
Did you try using a command line tool instead to connect, like: osql -E -S tcp:servername\instancename?
Also, under network configuration-->TCP/ip, did you check and see if it is holding the latest...
January 8, 2010 at 9:59 pm
Just thought no one was interested. :ermm:
Put them back on. 🙂
And ofcourse, I would definitely like an opinion from the Gilamonster
January 8, 2010 at 2:19 pm
Just wanted to ask; These are the list of SQL Server editions that the original KB article applied to:
Microsoft SQL Server 7.0 Standard Edition
Microsoft SQL Server 2000 Standard Edition
January 8, 2010 at 7:30 am
I think I found the solution. Its because of an Update lock that allowed a shared lock to lock a resource that it needed to upgrade to an Exclusive.
January 6, 2010 at 9:53 pm
Where are you trying to connect from?
In SQL Server 2005, you have a tool called Surface Area Configuration through which you have to enable TCP/IP by clicking on remote connections...
January 6, 2010 at 9:50 pm
I know this might not be the answer you are looking for but if you are using SQL Server 2005, you should try fuzzy lookup transformation in SSIS. The fuzzy...
January 6, 2010 at 5:49 pm