Search Results

Search found 24132 results on 966 pages for 'non clustered index'.

Page 6/966 | < Previous Page | 2 3 4 5 6 7 8 9 10 11 12 13  | Next Page >

• Multiple columns in a single index versus multiple indexes

  - by Tim Coker

  The short version of my question is what's the difference between three indexes each indexing a single column and one index indexing three columns. Background follows. I'm primarily a programmer but have to do DBA work because we don't have a DBA. I'm evaluating our indexes versus the queries run against a particular table. The table as 3…

  Read the article

• SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance

  - by pinaldave

  Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good. SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server SQL SERVER – What the Business Says Is Not What the Business Wants I received many comments on Why Database Shrinking is bad. Today we will go over a very…

  Read the article

• lucene index missing files

  - by Akhil

  I have _0.cfs file of a lucene index directory but segments.gen and segments_2 are missing. Can I generate the segments.gen and segments_2 files without having to regenerate the _0.cfs file. Does these "segments" files contain any index specific data, which will thus force me to regnerate the entire index again. Or can I just generate the…

  Read the article

• Index of elements, jQuery or Javascript

  - by ozsenegal

  I've a table that contains 3 columns. I need to bind an event that fires off whenever one of those columns is clicked using jQuery. However, I need to know the index of the column clicked. i.e: First column (index 0), Second column (index 1), Third column (index 2), and so on... How can I do that?

  Read the article

• Improving performance of cluster index GUID primary key

  - by TheVillageIdiot

  Hi, I've a table with large number of rows (10K+) and it primary key is GUID. The primary key is clustered. The query performance is quite low on this table. Please provide suggestions to make it efficient.

  Read the article

• Beware Sneaky Reads with Unique Indexes

  - by Paul White NZ

  A few days ago, Sandra Mueller (twitter | blog) asked a question using twitter’s #sqlhelp hash tag: “Might SQL Server retrieve (out-of-row) LOB data from a table, even if the column isn’t referenced in the query?” Leaving aside trivial cases (like selecting a computed column that does reference the LOB data), one might be…

  Read the article

• Reading from compressed lucene index

  - by Akhil

  I created a lucene index and compressed the index directory with bz2 or zip. I donot want to uncompress it. Is there any API call that can read the index from this zipped directory and thus allow searching and other functionalities. That is, can lucence IndexReader read the index from a compressed file. I saw that Lucnene…

  Read the article

• After adding index Execution Plan SqlServer keeps suggesting the index

  - by Lieven Cardoen

  If I run the execution plan of an sp, Management Studio suggests an index. I add the index, run the execution plan again, and it keeps suggesting the same index... What am I doing wrong here? I already restarted SqlServer and Management Studio, but that's doesn't help.

  Read the article

• Use a vector to index a matrix without linear index

  - by David_G

  G'day, I'm trying to find a way to use a vector of [x,y] points to index from a large matrix in MATLAB. Usually, I would convert the subscript points to the linear index of the matrix.(for eg. Use a vector as an index to a matrix in MATLab) However, the matrix is 4-dimensional, and I want to take all of the elements of the…

  Read the article

• jquery get the index of a row?

  - by KnockKnockWhosThere

  I'm trying to write a function that will do something if the the row index is 0, and then something else if the row index is greater than 0. The zero part is working, but I can't figure out the syntax for rows that have an index greater than 0. For the tr[0] row, I'm doing this: if($("#mytable > tbody > tr…

  Read the article

• Assigning Array with literal string index to an array with numeric index

  - by anita

  How to Assign an Array with literal string index to an array with numeric index. [IN PHP] Both have the same length...for example Literal array(HELL0=somevalue1,BYE=somevalue2) Numeric index array(1=somevalue1,2=somevalue2) [Expected result in second array] Both have same length / count of values 2. Pls…

  Read the article

• foreign key and index issue

  - by George2

  Hello everyone, I am using SQL Server 2008 Enterprise. I have a table and one of its column is referring to another column in another table (in the same database) as foreign key, here is the related SQL statement, in more details, column [AnotherID] in table [Foo] refers to another table [Goo]'s column [GID] as…

  Read the article

