384 reputation
1513
bio website core-inertia.com
location Australia
age 35
visits member for 3 years, 1 month
seen Aug 27 at 23:52

...


2d
awarded  Good Question
Jul
2
awarded  Curious
Sep
17
awarded  Famous Question
Aug
23
awarded  Notable Question
Aug
1
awarded  Nice Question
Jun
17
awarded  Popular Question
Nov
19
awarded  Notable Question
Nov
5
awarded  Popular Question
Oct
18
awarded  Notable Question
Jul
19
awarded  Yearling
May
24
awarded  Popular Question
May
14
awarded  Nice Question
Mar
30
awarded  Popular Question
Jan
26
comment should we replace some non-clustered indexes with clustered indexes
So the pk would be a combination of reportdataid and id? Is there ever a good reason to have clustered index not on pk?
Jan
26
revised should we replace some non-clustered indexes with clustered indexes
added 125 characters in body
Jan
26
asked should we replace some non-clustered indexes with clustered indexes
Sep
30
accepted Is it possible to restore sql-server bak and shrink the log at the same time?
Sep
29
accepted Will creating partitions reduce locking and how do we implement this in sql-server?
Sep
29
comment Is it possible to restore sql-server bak and shrink the log at the same time?
The client allocates 75GB to their transaction log. After restoring I currently change the log allocation to 1GB. If possible I would like to restore this database to a server where drives have less than 100GB of free space. Without having to restore to another server, truncate, backup and restore again.
Sep
29
asked Is it possible to restore sql-server bak and shrink the log at the same time?