Not tested but it might work, I recommend you to do a test before!!!

There is the link:

http://tinyurl.com/y98ga5w

:hehe:

If your machine running with 64 bit, you don't need...

PAE is an Operatin System setting and you can find it at Boot.ini

PAE allows the OS to use more than 4GB of memory.

AWE allows the application to use more than 4GB.

Look at the BOL for more info about AWE configuration...

UT- (1/30/2010)

---

...

@jeff:

Thanks for this new idea, i am really looking forward to see the results BUT in your post you did not include the code to generate the...

Yes the CTE technique is the best to eliminate your duplicate values...so just do it!

Seems a lot of stuff in this event, it worth to attend!

I have seen that some developers practice to name the tables with the name of the application then table name ...etc etc

In tblTableName - tbl seems like schema - LOL :-P.

CirquedeSQLeil (1/22/2010)

---

SQLPirate (1/22/2010)

---

Using sp_mstablespace won't give you any unused space that the table is holding and sp_msforeachtable won't return internal tables. We were having issues pinpointing our space discrepancies, which...

I vote for CTE to find the duplicates in a table!

:w00t::cool::hehe:

Gift Peddie (1/21/2010)

---

You could try installing VS2008 with SP1 any free edition and then install it because I am running VS2008, SQL Server 2005 and SQL Server 2008 and it...

Try to uninstall Norton Internet Security 2010, then try again without Norton, anyway install any other anti virus appl instead!

Seems...

Did you do the upgrade from Vista to Win 7? Try to format everything then install Win 7 with all updates available and after that install from beginning the SQL...