GilaMonster (10/24/2008)

---

Oh, and also, the name in sys.types will never return varchar(max), nvarchar(max) or varbinary(max). They'll return varchar, nvarchar or varbinary. To see if it's max or a defined length,...

Thanks!!

The example in BOL shows how they can be used interchangeably, but leaves out the key portion you showed me.

Thanks,

Tim

Jackal,

Is your question, are the maintenance tasks aware of the index fragmentation levels and rebuild/reorg only the indexes as necessary? I haven't found anything definitive, but I don't think so....

Yup, a restart is going to be my next step, but I really hate giving the answer, "I restarted it and the problem went away." 😛

Everything is negotiable, everything 😀

Tim

I wouldn't let Idera's list price scare you away. They are willing to make deals, especially around quarter or year end. We just finished up our negotiations and will be...

Thanks Sam, I found the same thing. Moving it out of the dataset worked just find.

Tim

To edit the boot.ini file...

1. Right-click My Computer, and then click Properties.

-or-

Click Start, click Run, type sysdm.cpl, and then click OK.

2. On the Advanced tab, click Settings...

Thanks, I think I got some of my readings mixed up there. Thank you for straightening me out. The update also turned out to be 10 + million row, but...

I went throught the same job change and struggled with the decision for quite a while. It was hard to leave the development behind and I do miss it from...

I got a bit more info now. THe end user is getting an error saying he doesn't have DTSRun. Even when I put in the full path of the DTSRun.exe...

Hi Sani,

I ran into this after a DBA left and didn't document his work. Unfortunately I couldn't find any way to reset the password and one reference in the Hitchhiker's...

That web cast (Best Practices for Deploying SQL Server 2005 on Large Storage Systems) is still available. I just downloaded it. Thanks!

Tim

Thanks, it was more curiosity not worry 😀

They are very small tables, 1 page and a dozen to 2 dozen rows. I doubt they are a performance issue, but why does the Logical Fragmentation go to 100?

Thanks,

Tim