Are you using SQL 2005? If so, can you post the execution plan please (save as a .sqlplan file, zip and attach please)

My initial thoughts - 90 000 out of...

It's best to do a reindex first and never to shrink.

Databases need to have some free space within them to work. If you shrink one down to the minimum size,...

Interesting. Ok, will take that back. There's nothing wrong with having begin tran and commit in different batches though. This does work without error

BEGIN TRAN

GO

WAITFOR delay '00:00:10'

GO

COMMIT TRAN

Looks like SQL...

I wasn't speaking about the occations when yuo need a cross join. If you need a full cartesian product, then just list the tables. Dunno about you though, but I...

If the database is in simple recovery mode (which it is) that option will have no effect. It's a older way of doing exactly what simple recovery mode does.

Also, that...

CPU or memory? (Title says one, post says the other)

Books online is your friend.

Here's an simplified version of a sample query from the help page on sys.dm_exec_sql_text

SELECT s2.dbid,

s1.sql_handle,

s2.text...

GSquared (4/10/2008)

---

It should reduce lock times. Since each batch is run as a set, breaking up the batches with "go" should let each one complete without holding more resources....

If you install the SQL Server workstation components, you'll ge BI development studio. It's Visual studio, with the BI projects in it. No need to download anything.

Faster for what?

What size DB do you have? OLTP or Datawarehouse style usage

How many concurrent users?

System processes (spid < 51) or user processes?

Are you running SQL with the windows fibres enabled?

What exactly do you mean by 'doesn't work'?

Very slow?

Errors?

???

What's...

Sounds like there might be some permissions problems somewhere.

Do you know what account SQL Express is running as? (SQL Server configuration manager will show you that)

At my current place we start with the technical interview. Since we're curently looking for people to do performance tuning and monitoring, I'll usually start with a very simple question...