Viewing 15 posts - 13,726 through 13,740 (of 14,953 total)
Yes. That's the basic purpose of partitioned tables.
May 13, 2008 at 9:22 am
Are the columns in the table set as nvarchar or varchar?
May 13, 2008 at 9:21 am
I tried various ways to rewrite your query, and using a Join instead of an In does speed it up a bit, but the main thing is going to be...
May 13, 2008 at 9:19 am
Have you thought about using LTrim and RTrim for this? Might be easier.
May 13, 2008 at 9:00 am
Definitely can't tell what's wrong from that. It looks like a generic error message of some sort. Is it possible to rebuild the DTS package manually as an...
May 13, 2008 at 8:59 am
Your right, the "go" will break it. Sorry about that.
On the deallocation, yes, you'll need to do that. I just wrote the skeleton of the code, you'll need...
May 13, 2008 at 8:57 am
I think a partitioned table (possibly even a federated database) will be your best bet for this. If you really insist on sticking with the 31 tables idea, the...
May 13, 2008 at 8:55 am
The "with" is what's called a CTE (Common Table Expression). They're new in SQL 2005. If you look up CTE in Books Online, it will tell you how...
May 13, 2008 at 8:46 am
Could you use a CLR to retrieve the MAC address? That's usually pretty good for uniquely identifying a server. (Can be problems if they have to swap out...
May 13, 2008 at 8:45 am
How do the two queries relate? There doesn't appear to be a common column between them.
May 13, 2008 at 8:41 am
Like Grant, I would normally design a database to store all address information in one place. No need to maintain two tables with the same columns in them. ...
May 13, 2008 at 8:21 am
Have you looked into the possibility of using a CLR to accomplish that? I don't know if it's possible, but it might be. Would at least appear to...
May 13, 2008 at 8:18 am
Michael Valentine Jones (5/12/2008)
May 12, 2008 at 3:42 pm
troyehall (5/12/2008)
GSquared (5/12/2008)
May 12, 2008 at 2:58 pm
Viewing 15 posts - 13,726 through 13,740 (of 14,953 total)