Yes, it will - it is likely to cause physical fragmentation on the disk (at least...

You need to understand why the log file grew to the size it is. If it was through normal database activity, then there's no use shrinking since it will...

If it helps, you can set up a custom counter in performance monitor to return the number of rows in each of the tables you are interested in.

John

That's interesting - it contradicts what you said in your original post. Never mind - please will you describe how you're doing the backup of your database? If...

Excellent. Always good when the product behaves as documented.

John

From this page:

John

I'm still not entirely clear what you mean, but if you mean what I think you mean, this should get you started:

DECLARE

@Nowdatetime

,@Startdatedate

,@Enddatedate

SELECT

@Now= CURRENT_TIMESTAMP

SELECT -- startdate is date portion of two...

So what are you looking for, dockets that are more than two months old, less than two months old, or exactly two months old? Not sure whether your second...

Steve, I think this[/url] is the link you refer to.

We use the verify option on all our backups here, but we also have an automated process for test restoring our...

George

I think it depends. The ideal solution is for them to develop the solution on their own systems (possibly a copy of your database) and provide you with a...

You don't specify defaults in the query, you put them in the table definition. See the ALTER TABLE topic in Books Online for details. If you can't,...

There are several columns in your destination table that don't allow NULLs. Therefore you need either to specify values for those columns when you insert a row into that...

I think you need to change the LEFT JOIN to an INNER JOIN, but without DDL, sample data and expected...

Chris, are you sure about that? Referencing a column from the outer table will turn an outer join into an inner join if the reference is in a WHERE...

Also, I wouldn't recommend rebuilding with a blanket fill factor of 90 (or anything else). 90 is often a good choice, but not always - for example, if the...