And while you are gen'ing up sample data for us search the web for Itzik Ben-Gan's various posts and articles (SQLMag has some iirc) on interval processing. There is...

http://www.datamanipulation.net/sqlquerystress/ --Adam Machanic's, quite solid and well used

http://www.sqlstress.com/

tpcc/h

http://hammerora.sourceforge.net/

dvdstore

http://www.sqlservercentral.com/blogs/technobabble-by-klee-from-kleegeek/2013/07/29/benchmark-your-sql-server-instance-with-dvdstore/

Jeff Moden (8/27/2013)

---

I'm not so sure that's true. If the computer is rebooted, the start of a new sequence might not be >...

Erland Sommarskog (8/26/2013)

---

Eric1/2aB (8/26/2013)

---

6 - What would you suggest for fill factor on a table like this? 100%?{/quote]

For indexes on GUIDs, an idea is to have a low fill...

I agree Jeff! Kudos to the Piet for doing an awesome job (especially compared to most) helping us help him/her!

Interesting. All of my work with spatial has been web20/mobile stuff, which is predominantly "I am here, who/what is near me" type of stuff. Points and distances.

It doesn't...

Ells (8/23/2013)

---

TheSQLGuru (8/23/2013)

---

DOH!! TOTALLY forgot to mention the transaction log! You need to manage that carefully or you can fill up the disk pretty easily (or at least wind...

I didn't think you could do STIntersection with geography data types. I changed your sample to all geometry data types and it dropped to 17 line segments that could...

DOH!! TOTALLY forgot to mention the transaction log! You need to manage that carefully or you can fill up the disk pretty easily (or at least wind up with...

1) Sorry, but I cannot ignore having session state stored in SQL Server. :w00t:

2) You have a varchar(100) as your clustered index. Does it look like a GUID...

Kuzey (8/22/2013)

---

Hi All,

Is it feasible to setup Availability Group(s) for 8,000+ databases, assuming high-end HW and huge network bandwidth are in place?

The number of transactions per day is high...

Indianrock (8/22/2013)

---

The servers have 512GB of memory with sql allowed to use 348GB. The numerous data files are all on a Netapp SAN device. The main user database...

JimS-Indy (8/22/2013)

---

I have a Project master table (tblProjects). Each project has zero or more Work Orders in the work order table (tblWorkOrders) (FK). Each Work Order has zero or more...

Batching large DML is a very common (and often REQUIRED process as you have found). Just make sure that:

1) you use ranges that are guaranteed to not be overlapping...

If you have CPU affinity happening either explicitly or implicitly due to the 40-core limitation that could have some affect on IO throughput.

However, the MOST common cause of IO slowness...