Thanks Steve.

Yes, I was talking about the SSIS tool. Thanks for the link, I think that answers my question.

Dan

Hi guys,

Sample XML file below (this is just a sample - I have replaced the actual data but the layout of the file remains unchanged):

<?xml version="1.0" encoding="ISO-8859-1" ?>

<lxp xml_lang="en_US" start_date="2012-07-01"...

Hi.

Thanks for the suggestion but I'd tried running dbcc cleantable already and it didn't have any affect.

I've now been asked to shift my focus from freeing up the excess space...

Hi all,

Thanks for your advice so far.

When attempting to shrink the database using dbcc shrinkdatabase should I be using notruncate or truncateonly? I would have thought that truncateonly would be...

Index definitions as requested:

CREATE UNIQUE CLUSTERED

INDEX [PK_tblStoredQuotes] ON [dbo].[tblStoredQuotes] ([fldQuoteRef])

WITH

FILLFACTOR = 90

,DROP_EXISTING

ON [PRIMARY]

CREATE

INDEX [IX_fldEmail] ON [dbo].[tblStoredQuotes] ([fldEmail])

WITH

...

I don't know if this will mean anything to anyone but I ran the following command:

dbcc shrinkdatabase (dbmainV10, TRUNCATEONLY)

go

which returned the following resultset:

dbidfileidcurrentsizeminimumsizeusedpagesestimatedpages

311108799921281066103210661024

3132143343210240002098397620983976

312447128128447128128

I've don't really use shrinkdatabase as I prefer...

Hi, thanks for the reply.

This is the table layout:

CREATE TABLE [dbo].[tblStoredQuotes] (

[fldEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[fldQuoteRef] [int] NOT NULL ,

[fldTitle] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[fldFirstName] [varchar] (50)...

Yes, I apologise if you feel like I've wasted your time by posting in the wrong forum but I didn't realise this was 2005 only until too late.

Thanks for your...

Hi,

It's SQL Server 2000 Enterprise Edition SP4 and password is a varchar(128).

Thanks!

Hi rbarryyoung, thanks for your suggestions.

The table is definitely a table rather than a view and I was querying it directly rather than via any stored procedures or other...

If I put the password column at the end of the select list then everything appears to be normal. I've already suggested this to the developer who asked me to...

I thought it would clear things up if I copied the queries as they are (apart from that I've added the "top 3" and order by clause to simplify things)...

Hi Wilfred, thanks for your reply.

No, I'm not talking about the order in which the rows are returned. The actual data being displayed is different so even if only a...

Thanks Brian.

I guess this is good news if it means that I didn’t go far wrong with my log-shipping setup although I’m rather disappointed by the fact that once a...

Thanks for your help Michael!