GilaMonster (10/27/2008)

---

To get the pages deallocated requires putting a clustered index on, dropping and recreating the table or, in SQL 2008 only, rebuilding the heap ALTER TABLE < Table Name...

GilaMonster (10/27/2008)

---

stephen.wolfe (10/27/2008)

---

I was wondering if it would be as easy as restoring a backup, so, I could essentially do that now with the plain jane version of the database...

alex (10/27/2008)

---

Garadin (10/9/2008)

---

I was super excited about it, and while it may just be that I'm so used to coding without it that I can't appreciate it yet, so far...

Steve Jones - Editor (10/27/2008)

---

To me it's not horrible, but it is disappointing in compared to SQLPrompt. It works OK if you don't have anything else, but it's definitely a...

Lynn Pettis (10/27/2008)

---

Actually, I think it better to have standard columns like these listed first in the tables as they shouldn't change. This way, as new columns are added,...

You are probably looking at an application locking scheme where a row is entered in a table to identify when a record/row is locked by a user.

You can find out...

If you are looking to simplify the code, you could do something like:

If (@type In (1, 2))

Begin;

Execute ...

...

Actually, the better option is:

1) Disable all non-clustered indexes

2) Truncate tables

3) Import data

4) Rebuild all indexes

That is for a full refresh process where you are extracting all data from the...

No, what exactly are you trying to accomplish? If you can explain why you think you need a 'local' variable inside a CTE somebody here can definitely point you...

A couple of things you should be aware of with this:

1) In SQL Server 2000 - the following works: servername.database..objectname, in SQL Server 2005 it will no longer work. ...

Upgrade to Excel 2007 - which can handle up to one million rows per sheet.

That would be the short term solution - the long term would be to normalize the...

You need to reference the objects themselves in the other database. For example:

SELECT ...

FROM dbo.Table1

Accesses Table1 in the current database.

SELECT ...

FROM db1.dbo.Table1

Accesses Table1...

No - SQL Server 2000 is only available on IA64. You can, however - run SQL Server 2000 (32bit) on Windows Server 2003 x64).

Sounds to me like what you want is to select from ptSchedule and join in the results from a pivot on the description field from Appointments. If so, then...

Another way to look at this would be:

INSERT INTO dbo.Table (col1, datecolumn)

SELECT 'my column 1'

,getdate()

FROM dbo.TableWith10000Rows;

In the above statement,...