Solved

SQL Server 2005 defragmenting index primary key

Posted on 2012-03-19
3
284 Views
Last Modified: 2012-03-19
Can defragmenting, rebuilding or reorganizing a SQL Server 2005 index which is used as an identity specification primary key field for a table change the values in the field? (Destroying queries based on the primary key values)
0
Comment
Question by:machine_run
3 Comments
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 400 total points
ID: 37739545
No.  None of those activities will change the actual values in any column.  

More specifically for identity, once an identity value has been assigned, it will never change.
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 100 total points
ID: 37739643
"Destroying queries based on the primary key values" - only thing may be gone is(are) old cached query plans but this is a good not a bad thing. If you have some "sticky" cache you may need iisreset if a update statistics and sp_recompile on that table do not help.
0
 
LVL 1

Author Closing Comment

by:machine_run
ID: 37739684
THANKS!!!!!!!!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
passing parameter in sql procedure 9 63
Isolation level in SQL server 3 50
display data in text field from data base for updating 6 59
sql query help 2 53
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question