I have done the DBCC DBREINDEX on a 180+ GB database. It did not increase the database (.mdf) file. It DID increase the log (.ldf) file by quite a lot.

The...

My only issue with the question was that we weren't supposed to test it. We were supposed to determine the answer by ONLY reading the scripts. That will NOT identify...

I would do a AJ suggests, but the reason for it is that when a datetime value is being inputted, it's being inputted as a string and SQL Server implicitly...

No. You have it backwards. SQL Server interprets an empty string as a 0 not the other way around.

' '  = 0

but

0 = 0

-SQLBill

You can't. TIMESTAMP is not a date and time. It's a 'version'. Used to uniquely identify a row. It's changed everytime a row is modified.

From the BOL:

timestamp is a data type...

No. The correct answer is NOT D. It's not a SYNTAX error. If anything it would be an 'Invalid Object' error, which was not an option.

If you had posted in...

By the way....SQL Server does not like to use .mdf/.ldf files across a network. It likes them to be on the same system as the SQL Server software.

-SQLBill

Could try this....stop the services. That takes all the databases offline. COPY them to another location (or to a new name like master.old). Then delete the system databases.

Then do your...

Those fields are only populated if the user is logging on with a Windows Account (Trusted account). If a SQL Server account (SQL Server authentication) is being used, those fields...

DBCC UPDATEUSAGE 'refreshes' the sysindexes table. Without running that command, Enterprise Manager, sp_spaceused and other commands can return incorrect information. I ALWAYS run that command after I rebuild or defrag...

Use Enterprise Manager, drill down to Management, expand that. Right click on Backup. That should show you where your backups are designed to go to.

What version are you using and...

Why were you doing a reindex? Were your indexes fragmented? If they weren't fragmented then there won't be any noticable change.

Did you run DBCC UPDATEUSAGE after the reindex?

-SQLBill

Very basically, dates and times are not STORED in SQL Server in any format (style). They are stored as an eight byte value.

It's how they are DISPLAYED and inputted that cause...

Nope, clustering does require the Builtin/Admin role. I haven't seen any 'fix' or 'work around' for this.

-SQLBill

Now's the time to start gathering statistics if you haven't already.

What time(s) of day does this happen?

Is it always the same time?

Is is every day? If not, is it...