When shrinking the log I have founnd I have to do the following:

backup log @database

with no_log

then I can shrink the log:

dbcc...

Alternatively you could use:

sp_spaceused

If you don't specify a table name it reports the space used by the database. You might need to run

sp_spaceused @updateusage = 'true'

to make...

Try DBCC CHECKALLOC ('<database_name>').

This gives details about every table in the database but does give the number of used pages and the number of reserved pages.

Jeremy

Tim,

If you do this:

select distinct firm, sum(balance) as balance

from Invoices

where ClintId = 1

Group by Firm

you will get a total by firm with a firm Id but it is still in...

Thanks for the info.

I have a csv feed from another system and I need to do inserts/updates in my system. Some of these feed files are large (can be...

Crispin,

Forgive my ignorance, but how do you loop through a table if you don't use a cursor?

Jeremy

If I understand it, you want to denormalise the data from many rows into a single string.

This might work:

declare @concat_string varchar(8000), @masterid int, @GeoState char(2), @GeoCity varchar(50), @prev_masterid int

/* Initialise...

Just be aware that you cannot nest insert ... exec statements.

What this means is that procedure a cannot use an insert #table exec procedure b if procedure b uses an...

I have found that DBCC SHRINKFILE does not always work.

I have had to do the following and then use DBCC SHRINKGILE to free up space:

backup log <database_name>

with no_log

Jeremy Kemp

I totally agree. I developed something very similar 4 or 5 years ago and it saves so much development time.

We now have over 60 different types of...

David,

I have found that with long running queries it is often better to break the query up into a number of smaller queries.

The main reason for this is that if,...

Nico,

Thanks for the suggestions but I actually want the product to be located twice in the product dimension as I need it to be reported into two separate groups.

Also, ...