Doesn't really matter much. Just get whatever you can afford. IO performance (not capacity!!) and RAM in the box will be MUCH more important than CPU type on...

1) tlog should NOT have 2 files in it.

2) tlog should NEVER grow under normal operations. make it as big as it needs to be and leave it at...

simple answer is to store the OS system filedate when you load the file. then just compare the filedate with the file to see if different. I note...

It is actually a very easy problem to track down - the disk IO is too slow (says it in the message basically)! Finding the root cause - that...

Search the web for: gaps islands ("transact sql" OR tsql). Itzik Ben-Gan has some very good coverage on that topic in a book of his. He also has...

>>WHERE DateColumn_1 >= '01/01/2008' AND DateColumn_1 <= '01/01/2009'

I would like to question that WHERE clause. Given the dates picked I would think you are looking for one year's worth...

Yeah - I think I can probably count on one hand the number of clients I have had in over 10 years of consulting that used Foreign Keys! 🙂

Jeff Moden (12/24/2009)

---

TheSQLGuru (12/24/2009)

---

Again I inquire how I am supposed to traverse the hierarchy of the folder system with that output? Having a depth without any way to identify...

Ian Scarlett (12/24/2009)

---

TheSQLGuru (12/24/2009)

---

My best guess is that one or more of the referenced fields are not indexed, thus requiring a table scan for every insert to validate the FK...

It is almost certainly the foreign keys.

run an insert from SSMS with set statistics on and show actual execution plan. My best guess is that one or...

there was a massive thread here on sqlservercentral.com recently dealing with string splitting IIRC that had some amazing benchmarks involving all kinds of solutions. One of the things discovered...

Again I inquire how I am supposed to traverse the hierarchy of the folder system with that output? Having a depth without any way to identify parent isn't useful,...

I wish xp_dirtree would give enough information to be able to traverse a directory hierarchy. Anyone know how to do that?

d:\sqlexp\112233

d:\sqlexp\112233\20091211

d:\sqlexp\112233\20091212

d:\sqlexp\112233\20091213

d:\sqlexp\112233\20091214

d:\sqlexp\112233\20091215

d:\sqlexp\112233\20091216

d:\sqlexp\112233\20091217

d:\sqlexp\112244

d:\sqlexp\112244\20091211

d:\sqlexp\112244\20091212

d:\sqlexp\112244\20091213

d:\sqlexp\112244\20091214

d:\sqlexp\112244\20091215

d:\sqlexp\112244\20091216

d:\sqlexp\112244\20091217

I seem to get the following output from xp_dirtree,...

My vote is that the optimizer is estimating a small number of rows and using index seek/bookmark lookup plan and/or nested loop join.

Jeff, haven't you learned by now that some questions just shouldn't be asked?? :w00t: 😀