Are you connected locally to the system? Was there a network outage?

Check if SQL Browser services is running.

have u had a look at this

http://www.secretgeek.net/boring_sql_one.asp

Have u tried connecting to the server any other way?

Would 4 GB on OS RAM be sufficent for a database being used with sharepoint ?

Since your a developer and have access and decide the backup plan for the production databases I wonder if they are really that important?

A simple recovery model means you...

I dont think there is anythig wrong with having 300 columns in a table , however are they all sparse columns ?

the three groups should be the starting place...

Are u familiar with Kimball dimensional modelling. Its a good place to start in terms of designing the OLAP DW.

A few things I have learned over the years...

hi jeff , i installed google on my system but it looks like its not working , all i see is a white screen with the textbox and a...

select YEAR(getdate()) to get the year unless a year has ony one date what ur asking is not possible , or could result in error. in order to help...

The long and hard way would be to reinstalled sql server express again , and then uninstall it from program files , just like you would for any other program.

Never...

Hmmm , nightmare is an understatement , but if you cant change the DB Design atleast change the approach. Try to convince your vendor and management to federate the databases...

Run the below command

sp_configure 'show advanced options',1;

GO

RECONFIGURE

GO

sp_configure 'Agent XPs',1

GO

RECONFIGURE ;

GO

sp_configure 'show advanced options',0;

The terms have acquired different meaning with SQL Azure now.

SQL Azure uses a sync framework to help sync local SQL instances to the SQL Azure cloud.

Replication allows you to...

There are some greate paid tools from redgate and quest like already mentioned. But most of the time you will customer scripts being used by most DBA. It gives...

While companies are trying to move to locations where laws are lax there are others that are forced to create entire datacentres for one market (china). the laws can be...

It might be better to change the recovery model to BULK Logged the next time you import large volumes of data