You are creating a db of 4Gb datafile + 2Gb log file .... to large !

Can you give it a try using this ddl:

CREATE DATABASE [TimeSeriesSSC] ON PRIMARY

(...

Can you script the create database ddl ?

(rightclick on the db-name and then select Script database \ as create \ to query panel and then copy/paste the ddl.)

This will only...

Just my 2ct.

Leave your db as it is until you are 100% sure it is actually over sized !

(Someone will have put it to that size for a reason, figure...

Your db files are >= 4Gb, which is the maximum for sql2005 express edition.

You'll need to free up some space before your engine will be able to allocate it.

You'll have...

another thing ...

Are you sure your instance is listening at the port number you provided ??

If I'm correct, in a connection string, if you provide the port number, it will...

file 1 is a data file.

Shrinking it 500MB at a time will be to much overhead for your operation, especially if you know it only contains 20% worth of data.

I...

You could use a server level DDL trigger in combination with a database set AUTO_CLOSE on.

(check BOL DDL Statements with Server Scope (ALTER_DATABASE) )

and just register if it is...

afaik you cannot delete a part of a backup file.

A backup device is just a pointer to an actual file.

If you use backup with init, that file wil...

That shouldn't be a problem.

please check out Identifiers http://msdn.microsoft.com/en-us/library/ms175874.aspx regarding your table name containing the #.

Avoid special chars in your object names or always use brackets ([ ]) with your...

the lack of indexes, clustering indexes and foreign keys will indeed kill this kind of queries.

Determine a primary key for every table and if you can, determine foreign keys that...

Denise McMillan (4/30/2010)

---

I was wondering how the max works in the max(case... portion of your example?

Also, what did you mean when you referred to this:

- you also need to...

By default you don't need a cursor ! :w00t:

double check your data !

I think you misplaced column names for [CurrentTalkTime] and [IncrementalTalkTime].

Considered...

Are your schedules enabled ?

What kind of jobs do you have ?

- local sqlinstance only

- ssis packages

- cmdshell

did you change the sqlagent service account lately ? (and does that...

Do you need info of some ids or of all ids ?

If all, just remove it from the where clause.

If some: can you predefine them ?

Avoid loops, think sets...

I would prefer an inner join, but you'll have to figure out what kind of result set you actually need to determine if you need a left join.

Off course, if...