Articles
Windows FAQ
Recommendations on Startup Programs on Windows 7 - Can I get rec...
Delete or Disable Scheduled Tasks on Windows 7 - Where to find t...
Security Impact of Scheduled Tasks on Windows 7 - What is the se...
Recommendations on Scheduled Tasks on Windows 7 - Can I get reco...
Disable "1ED570D2-8DDF-3F78-27CD-13850F70022F" Scheduled Task on...
Who's Online
11 user(s) are online (4 user(s) are browsing Jobs & News)

Members: 0
Guests: 11

more...

Blog: SQL Server DBA FAQ and Tips

A collection of 296 FAQs, tutorials and tips for SQL Server server and client tools for DBAs and developers written by FYIcenter.com tech team. The clear answers and sample codes can be used as learning tutorials or exam/interview preparation guides. | URL | Feed
Update: 2011/1/6 16:47:00 (Update)

FYIcenter.com Tech Team | Jan 06, 2011

How To Rebuild Indexes with ALTER INDEX ... REBUILD? - A collection of 23 FAQs on SQL Server database indexes. Clear answers are provided with tutorial exercises on creating and dropping indexes; clustered and non-clustered indexes; indexes created by p...


FYIcenter.com Tech Team | Jan 06, 2011

How To Defragment Indexes with ALTER INDEX ... REORGANIZE? - A collection of 23 FAQs on SQL Server database indexes. Clear answers are provided with tutorial exercises on creating and dropping indexes; clustered and non-clustered indexes; indexes create...


FYIcenter.com Tech Team | Jan 06, 2011

How to change the data type of an existing column with "ALTER TABLE" statements? - A collection of 16 FAQs on creating and managing tables on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting tables;...


FYIcenter.com Tech Team | Jan 06, 2011

How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD"? - A collection of 16 FAQs on creating and managing tables on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting tables; reviewi...


FYIcenter.com Tech Team | Jan 06, 2011

How To Delete an Existing Column in a Table with "ALTER TABLE ... DROP COLUMN"? - A collection of 16 FAQs on creating and managing tables on SQL Server 2005. Clear answers are provided with tutorial exercises on creating, renaming, and deleting tables; ...


FYIcenter.com Tech Team | Jan 06, 2011

How To Modify the Underlying Query of an Existing View? - A collection of 21 FAQs on SQL Server database views. Clear answers are provided with tutorial exercises on creating and dropping views; defining and viewing view columns; creating views from mul...


FYIcenter.com Tech Team | Jan 06, 2011

What Are Bitwise Operations? - A collection of 14 FAQs on Transact-SQL language character string and binary string operations. Clear answers are provided with tutorial exercises on concatenating character/binary strings; converting Unicode character str...


FYIcenter.com Tech Team | Jan 06, 2011

How To Name Query Output Columns? - A collection of 17 FAQs on SELECT statements with joins and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and F...


FYIcenter.com Tech Team | Jan 06, 2011

How to add an address record into AdventureWorksLT? - A collection of 6 FAQs on download and installing SQL Server sample scripts and sample databases. Clear answers are provided with tutorial exercises on downloading and installing AdventureWorksLT; at...


FYIcenter.com Tech Team | Jan 06, 2011

How To Add More Data to the Testing Table? - A collection of 20 FAQs on SQL SELECT query statements. Clear answers are provided with tutorial exercises on simple SELECT query to select specific rows and returning specific columns; applying group aggrega...




Copyright (c) 2015 FYIcenter.com
Search
Main Menu
Login
Username:

Password:

Remember me



Lost Password?

Register now!