Maybe I am misreading this - but it sounds like all you need to do is change the join in the view from an inner join to a left outer...

How many pages do these tables have? Small tables will always show a high level of fragmentation.

rbarryyoung (8/28/2008)

---

Vika (8/28/2008)

---

I thought that db and logs are just files. When files are deleted they go to the Recycle Bin. Maybe it's a crazy idea, but would it be...

What does 'it does not work' mean?

I just copied the code you posted and ran it and got the expected results. Are you getting any errors?

Can you run the following and verify the results:

SELECT COUNT(*)...

Yes - you are right.

Lookup LIKE in Books Online - you can use the following:

SELECT [columns]

FROM table

WHERE column LIKE 'user1_%';

The express edition does not come with SSMS. You can download a free version SSMSE from Microsoft and use that.

Yes, you can use the 2005 client tools to manage SQL Server 2000. You can even manage a 2000 instance with the 2008 tools, however - there are a...

The source I used for this question is: http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

Another resource is: http://msdn.microsoft.com/en-us/library/ms175527.aspx

Jeff Moden (8/23/2008)

---

So far as any type of formatting goes, yeah... I thought I stressed that final formatting should probably be done at the GUI level... maybe I didn't stress...

Please review this article: Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/

For your question, lookup the GROUP BY operator in Books Online. Based upon what you have posted, that is the best guess I...

When you reply to a post - scroll down a little further and you can select your method of notification. Whatever you select will be saved as your default.

Right at the top is your Control Panel. Select that, scroll down to Topic Subscriptions and you can mark all topics as Unsubscribe.

You can review the following articles to get an idea of how to get this done:

Cross-Tabs: http://www.sqlservercentral.com/articles/T-SQL/63681/

Tally Table: http://www.sqlservercentral.com/articles/TSQL/62867/

In SQL Server 2005 you can use the row_number() function and OVER...