Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Orphaned Primary Key Constraint02 Sep 2010 23:55 GMT6
I have a database that has somehow become corrupt in that there is a primary
key constraint in sysobjects that is no longer connected to the table (The
parent_object_id is invalid).
I am having diffciulty removing\reattaching this constraint, any ideas on
SQLState=S1000, NativeError=002 Sep 2010 22:39 GMT4
I am trying to use the BCP command to execute the following statement, but I
keep getting the following error:
Starting copy...
SQLState = S1000, NativeError = 0
ON SELECT STATEMENT01 Sep 2010 22:10 GMT5
Here's the database:
The database scheme consists of four tables:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
SQL 2008 R2 - ALTER INDEX performance degredation with compreessed indexes31 Aug 2010 22:35 GMT9
I'm doing initial tests with different aspects of performance using PAGE
compression with SQL 2008 R2.
I've noticed that rebuilding indexes using "ALTER INDEX" takes longer time
with PAGE compressed indexes than with uncompressed indexes.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.