473,769 Members | 6,583 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Indexing in sql server 2005

24 New Member
I have tables in my database, it's sql server 2005.
I heard some of them have indexing and some of them doesnot have indexing.

If i want to check whether it has indexing or not how do i do?

And if i want to create indexing how do i do?

Do i have to write script to create indexing or i can do from desing view of management studio?
if i have to write script to create indexing where do i write?

Thanks in advance for your help.
Mar 21 '08 #1
4 1312
ck9663
2,878 Recognized Expert Specialist
I have tables in my database, it's sql server 2005.
I heard some of them have indexing and some of them doesnot have indexing.

If i want to check whether it has indexing or not how do i do?

And if i want to create indexing how do i do?

Do i have to write script to create indexing or i can do from desing view of management studio?
if i have to write script to create indexing where do i write?

Thanks in advance for your help.
Open your Management Studio. Go to the table you want to check. Expand the table. Check the index in Indexes.

-- CK
Mar 21 '08 #2
pratimapaudel
24 New Member
Open your Management Studio. Go to the table you want to check. Expand the table. Check the index in Indexes.

-- CK


Thanks but how do i do indexing?
Mar 21 '08 #3
ck9663
2,878 Recognized Expert Specialist
Right click on the "Indexes" tree and choose New Index.

-- CK
Mar 21 '08 #4
pratimapaudel
24 New Member
Right click on the "Indexes" tree and choose New Index.

-- CK
Thanks for you reply.
I will try now.
thanks
Mar 22 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

15
7801
by: Jay | last post by:
Hello all. I've recently transferred our web sites from a Windows2000 server to a Windows2003 server. The transfer went almost flawless until I noticed that our search function isn't working anymore. I'm using an ASP script to use the Indexing Services and have set up my catalogs and directories but I'm getting a 'type mismatch' on one of my Server.URLEncode commands. Do I need to obtain a new script to utilize the Indexing Services of...
2
1399
by: Brent | last post by:
Hi, I have indexing servicing working fine on my test server for a search engine in C# ASP.NET, but when I tried to make one on our live server, its not working correctly. The index only returns results for pages in the root so far. It seems like the indexing doesn't want to finish. It is listed as Paused(User Active) or whatever it says. I tried to do a manual "Rescan (Full)" but it doesn't kick in. It just stays paused. The server is...
108
6455
by: Bryan Olson | last post by:
The Python slice type has one method 'indices', and reportedly: This method takes a single integer argument /length/ and computes information about the extended slice that the slice object would describe if applied to a sequence of length items. It returns a tuple of three integers; respectively these are the /start/ and /stop/ indices and the /step/ or stride length of the slice. Missing or out-of-bounds indices are handled in a manner...
4
3271
by: Steph | last post by:
Hi - Trying to chase down a baffling performance issue. Our database has been running very slow lately. So we are performance tuning the database. In doing so, we created a copy of our production database. In that database, I changed one clustered index on a table to try to improve performance. I ran one query - saw a slight improvement - but saw "lazy spool" in the execution plan. I tried to change it back to the original index by...
7
1820
by: Ryan | last post by:
I have a bit of a problem with regards an indexing strategy. Well, basically there is no indexing strategy on a set of data I have at work. Now, I didn't create the design as I would have allowed for this. OK, so there is primary key (clustered) indexes (mainly composite keys), but no other indexes on the tables. As you would expect, the performance leaves a lot to be desired. A hell of a lot. We have several million rows in a lot of the...
5
2708
by: R.A.M. | last post by:
Hello, I am learning SQL Server 2005 Expres Edition. I need to create full text index on Books.Remarks column in my database. I tried: CREATE FULLTEXT CATALOG FTC_Books AS DEFAULT CREATE FULLTEXT INDEX ON Books (Remarks) KEY INDEX IX_Books_Remarks ON FTC_Books Unfortunately I got error:
3
9559
by: Chung Leong | last post by:
Here's the rest of the tutorial I started earlier: Aside from text within a document, Indexing Service let you search on meta information stored in the files. For example, MusicArtist and MusicAlbum let you find MP3 and other music files based on the singer and album name; DocAuthor let you find Office documents created by a certain user; DocAppName let you find files of a particular program, and so on. Indexing Service uses plug-ins...
0
1938
by: rclark30 | last post by:
Hello to everyone out there. I am a non SQL person TRAPPED in a nightmare! The long short is we have a CRM 3.0 database that is running in SQL 2005 on a Windows 2003 SP1 Server. (HP ProLiant ML350 3.0ghz 3.5gb RAM) Server started running out of drive space and could not hold transaction log. Would basically lock up everyones sessions until flushed. Put a cap on log size until drives could be purchased and installed. Perfomance suffered...
2
8108
by: =?Utf-8?B?SmVycnkgQw==?= | last post by:
I have a server 2008 IIS 7.0 with indexing service installed. I have created the catalog and have a test page using these posts: http://kbalertz.com/954822/install-configure-Indexing-Service-Windows-Server-computer.aspx http://kbalertz.com/820105/Application-Query-Indexing-Service-Catalog-Using-Visual-Basic.aspx I can search some files .xls .doc and others but It will not find anything in .pdf
0
9590
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9424
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10223
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10051
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9866
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8879
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5448
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3968
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3571
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.