Search Results | SQL Server Performance Forums

Behaviour of indexes when restoring a backup

Thread by: cjp, Sep 17, 2008, 5 replies, in forum: Getting Started

I back up databases by using the SQLS wizard (Sequel Server 2005). Occasionally, I need to restore the backup onto a different computer. When I do...

Securing databases through encrypting disks

Thread by: cjp, Sep 15, 2008, 5 replies, in forum: Getting Started

Since my previous posts on security, I have come under a degree of pressure at work to secure Sequel Server using the same methods that everyone else...

Installing SQLS 2005 64 bit to Vista 64 bit

Thread by: cjp, Sep 2, 2008, 9 replies, in forum: Getting Started

I was told by a Sequel Server Consultant that SQLS 2005 64 bit would install fine on Vista 64 bit. I've just tried...and it failed...several...

Queries based on derived tables: slow running

Thread by: cjp, Aug 28, 2008, 12 replies, in forum: Getting Started

In our medical research work, I feequently have to use derived tables in the form of views when I build queries: a typical example (that I used...

Securing a database

Thread by: cjp, Aug 19, 2008, 8 replies, in forum: Getting Started

Our epidemiology group is trying to develop a better security protocol for our data resources. Our statisticians can use standard encryption programs...

indexes - best practice

Thread by: cjp, Aug 13, 2008, 9 replies, in forum: Getting Started

I have been reading web articles on best practice for building indexes and, to some extent, am puzzled: on the one hand, experts advise covering all...

memory settings in SQL Server 2005 64_bit

Thread by: cjp, Aug 12, 2008, 6 replies, in forum: Getting Started

I am self-taught...and administer a large medical research database (over 100 GB anonymised data). I run 64-bit SQLS 05 (SP 2) on Windows Server 2003...