After Work
Old Town Social
in Chicago, on North Ave, near Cleveland. Great selection of tap beers.
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
Sybase
»
DDL
»
DBA
»
Moving an object to another segment
When databases contain more segments than the usual default, it is
often necessary to move tables between segments.
/* move a table, in its entirety, to the new segment */
drop index 'employee.idx_employee'
go
create clustered index on employee (emp_id) on new_seg
go
/* leave table where it is, but future allocations go to the new segment */
sp_placeobject new_seg , 'employee'
go
/* leave table where it is, but future allocations for the
text column (employee_notes) go to the new segment */
sp_placeobject new_seg , 'employee.temployee'
go
/* leave table where it is, but future allocations for the
text column (resume) go to the new segment */
sp_placeobject new_seg , 'student.tstudent'
go
|
|
|
Get the latest Rocket99 news and tech tips via
|
