Re: Questions - Repost
From: James (anonymous_at_discussions.microsoft.com)
Date: 06/22/04
- Next message: Dinesh T.K: "Re: Uploading data from Access to SQL Server"
- Previous message: BLiTZWiNG: "Uploading data from Access to SQL Server"
- In reply to: Andrew J. Kelly: "Re: Questions - Repost"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Jun 2004 19:25:04 -0700
Wow!.. andrew you are awesome.
James
>-----Original Message-----
>1 & 2- Always create a db at some small value say
100MB. Then immediately
>grow it to the size you think you will need for a year or
two. Since you
>can't shrink it smaller than what it was originally
created at you will be
>able to reduce the size to what ever you want later on if
needed. But by
>growing it to a large size you ensure you will always
have the disk space
>and the files themselves will most likely be contiguous
on disk.
>
>3 -- You always restore the Full first, then the latest
Differential and
>then any logs from the last Diff.
>
>4 -- Blocking is the result of locking by someone else
when you want to
>lock it. Both are normal in moderation. sp_who2 is the
easiest way to see
>who is blocking by looking at the Blocked column.
>
>5 -- It will rebuild all the non clustered indexes
since the clustered key
>is appended to all nonclustered indexes.
>
>--
>Andrew J. Kelly SQL MVP
>
>
>"James" <anonymous@discussions.microsoft.com> wrote in
message
>news:1effb01c457a9$82123f60$a601280a@phx.gbl...
>> 1. There is a Partition of Size 100GB and the client
asked
>> you to create 70GB Database. How do you plan for the
>> initial size of mdf and ldf files. The data growth will
be
>> 5 GB per month. Backup will be done to some other drive.
>>
>>
>> 2. For example If you create a 70GB dataabase and now
the
>> client asks to make it 30GB coz of poor business. how to
>> address this issue.
>>
>> 3. You are Following a backup plan for a database.
>>
>> 9PM - Full Backup ( only on sunday)
>>
>> In between every 2 hrs transaction log backup
>>
>> 9PM - Differential backup ( other week days daily)
>>
>> What is the sequence of restore if the Database is
missing
>> on Saturday 8:30AM.
>>
>> 4. Difference between Locking and Blocking?. What is the
>> quickest way to find which process is blocking ( without
>> profiler and time consuming approach)
>>
>> 5. A table has 10 columns.. 1 is clustured ( Not on
>> primary key in this case) and all other are non
clustured.
>> When you drop the Clustured Index, how it is going to
>> affect the Non clustured indeces.
>>
>>
>> Thanks for your time
>>
>> James
>>
>
>
>.
>
- Next message: Dinesh T.K: "Re: Uploading data from Access to SQL Server"
- Previous message: BLiTZWiNG: "Uploading data from Access to SQL Server"
- In reply to: Andrew J. Kelly: "Re: Questions - Repost"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
