check out the page_count in sys.dm_db_index_physical_stats .

Is the sql server service running?

Are the protocols enabled.

Also check whether the user has proper credentials on the sql.

Going with dbo as the owner of the db and all the objects in it is might be best here.

when employees leave the company drop the db unless you...

Hi

check out Paul Randall's blog in SQLSkills.com.

Iam going with Gail .... Keep it short, to the point and only TRUTHS in there.

Hi

There are many things that can be done here.

First and foremost find out the reason why the CPU utilization is high.

Can you give us more details like your...

Hi

A backup strategy mainly depends on the amount of data loss that you can take and also the maximum time you can spend on restoring the database in case...

nice one jeff...

Hi

Can u tell the specific error that you are getting. you can also check sql logs for more details on the error.

My first take on the naming convention is that...

You can also use the upgrade advisor for this.

Hi

Do u mean dynamic queries?

Hi

One of the ways to do it would be to script the logins&users from the old server and run the script in the new server.

check you parameter declartions both in yur C# code as well as your procedure.

You can have only 1 primary key for a table. Primary key can constitute a single column or can have multiple columns.

If uniqueness of data is what you want you...

Hi

I have used comma delimited strings as params and they work quite well for a few values. If you have 100 or more values to pass as params , I...