http://social.msdn.microsoft.com/Forums/en/transactsql/thread/a30ef396-7b26-4d18-81d2-291412a67e7a

While it would be a good idea to fix your query , try the steps in the above post. Try also assigning a sepearet application pool to reporting services.

Do...

This is a good way to ask for help without providing any useful information at all.

At least provide the exact error message and the sql you are trying to run.

I...

maheshkrishnas (2/20/2012)

---

hi all

I need to Populate the city_summary table based on the customer and state table.

customer

cust_idcust_namecust_dobcust_citystate_idcust_phonecust_emailcreated_dtmodified_dt

1234Tim D2/2/1988Austin ...

Quick answer no , at least not in the traditional sense of what a computed column is , however the column can use a UDF which in turn references a...

Since your using the 16 digit number for credit card or atm card purposes you should know that there is a mod check for generating a 16 digit card number...

The certifications allow you to understand how MS SQL server allows for better data analysis. However as a data analyst the key to performing your job is understanding the data....

have you deleted using the control panel ?? or directly off the file system ?

The numbers seems quite high , are you sure the website load justifies the number of transactions per sec and the number of concurrent user sessions you are seeing.

If not...

First thing is what kind of data does this 16 digit number represent , is it an order reference number of a transaction id , or a really long phone...

when you install sql it unpacks some support files which are required to be extracted before the installation can continue. The files is usually created under a folder which is...

A practical long term solution which will scale is to have individual databases per website. This will help ensure better scale , security , feature driven applications and data management....

By file space do you mean space on the drive ( disk space) or the file has reached the max size for the file .

You mentioned ndf , but most...

You might want to check with a .net expert in that case , I guess there is a mismatch between the data types being used by the app to that...

non functional requirements , its got to do with the kind of expected loads and performance criteria the application is expected to meet on a minimum. A typical example...

You should have some NFR's about the kind of transactional activity expected for the database . Usually its a good idea to understand the NFR and then Size the mdf...