YEah 1gb is going to be very hard to work with. However, creating a table, dropping a table, these operations should be fairly quick. You're probably just hitting resource contention....

If the size is less than 8 pages, it's going to be stored on mixed extents and defragging is going to be an utter waste of time. You might even...

Just one point worth considering, how much are the differen applications dependent on the data from each other. If it's fairly light, splitting up allows you to have multiple indepdendent...

CELKO (1/5/2012)

---

No, not really. However, there are some ISO-11179 standards for data element names and meta-data, the SEI has a ton of research, and so forth.

My book SQL PROGRAMMING STYLE...

Just a note, the use of no_lock CAN reduce time because it reduces locking, but it's not an automatic. Not trying to get into the whole no_lock discussion, but we...

Yeah, I can't spot any differences either. Hmmm.... Estimates & actuals are off, more than a little bit. I know you updated the statistics, but did you try using WITH...

Take a look at the sys.dm_exec_query_stats DMO. You should be able to get a count from that assuming the statement is still in cache.

It does 1/3 the number of reads, but increases the time? No, that's not one I've seen. Can you post both actual execution plans? I know you say they're identical,...

I've never seen a hard & fast ruling on this one. I generally go between 1/10 and 1/5 of the size of the database and then watch things from there....

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I miss anything...

I would say no, Microsoft doesn't have a simple list of coding standards. But, if you want some Microsoft endorsed list of best practices, I'd check out the Static Code...

If you have different ANSI settings on the connections, you'll have different plans. If you're calling the query one way from the app (parameterized query, stored proc) and a different...

Marco V (1/4/2012)

---

So as a summary to conclude this case for me.

to run through the data it goes between 20 and 30 seconds (maxdop 1 is going abit faster).

i also...

I would not suggest installing SQL Server if you're going to be changing the server name, etc. Get the server set up and configured, then install SQL Server. You'll have...

What about just using the query window and typing 'UPDATE dbo.MyTable SET ColumnA = 42 WHERE ColumnB = 42'?

The gui in SSMS can support what you're doing, but it's a...