Depends on what you mean by last 7 days.

Starting at the time it is run, if so then

RemovedDate >= dateadd(d,-7,getdate())

If starting at midnight time and including that day as day...

Depends. If it is a mid-size to large company it most likely will not be a skills interview but a targeted selection interview. They will ask questions like

Name a time...

Disonnect method is to break the connection but does no of the additional cleanup. To close it you should be using the Close method instead to disconnect the connection and...

Yes, 127.0.0.1 is the loopback address and effectively is the same as Local Host. Then you should be fine. Is it the same error still.

Also look out to your Hard Drive and make sure you haven't filled the drive up with something else. If there is no available space on the hard drvie your...

Also if the database is local to that server you may want to have them add an alias to that server that matches the one you are using in CLient...

Coalesce will have the same effect as IsNull in this case. Coalesce allows for more than one Null comlumn to be checked and go thru a list of checks, IsNull...

You could build something with SQL DMO if you want. I have some example code of getting the Scripts and the object types and sizes if you want to take...

Steve, none currently offers managed compares like this. They expect comparison based on object name.

If you mean the last date and time a table itself was changed, the answer is you cannot, at least with a tool to read the logs and if they...

If you mean the last date and time a table itself was changed, the answer is you cannot, at least with a tool to read the logs and if they...

JUst a suggestion. Instead of

Set @List = ''

select @List = @List + EmailAddress + ',' from MyTable where EmailAddress is not null

Do

select @List = IsNull(@List + ',','') +...

As they are exactly the same unless someone has forced a hint to use the ixPrimary index drop it.

With SQL if you are adding data to a table and the data will always be inserted as a new row at the end of the data then 100% or...

Data pages in Non-Clustered Indexes are just data pages like any other, they can be up to 8k in size.

If the 8k is reached and a new record needs...