Matt Miller (10/15/2008)

---

You might worry about it if the columns making up the key change a lot. in a similar way to why you worry about fill factor for...

Thanks!

I'm attaching the 2 .vbs scripts here with .txt extensions to make it...

Thanks!

I will post the .vbs as a .txt file in the next day or so.

noeld (10/10/2008)

---

Marios Philippopoulos (10/10/2008)

---

I'm looking at the BOL documentation of view sys.sysdatabases (http://msdn.microsoft.com/en-us/library/ms179900(SQL.90).aspx) and the status column is supposed to have the value of 512 for an offline database.

Yet, when...

Steve Jones - Editor (10/10/2008)

---

It's bitmapped. Meaning the 512 is the bit (#9) that determines if the database is offline. So you OR it with 512 to check the status...

Another use of table variables - from Gail's last...

Grant Fritchey (10/8/2008)

---

If you're using table variables that are more than a few rows in size, switch them to temp tables. Except for a primary key, table variables have not...

Greg Charles (10/2/2008)

---

If the config file path was wrong in the job step, wouldn't that indicate that the job was changed rather than the package?

Unfortunately, I don't think a modification...

EdVassie (10/2/2008)

---

The more you read about how 32-bit Windows uses memory above the 4GB line, the more you will realise that the information quoted in your original post is correct....

What's stunning about this is that AWE is not even the ideal solution for SQL Server accessing more memory: only the buffer cache benefits from it.

So when it is stated...

Yes, I have been using this link to configure...

Thanks, I'm also quite incredulous about this...

I'm just stunned at...

Could it be that not mentioning AWE is...

Thank you, I've always thought so too, but AWE is not mentioned anywhere in these...

Tim Peters (9/30/2008)

---

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,...