SQL Express Help/Question

Mar 04, 2009 1 Replies

Rate this thread:

Lance 17 years ago

The time has come to shrink my database. I have done this many times before, but this will be my first time with SQLExpress.

I conenct to the database in the administrator, and type in the following for a query:

select * from journal

It runs for a good 20 minutes...then the results come up and there is nothing there. The headers for all of the journal entries are there, but there is no data and it says "0 row(s) returned"

What am I doing wrong?

Vote

Matt Hurst 17 years ago

select * from journal is a pretty intensive way just to find a count of how much you have there. A better way would be:

select count(id) from journal where time The time has come to shrink my database. I have done this many times before,

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required