Dear AnandaKumar, (Is that one name or two - Ananda Kumar)

I had a discussion with Naresh. During this discussion, he explained to me about the current situation, what needs...

If you are talking about the TIMESTAMP datatype, you can't do it.

From the BOL:

TIMESTAMP is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is...

dominic cloud (12/23/2007)

---

SQLBill (12/21/2007)

---

Yes, it does matter. In one job I had a database that was 325 GB. I had an array of 28 disks (each 73 GB). ...

Book - Treason by Orson Scott Card.

I am on my third copy and the cover is falling off this one. Yes I have read it that many times. And...

Yes, it does matter. In one job I had a database that was 325 GB. I had an array of 28 disks (each 73 GB). And I had...

Also, you could temporarily rename the user databases (add .old after the file extension). Then reinstall SQL Server. Once it is reinstalled, rename the user database files (take...

have you tried moving the tempdb files back to where they originally were?

-SQLBill

If you restored from another location, then the owner may not exist on the new server. Remember - the owner is not just a name, it is also a...

Why FTP? You might want to try adding another step in the job that runs the COPY DOS command and just copies the file over the network.

-SQLBill

Look in the BOL, use the Index tab, enter DELETE, then choose the option for DELETE (Described). That will show the acceptable syntax for the DELETE command. The...

Here is a quote from the BOL:

Covered queries can improve performance. Covered queries are queries where all the columns specified in the query are contained within the same index. For...

For anyone reading this thread and using SQL 2005 who can't find the reports - they are introduced with SP2.

-SQLBill

What do you mean by 'before putting it into a table'? I would suggest setting up a DTS package, inserting the data into staging table, evaluate it there, and...

If your database is set to FULL recovery mode - you MUST do transaction log backups. If you don't, your transaction log will continue to grow until there is...

I don't know and no one but the client can answer that. Every company and every interviewer is different. I would guess they will look at both, but...