Being this a SQL Server forum not a web services one this has to be spam, isn't it?

hedera (4/28/2010)

---

Yes, that is where I'm having issues. Access 2007 doesn't let me highlight 2 columns at once, I've tried several times. I'll try editing the PK in the...

a mix of parameters and dynamically generated sql statement does the trick... check here for details http://www.xdevsoftware.com/blog/post/Use-Parameters-with-OPENQUERY-in-SQL.aspx

agreed ... a rdbms engine unable to properly manage space is a scary thing to face.

only4mithunc (4/27/2010)... there is no index in the table.

... So what Im thinking is if this is the cane if the table has millions of record, it will scan the...

where... where is the WHERE clause? 🙂

Jeff Moden (4/23/2010)

---

If the table is a Temp Table, there's actually a DISADVANTAGE to using CONSTRAINT to name the PK... a constraint is one of those objects whose name must...

apat (4/24/2010)

---

Is it possible to partition a large table with billions of rows into separate databases and not in different file groups with the same process I mentioned above. Can...

Grant Fritchey (4/26/2010)

---

You can't pass parameters to a view, so you'll have to answer Lynn's question in order to get any help. I don't understand what you're trying to achieve...

:blink: my eyes! my eyes! sorry, couldn't help myself 😉

You have to try a little harder and...

amrakhjaaa (4/23/2010)

---

With the capabilities of today's commodity servers going up to 24 cores and 128GB memory on a single blade, you really only need to worry about scaleout if you...

David Portas (4/23/2010)

---

But please not ones like these created with the Management Studio "designer". Silly pictures like that don't even qualify as an...

Are other queries performing as usual?

If yes... issue is related to the particular query, in...

I'll love to see an ER diagram as well as business requirement in terms of how data is expected to be retrieved from the database.

"constraint" syntax allows you to specify the name of the underlying index so to comply with whatever naming convention you have...