are you using 'implicit transactions' ?

If yes: that will issue a "begin transaction" before the first statement you perform and you'll need to commit/rollbak in the end of whatever...

neil (1/19/2009)

---

One of my clients is running a select statement as part of a report. The problem is that is takes 5 minutes to run despite only returning 500 rows.

Investigating...

Joe Celko (1/17/2009)

---

If SQL Server was up to ANSI/ISO Standards, we would have POSIX style regular expression in the SIMILAR TO predicate, like other SQLs. This is one...

Gabe (1/18/2009)

---

I figured it out. Well not really, but I figured out a way around it.

For some reason, both partitions have to be empty for it to be an instant...

- one of the advantages is the awareness of what one is creating.

( cfr select only the columns you need)

- if in the case, some columns should always be...

It is a bad practise to restart sqlserver instances if not explicitly needed !

(all cached objects will need physical IO to get cached again (your apps will notice !), all...

one thing that can bite you nasty is your local (temptb) copy of source data.

1) create your temp tables up front in stead of using select into.

2) only select the...

turn off auto...

the article has been mentioned by Nicholas Cain in one of the previous replies.

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx)

Nicholas Cain (1/15/2009)

---

The big thing here is that you should not be enabling autogrowth on the tempdb...

Nicholas Cain (1/15/2009)

---

The big thing here is that you should not be enabling autogrowth on the tempdb files. Not only would this be a performance hit on growth, but you...

The tricky part for most of us is: How do you size your tempdb ?

Do you...

Phillip Oyog (1/15/2009)

---

Hello,

This is my first post ever on SqlServerCentral so bear with me. We have a high-availability mirror set up in our office running on Windows 2003 srvr...

What I intended to show is that sqlserver handles it diferently if it as no table content data.

After create it states

Checking identity information: current identity value 'NULL', current column value...

an in place upgrade inherits some settings from sql2000. The goal (from ms) is to keep it working !

With a fresh install of sql2005, it will implement best practises and...

Indeed, freeing the proc cache cause all sql (including sprocs) to be re-evaluated for a plan the next time they execute.

With well organized indexes (including clustered please) and up to...