Skip to main content

How many clustered indexes can be in one table?

One clustered indexes per table. 
For more info: https://msdn.microsoft.com/en-us/library/ms143432.aspx
Labels:

Comments

Post a Comment

Popular posts from this blog

Visual Studio 2010 Keyboard Shortcuts

These keyboard shortcuts are helpful. Some of them are not document in Visual Studio 2010 Express, for example: <Ctrl> F5 to run the application without debug <Ctrl> Period or <Ctrl> Space for code completion. <Ctr> <Shift> <B> to build the solution For more download the Visual Studio 2010 Keybinding Posters from Microsoft. Credit:  Visual Studio 2010 Keyboard Shortcuts - ScottGu's Blog DevCurry: 30 Favorite Visual Studio Keyboard Shortcuts
Post a Comment
Read more

SQL Questions and Answers - Part 3

What is a view? A view can be thought of as either a virtual table or a stored query. The data accessible through a view is not stored in the database as a distinct object. What is stored in the database is a SELECT statement. The result set of the SELECT statement forms the virtual table returned by the view. ( msdn.microsoft.com ) What is an Index? A Microsoft® SQL Server™ index is a structure associated with a table or view that speeds retrieval of rows from the table or view. An index contains keys built from one or more columns in the table or view. These keys are stored in a structure that allows SQL Server to find the row or rows associated with the key values quickly and efficiently. ( msdn.microsoft.com ) What are all the different types of indexes? These are different types of indexes in Microsoft SQL Server 2008R2: Clustered : A clustered index sorts and stores the data rows of the table or view in order based on the clustered index key. The clustered index is implemente
Post a Comment
Read more

Recent Activity

It’s fun to check my email account recent activity. Here is the fun. Someone attempted to log in to my account from other countries. It is good to check activity log in your Gmail, Hotmail, Yahoo, Facebook, and other accounts frequently.
Post a Comment
Read more