Short cut Keys in MS-OFFICE

Shortcut key usage
Ctrl + u To Change Database
Ctl + Shift + U To Change Upper Case Letters
Ctrl + Shift + L To Change Lowercase Letters
Ctrl + K, Ctrl +C To Make Comment
Ctrl + K, Ctrl+U To UnComment
CTRL+SHIFT+ HOME To select all text from beginning

CTRL+SHIFT+END To select all the text from the end
TAB To Move Selected Data To Front
Shift+Tab To Move Selected Data To Back
Ctrl+k, ctrl+k To Add bookmark
Ctrl+k, ctrl+l To Remove All Bookmarks
Ctrl+k, Ctrl+n To Go Next Bookmark
Ctrl+k, Ctrl+p To Go Previous Bookmark
Ctrl+J To Get Database Objects(From 2008)
Ctrl+L To Know the Querry Execution Time
F8 Object Explorer
CTRL+ALT+T Template Explorer
CTRL+ALT+L Solution Explorer
F4 Properties window
CTRL+ALT+G Registered Servers explorer



create table dbo.tbChar
(
id int identity(1, 1),
Data char(7000),
);

create table dbo.tbVarChar
(
id int identity(1, 1),
Data varchar(7000),
);

-- Run the following two lines 20 times
insert into dbo.tbChar(Data) values('A');
insert into dbo.tbVarChar(Data) values('A');

sp_spaceused tbChar
tbChar 20 200 KB 160 KB 8 KB 32 KB

sp_spaceused tbVarChar
tbVarChar 20 16 KB 8 KB 8 KB 0 KB