OK, I figured it out. From the link below, it appears that it is not really a performance problem at all, just how the execution plan is displayed. I...
I have a partitioned view for a group of 10 tables. The partitioning works for the most part. I can update the view, when I run a static query the...
I have read their support newsgroup, but most of the things I am having problems with are just not features of the package, and I was wondering if...
I have been testing RedGate's SQL Compare Toolkit, and like the ability to develop my own interface for the product, and integrate it in to a single...
This might work UPDATE t SET t.price = m.price, t.title = m.title, t.indextitle = m.indextitle FROM title t INNER JOIN MIT.dbo.title m ON (t.ean =...
And I forgot to mention, you shouldn't have to make any changes to your applications or SQL Servers to support this change, aside from changing the...
The XML for this is very simple. The stored procedure just accepts a varchar value with the XML string in it. Here is a simple example.<br /><br...
The above example wasn't actually the one I was thinking of, but it will work. You will need to do some additional work in order to pass in 3 values,...
You have several options available. The few that I can think of off the top of my head are passing in a delimited string, passing in XML, and using...
If you already have the foreign keys in place, which it looks like you do, this trigger will do absolutely nothing for you. Any process that would...
What didn't work about it? That query should return all rows that only exists once in the table. Edit: Nevermind, I didn't understand exactly what...
It may have something to do with default values, but I am not sure. I have never really tried to upgrade from access, as usually it is easier to...
ERwin is a nice tool. It can reverse engineer, create SQL scripts, and do a lot of other handy things.
Try this: SELECT MyString FROM Table GROUP BY MyString HAVING COUNT(*) = 1
That is perfect, no reason to feel like an idiot. After looking a little closer, I think the problem may be in an insert trigger that references the...
Can you post the actual DDL for the table? That will help us solve your problem more than anything.
And about the performance differences, generally a single SQL statement will perform better than a cursor, but not always. In those rare cases you...
Generally when you hear that it is better not to use a cursor, the intended goal is to write the code in a single statement. The while loop example...
Frank, I don't think CONCAT_NULL_YIELDS_NULL will help in this situation. That only works for string concatenation, not with math functions....
Try something like this: INSERT INTO t1 (somemorecolumn) VALUES ('somevalue') INSERT INTO t2 (somemorecolumn2, id1) VALUES ('somevalue2',...
Separate names with a comma.