• Oracle Database 11gR2: Building an ASM Clustered File System (ACFS)

  Oracle Database 11g Release 2 (11gR2) integrates a new ASM-based file system -- the ASM Clustered File System -- that offers the ability to store files other than database specific files like online redo logs, control files, and datafiles. This article demonstrates how to install and configure a new Oracle 11g…

  Read the article

• Clustered instance will not start after removing builtin admins

  After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things.

  Read the article

• Thunderbird 3, must manually re-build folder index

  - by david

  I have a couple of installations of thunbderbird three that aren't updating the IMAP folders correctly. I have to manually re-build index of the foldres for it to refresh. any ideas how to fix this problem? Im not using synchornishing.

  Read the article

• How remove/de-index a page from Google?

  - by Jason

  On the results page when I Google "e-luminate", the 3rd and 4th link seems to point to specific directory deep within the folders which stores the images. How can I get rid of these 2 results from Google search results? How can I get Google to de-index it? I checked on the server and the folders did not seem…

  Read the article

• Index fragmentation and reorganizing database pages

  - by TiQ

  Say you have a database with heavy index fragmentation. Say this database also has a lot of free space due to frequent deletes in its data file. This free space is not contiguous. If I rebuild all indexes to remove fragmentation and then reorganize the database pages so allocated pages and free pages are…

  Read the article

• Problem with z-index

  - by ripper234

  I'm trying to use z-index to layer a button and a div. The button appears behind the div, while according to z-index it should be in front of it. Here is the style elements associated with the button & div as captured by Firebug: Button button { position:relative; z-index:2; } Site.css (line 356)…

  Read the article

• Array Undefined index error (notice) in PHP

  - by Alex

  I have this function: function coin_matrix($test, $revs) { $coin = array(); for ($i = 0; $i < count($test); $i++) { foreach ($revs as $j => $rev) { foreach ($revs as $k => $rev) { if ($j != $k && $test[$i][$j] != null &&…

  Read the article

• oracle select query - index on multiple columns

  - by CC

  Hello. I'm working on a sql query, and trying to optimise it, because it takes too long to execute. I have a few select and UNION between. Every select is on the same table but with different condition in WHERE clause. Basically I have allways something like : select * from A where field1 <"toto"…

  Read the article

• Static and Non Static Method Intercall in Java

  - by Vishal

  I am clearing my concepts on Java. My knowledge about Java is on far begineer side, so kindly bear with me. I am trying to understand static method and non static method intercalls. I know -- Static method can call another static method simply by its name within same class. Static method can call…

  Read the article

• Applying the Windows Experience Index to Servers

  - by Scott

  I finally convinced upper management that we need a computer replacement plan, and I've been tasked with making an inventory of what we have and determining what needs to be replaced this year, next year, the year after, etc. I had to use some sort of criteria to back up my recommendations, so I…

  Read the article

• How to print 4 index cards on a single A4 sheet in Word 2003

  - by Anna

  I have an index card designed in Word. It's fairly complicated with graphics, borders and background. The page layout has been set to landscape and with size set to 4x6. How can I print this, 4x per A4 landscape sheet? I cannot for the life of me work it out. The printer always seems to do a…

  Read the article

• update-apt-xapian-index hogs CPU, even when Update Manager is set to not check for updates

  - by Dave M G

  I have a slightly older laptop running Ubuntu 11.10. It runs fine, but frequently, when I start it up, the CPU monitor in my Gnome Panel shows 100% usage for for what can be up to five minutes or so. It seems that the offending process is update-apt-xapian-index, which, if I understand…

  Read the article

• in MSSQL Server 2005 Dev Edition, I faced index corruption

  - by tranhuyhung

  Hi all, When running stored procedures in MSSQL Server, I found it failed and the DBMS (MSSQL Server 2005 Dev Edition) notified that some indexes are corrupted. Please advice me, here below is DBCC logs: DBCC results for 'itopup_dev'. Service Broker Msg 9675, State 1: Message Types…

  Read the article

< Previous Page | 2 3 4 5 6 7 8 9 10 11 12 13  | Next Page >