Context Is Everything - Check Your Settings

Check 96 server and database settings to make sure they match your expectations in your databases with this script.

Advanced Display Table and Column Info

A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.

Find Default Data and Log File Paths

A function to wrap Alex Aza's "find default paths" solution.

Defaults

RE: Updating a Counter

If you know the format is always going to be -, yes, you can do it in a set-based way. You could do something along the lines of: WHERE MyNumber = SUBSTRING(MyID, 1, CHARINDEX('-', MyID, 1) - 1)

RE: string manipulation in ntext field

Hi Ismail,Would this work:select top 1 replace(cast(your_ntext_field as nvarchar(4000)),'Searchval','Replaceval') from yourtablenameIf you expect up to 8000 bytes and no Unicode characters, you could use varchar(8000) instead of nvarchar(4000).-Mike

RE: Are partitioned views not that smart?

It could be a bug. Since partitioned views are relatively new, I am not sold that there are not bugs in how they work. We've stayed away becuase of the complexity here and no large tables that would force me to look at those.If you figure somethign out, please post back here, I'd be interested […]

RE: help

No luck it still shows as 13.3333333333333 and not 13.33