1. The minimum size of your TLog will be set based on the Model database (that db is the template used to build all other databases). Check the log file...

As John said, there are too many variables to go into here...in addition to what he suggests, you have to find out if there is a firewall between the two...

The biggest thing it fixes is the security hole that Slammer worm took advantage of. Without SP3a or higher, your SQL Server is vulnerable to the Slammer worm.

This is...

It could be many things....how does it authenticate permissions - with a domain controller? Is the connection broken and restarting services reconnect?

How old is your system? Is the hard drive(s)...

You might search for Lugiment's Log Explorer. Some log readers must be running before you need them, but I think I've heard people say that Lugiment's works on any...

You could try:

SELECT DISTINCT [SelectionValue] FROM [CIATStaging].[dbo].[ResponseSelectionDictionary] WHERE [SelectionValue] NOT IN (SELECT DISTINCT [SelectionValue] FROM CADS.dbo.AssessmentSelection)

OR IS NULL

-SQLBill

The issue is with NULL values. NULL don't equal anything and they don't not equal anything. NULL is like saying I don't know what this value is. ...

I had a 300+ GB database (just changed jobs) and I did DBCC INDEXDEFRAG. It doesn't grow the tlog as large as doing the reindexing. Plus, if I had...

BTW-you can put this in a Stored Procedure.

DECLARE @mytime INT

DECLARE @myhour INT

DECLARE @mymin INT

DECLARE @mysec INT

SET @mytime = (SELECT DATEDIFF(ss, , ))

SET @myhour = (SELECT @mytime/3600)

SET @mytime = (SELECT @mytime%3600)

SET...

I cannot use SP to do this

Why not?

Look up DATEDIFF in the Books OnLine. Get the results in seconds and then change the seconds into the result you want.

-SQLBill

Using DBCC DBREINDEX causes the log file to grow up to 2.5 times the size of the database. It has to keep track of the 'state of the database'...

The two records you provided are NOT duplicates. The dates are different.

This is why we ask for sample data and what result you want based on that sample data.

If...

Okay. You have it. Those two dates ARE distinct.

-SQLBill

Did you refresh your view?

-SQLBill

That's really not something for SQL Server to do. And it wouldn't happen fast - your query would have to go to the database, pull 20 records, go to...