Dugi (1/10/2009)

---

I didn't read in deep for the Resource DB, I just was wondering why the other Sys DBs are available for BCK and RDB is not ! Anyway thnx...

Right there with you Lynn.

To me ansi is the guideline, "dialect" will get used whenever ansi doesn't perform as it should.

IMO that's where any DBMS will try to make a...

As Manu stated you need to use SQL_Latin1_General_CP1_CI_AS

CREATE DATABASE [yourDbName] ON PRIMARY

( NAME = N'yourDbName_data'

, FILENAME = N'X:\MSSQL.1\MSSQL\Data\yourDbName_data.mdf'

, SIZE = ..., MAXSIZE = ..., FILEGROWTH =...

Right on target :exclamationmark:

No reason to shout 😉

Why are you using a cursor for this in the first place ?

It would be better to just select it directly into a...

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...