Did you figure it out yet?

I imagined you need to take THAT column out of full-text first

then disable Full-Text on the table (optional)

run the ALTER command

then re-add the column back...

Lynn Pettis (9/11/2008)

---

Also, based on this siite (http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx) the Web Edition is ONLY licensed by processor at $15 per processor per month under the SPLA channel.

Again, all I can say,...

Note it's ONLY AVAILABLE in the Enterprise edition

so I mostly don't even worry about it as it's too pricey

But in short

ROW: replace fixed-length column data types with variable-length (so char...

I thought you can re-configure the account either in

SQL Server Configuration Manager

or Services.msc (sometimes work better than Config Manager)

Enter new credentials, and restart the service

SQL Prompt (I'm using 3.8) >>>> IntelliSense

It's just funny to see 2 prompts at the same time and causing a mess, if I don't disable IntelliSense

However, for machines without SQL...

I just ran the SQL 2008 install twice in the last 12 hours

There are many places that you may need to change to D:

1. Shared Features (c:\program files\....)

2. Shared Features...

http://sqlblog.com/blogs/greg_low/archive/2008/09/17/sql-server-2008-ebook-from-mspress-and-free.aspx

either SAVE using Ctrl-Shift-S

or F8 to display the toolbar, and click on the "Save" button

Again, it is copyrighted

I finished it on the weekend, it's a good read on...

I want my point back too

so, is it the SAME, or not?

I initial thought was I missed the UNION vs UNION ALL, but then it did have UNION ALL, so...

Thanks for the thread, I almost finished reading it

Then I tried to enable my Resource Governor and I got an exception, which explains it

Now I don't have to finish reading...

GilaMonster (9/14/2008)

---

jerryhung (9/13/2008)

---

Good, that's smaller scope. After noticing previous posts, we do also observe high IO and CPU as well

so my next step is perhaps change all TABLE VARIABLE ->...

GilaMonster (9/13/2008)

---

Table variables has the same scope as normal variables. Much less than a temp table. Their lifetime is limited to one set of commands (batch) sent to the server....

I have a question, hopefully you guys will know better than me

We use a lot of TABLE VARIABLES (not temp tables) in our select statements for our heavy traffic websites

Server...

Oops, didn't know I have to use NOEXPAND to use Indexed Views

all this time I thought when I selected on my view, it used the Clustered Index

Good thing it wasn't...

My curiosity is on "who picked the number 249?" and why?

Is there a significance that it's 255 - 6?

Thanks for the INDEX HINT, just used it, pretty cool

I am sure there are other features we'll find gradually in SSMS 2008

still getting used to the 'Activity Monitor' versus the...