USE master

GO

SET NOCOUNT ON

-- Get all roles

CREATE TABLE #temp_srvrole(

ServerRole VARCHAR(128),

Description VARCHAR(128)

)

INSERT INTO #temp_srvrole

EXEC sp_helpsrvrole

-- sp_help syslogins

CREATE TABLE #temp_memberrole(

ServerRole VARCHAR(128),

MemberName VARCHAR(265),

MemberSID...

Some additional links on the subject for you:

https://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-failover-results-in-reseed-of-identity

http://stackoverflow.com/questions/13657461/odd-sql-server-2012-identity-issue

http://www.sqlserver-training.com/sequence-breaks-gap-in-numbers-after-restart-sql-server-gap-between-numbers-after-restarting-server/-

I have exactly the same issues on my 2012 servers, Googled and found the following script (sorry can't remember where) - run as a startup proc to "reset" the identity...

try checking that you have instant file initialisation enabled

http://bradmcgehee.com/2010/07/21/instant-file-initialization-speeds-sql-server/

MyDoggieJessie (10/15/2013)

---

There is virtually no...

Worked a treat, thanks all for your input - my GSCE maths escaped me and I was looking for an over engineered solution..!

ooooh.. good idea! 🙂

Exactly what I...

L' Eomot Inversé (9/23/2013)

---

duncanburtenshaw (9/23/2013)

---

Erland Sommarskog (9/21/2013)

---

Before we start talking about sargable arguments, maybe we should see if there is anything to sarg for. From what Duncan says, there does...

Erland Sommarskog (9/21/2013)

---

Before we start talking about sargable arguments, maybe we should see if there is anything to sarg for. From what Duncan says, there does not seem to be...

SrcName (9/20/2013)

---

read this fantastic article carefully. This may help you

http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/quote%5D

SrcName - thank you for the link, I have read this before and am familiar with the numbers/tally...

sometimes it's worth putting in a hint to use the spatial index, i.e.

SELECT CASE WHEN (SELECT count(*) FROM table1 WITH (INDEX ([SpatialIndex])) where SHAPE.STIntersects(@center) = 1) > 0

just to ensure...