Viewing 15 posts - 3,256 through 3,270 (of 7,636 total)
Looks "Row-by-Row" to me. 😛
March 23, 2009 at 7:11 am
You can do this in SQL Sevrer 2005 without the spatial data types. See this distance function here: http://www.sqlservercentral.com/scripts/T-SQL/65739/
March 22, 2009 at 10:08 pm
Florian Reischl (3/20/2009)
"Flo OR SQL Guru" is absolutely correct :hehe:
Now, now. "XOR" is exclusive, "OR" is inclusive 🙂
March 22, 2009 at 9:03 pm
Jeff Moden (3/21/2009)
------------------------------------------------------------------------------------------------------------------------
123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
You do realize this is classic RBAR, right?
😀
March 22, 2009 at 6:30 pm
craigl5678 (3/22/2009)
My past experience was to always put the database and log files on different partitions. ...
Should thee be split on another partition even tho its on the same...
March 22, 2009 at 5:36 pm
RBarryYoung (3/22/2009)
You still have not provided any reason to take this more difficult approach.What are your real Goals in this?
I am still waiting for an answer to my questions, Mike.
March 22, 2009 at 2:47 pm
Chris Morris (3/22/2009)
Dog-th Vader 5.1%
Bitter "Come over to the dark side". A well-balanced
beer with a...
March 22, 2009 at 11:22 am
Andy Bod (3/22/2009)
Can you advise how, if I go for the multiple database option I can best keep the structure and sp's in sync? Can this be automated?
Hmm, I did...
March 22, 2009 at 11:18 am
gopalchettri (3/22/2009)
I will try it again with Stored procedure.But it will be helpful for me if i get the...
March 22, 2009 at 11:08 am
You still have not provided any reason to take this more difficult approach.
What are your real Goals in this?
March 22, 2009 at 10:44 am
I was not recommending multiple databases, I was recommending things like Table Partitions, multiple Database Filegroups and SAN/NAS multidisk volumes (Raid 1+0, etc.).
You can use multiple databases, however there are...
March 22, 2009 at 10:41 am
What rights does it have in SQL Server?
March 22, 2009 at 12:01 am
We have already answered your question. It cannot be done the way you are trying to do it.
Why do you think that you can only use a trigger?
March 21, 2009 at 9:51 pm
OK, supposedly it will create the tables for yo, however, you have to make sure that the account it runs under has the permissions to do that.
March 21, 2009 at 9:48 pm
Yeah, the table name is pre-set also.
As I recall that's the whole trick to setting this up, you have to find the tables name(s) and defintions and define them ahead...
March 21, 2009 at 9:38 pm
Viewing 15 posts - 3,256 through 3,270 (of 7,636 total)