Viewing 15 posts - 44,881 through 44,895 (of 49,571 total)
Yeah, it's different in 2005 and 2008. That number's too large to be an object ID. It's actally a partitionID. To get the objectID back -
select object_id from sys.partitions...
August 26, 2008 at 1:40 am
I've seen it a couple times, but I have no idea what causes it. It doesn't happen every time a database is detached.
August 26, 2008 at 1:38 am
Yeah, that works. Sorry, I misread your question, thought you were adding a default to an existing column.
The WITH VALUES is only valid if you're adding a new column...
August 26, 2008 at 1:35 am
Be careful with DTA. It has a habit of over-recommending things. Take its recomendations with a large pinch of salt and test carefully before putting the indexes it suggests in.
I've...
August 26, 2008 at 1:08 am
onlo (8/26/2008)
August 26, 2008 at 12:43 am
Firstly, don't delete your log. You are asking for a suspect database doing that. It will grow when you do index rebuilds.
It could be a number of things. If you...
August 26, 2008 at 12:41 am
Are the instances all enterprise edition? Standard edition ignores locked pages.
What's the max memory set to on each of the instances?
August 26, 2008 at 12:34 am
Defaults only apply to new rows inserted. If you want the existing rows with null to change to that value, you'll have to run an update statement.
August 26, 2008 at 12:29 am
If you're working with 2005, take the 2005 exams. They're not redundant with SQL 2008 out and I believe there will be an upgrade path.
I wrote one of the betas...
August 26, 2008 at 12:28 am
Are you getting an error message? If so, what? How are you trying to set the primary key?
August 26, 2008 at 12:09 am
Colmn order doesn't really have a meaning in SQL. It just determines how the columns appear when the create table is scripted and how they are returned if SELECT *...
August 26, 2008 at 12:07 am
Duplicate post.
Direct replies to http://www.sqlservercentral.com/Forums/Topic558592-149-1.aspx please
August 25, 2008 at 11:46 pm
Not the backup.
You said the database had being detached. Can you reattach the database files to the SQL instance?
August 25, 2008 at 11:38 pm
armintucakovic (8/25/2008)
As I understand it rebuilding indexes will update stats automaticly equal to full scan and so I dont have to do that? correct?
Correct. There are a number of scripts...
August 25, 2008 at 10:37 am
HanShi (8/25/2008)
For performance it is better to NOT shrink the LOG-file. It takes lots of I/O for the log-file to expand each time.
In addition it causes internal log fragmentation...
August 25, 2008 at 10:33 am
Viewing 15 posts - 44,881 through 44,895 (of 49,571 total)