Louis Ventura (9/14/2010)

---

Thank you for a quick feedback 🙂

-> yes there are a lot of objects that depend on that table, but the table does not depend on any other...

Is there any reason you don't just alter the column?

ALTER TABLE <tablename>

ALTER COLUMN ID BIGINT

And then just reseed to your new starting number.

I've never done this on a 5 billion...

Is the SCOM query being blocked by anything?

I don't recall any inserts (or anything really) taking 30 minutes in my setup.

I'd wait for others to comment but I'm not sure I would perform a transaction of that size on temporary tables to begin with..how long does it take for the...

No...at least not that I've seen.

Last time I installed it, it looked similar to this:

http://andreasglaser.net/post/2009/11/18/Installing-SharePoint-Server-2010-on-Windows-Server-2008-R2-and-SQL-Server-2008-R2-Part-8-SharePoint-Server-2010-installation.aspx

About 1/3rd of the way down the page is the screen where you can enter the...

I prefer to initialize from backups with transactional replication..

Enable the 'initialize from backup' option, run a full backup, restore with norecovery onto target server, restore any transaction logs taken since...

Or same approach using CTE..posting it because I already had it written before I saw the previous reply 🙂

;WITH Counts AS (

SELECT txtJC as [state], COUNT(*) as [Count] FROM...

That's definitely a trigger of some kind.

Run this on the database:

SELECT * FROM sysobjects where xtype = 'TR'

Reads are just logical reads, either from buffer cache or physical.

It still takes the same number of reads and cpu cycles to run the query, but on the 2nd and...

Probably the same reason it wouldn't work if you tried to create a SP that way. It needs to be the first line in the batch (i.e. need a GO...

You need to specify WITH NORECOVERY on a differential restore, otherwise it will try to bring it live, which it can't do without the tail of the transaction log. Also..this...

Try this (using dynamic sql..feel free to modify the values to your needs of course)

DECLARE @DBNAME VARCHAR(50)

DECLARE @sql nvarchar(250)

SELECT @DBNAME=DB_NAME()

print @DBNAME

if(@DBNAME='master')

begin

SET @sql = 'create view [view] as select...

Careful, this is most likely...

In 2005/2008, Schema and Object Owner are two separate things that _sometimes_ line up. In SQL 2000 and earlier, they were more linked together, which is probably what you're comparing...

Start up SQL using the following flags (/f /T3608) in the command line

Or start the service like this: NET START MSSQLSERVER /f /T3608

These flags will prevent SQL from starting up...