snivas (3/3/2011)

---

Hi all

I have a A/P cluster server running with SQL Server 2005 RTM and allocated min memory is 8GB and max memory is 24 GB.(Total memory 32GB)

Today SQL...

Please script out your tempdb database (righ-click on the database icon in SSMS and Script Database As Create To New Query window.

Maybe you just have a tempdb that...

Jeff Moden (3/7/2011)

---

TheSQLGuru (3/7/2011)

---

1)3) I guarantee you that I can fill up an 8GB tempdb with data from a 400MB database for a SORT operation - it is called a...

There are VERY few scenarios where you want to consider table variables over temp tables: VERY high volume executions where temp-table-driven recompiles are causing issues, logging situations (table vars keep...

Given the question the OP asked, I imagine he/she has little ability/knowledge about query plans and how statistics are used to generate them. Time for some reading, since this...

1) 16 files is almost certainly unnecessary, and unless they are on separate spindles could be causing IO performance problems due to excessive head thrashing.

2) why no autogrowth on those...

Your statement is correct cloud9.

Explicit cursors can crush your actual execution plan (and thus actual IO in profiler) too.

1) TVFs that have multiple statements like this are HORRIBLE from a performance standpoint.

2) the clustered PK on the table will probably induce a lot of overhead for absolutely no...

there is no need to have information on how to identify memory issues in your case. YOU HAVE MEMORY ISSUES - PERIOD. You simply cannot successfully run 4...

ERStudio from Embarcadero is your friend when you have complex data models!

I'm with the BULK INSERT camp when it can be used on the particular file type.

Affordable is a VERY relative term. Value can come from being able to do something that others cannot do...

Jaimie, please don't post to threads that were started 2.5 years ago . . . 🙂

1) sp_whoisactive

2) search web for glenn berry sql server DMV. here is one for 2008, he has another for 2005. lots of goodness here: http://sqlserverperformance.wordpress.com/2009/05/21/sql-server-2008-diagnostic-script/