http://technet.microsoft.com/en-us/library/ff929109.aspx

http://blogs.msdn.com/b/isaac/archive/2008/10/23/nearest-neighbors.aspx

http://books.google.com/books/about/Pro_Spatial_with_SQL_Server_2012.html?id=NdvJXu7hT8oC

You have given us exceptionally little to go on here, so this is just an educated guess (albeit backed up by 45000 man hours invested in SQL Server) 😎

In your...

What city data do you have? Given that this is SQL 2012, I would do this using Spatial data types and the NEAREST capability (or more likely Isaac...

greg.bull (2/3/2014)

---

Dear All,

I'm using INSERT..SELECT to gather data from a complex query into a holding table, this happens right at the start of an SP. The data is then used...

Looks like a solution indeed. Kinda spiffy functionality too!

SQL 2012 SP1 CU8 Dev edition, the first of these works fine, second throws the listed error:

SELECT A.*, B.*

FROM A, B

WHERE A.A = B.a

SELECT A.*, B.*

FROM A, B

WHERE A.A *=...

Douglas Osborne-229812 (1/30/2014)

---

Guys,

Those were great suggestions.

I solved it in a different way - which I will post - thanks for all of examples.

We are on 2008R ourselves, we are hopefully...

Jeff Moden (1/30/2014)

---

ChrisM@home (1/30/2014)

---

homebrew01 (1/30/2014)

---

We haven't written any code like that in a while. It is easy to search for '*=' and find the left joins. Not so easy...

PHXHoward (1/30/2014)

---

Oh and as for sizes, server team gives us 50GB for C, and I usually request 250GB for data on D and 100GB for logs on L and 100GB...

Mani-584606 (1/30/2014)

---

I always used to create and configure the Data Directories as below:

Instance one on Node1:

Instance Name: AlwaysOnAG1\INS1

E:\SQLData\INS1

F:\SQLLogs\INS1

Instance two on node2:

Instance Name: AlwaysOnAG2\INS2

E:\SQLData\INS2

F:\SQLLogs\INS2

If we wanted to use Always on Availability...

DBANoobie (1/30/2014)

---

Hello all-

I was hoping someone can shed some knowledge on Always On for me when it comes to back up on the secondary.

The four options are:

1. Only on the...

DBANoobie (1/30/2014)

---

I thought quorum rules indicate you need a odd number for your cluster for fail over or something like that? Then again I am still learning about Always On...

SQL 2012 and the improved Windowing Functions TOTALLY ROCK from a functionality and coding perspective (once you...

PHXHoward (1/30/2014)

---

Building an answer file for unattended SQL Server installations. I have C:, D:, L:. and T: available.

I was thinking of

C: for OS

D: for system and user data files

L:...

1) are the machines using name resolution of any kind to know who the other is? I would look there if so.

2) do a file IO stall and wait...