Be sure to post the results of the above steps , it should help identify what issues your facing .

Poor DB design could also be a factor by the...

is the slow done periodic , such as during times when backups etc are being performed.

Have you tried running Perfmon to monitor the system and sql resource utlization

Any bulk operation...

32 bit sql need Awe and lock pages in memory if it needs to address more than 2 GB of memory.

So the second guy is right if you are not...

What kind of performance issue are you facing with SSAS. slow processing or low query speeds .

You might want to check the size of the dimensions.

Check if your using a...

I guess most people would agree with me when I say being a DBA is about on the job experience , it doesn't matter what age you acquire the experience.

However...

Nadrek (7/18/2011)

---

Jayanth_Kurup (7/17/2011)

---

Encryption of data is purely the organizations purview, if a company feels the data residing on laptops and tapes need to be encrypted then they should implement it...

are u running 64 bit sql server ? have you got lock pages in memory enabled , whats the max memory setting under the server properties ?

the getdate is using the OS timezone. I worked around the issue in sql 2005 using a clr fuction created to use syste.timezoneoffset object

Wouldn't a database snapshot work as the source , however i think a snapshot would server the purpose of the OP in this case without needing the scalable shared db...

It would help to know in what context you want the answer. Like Gail said; it creates a database using the model database as a template also there are certain...

If real time reporting is not requried you could consider shared database

http://technet.microsoft.com/en-us/library/ms345392.aspx

Replication is also a good solution

If your planning to make this more permanent feature , then maybe...

Is there an order to the way the scripts need to be executed , i.e script tables first then indexes and keys and then proc etc.

You could also look for...

Having just tried it , i noticed something that might be of interest.

If SQL is already compressing the backup then using winzp or winrar doesnt do a great job compressing...

With no access to the underlying infrastructure I wondered...

- Would a second/third filegroup on the E: drive help. If I moved clustered indexes to the secondard and other indexes to...

How are you backing up the database, I assume your using an ssis package which executes a tsql script which in turn expects some input parameters.

I dont know any...