Because of the parameter "DETAILED", it will perform like a dbcc updateusage with countrows....

BOL states:

.... The nonleaf levels of indexes are only processed when mode = DETAILED.

...

The DETAILED mode...

kubio (11/4/2008)

---

Hi all,

I had to write two separate queries to get what I want: that is, knowing the branchCode, get the email addresses from another table for two columns. This...

did you resync the users ?

at db level execute this to get an overview of the actions you need to take:

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare...

best to do is compare the execution plans.

With sql2005 SSMS you can even save and post the .sqlplan if you want to.

using set statistics io on and set statistics time...

FYI

When I design a table, it always contains a datetime created / user created column as well as a datetime altered / user alterd column.

(the altered columns maintained using...

Best is to format all stuff in the front end application. (because this way you keep the datatime characteristics as long as possible)

Check out convert in BOL

I advise to use aliasses in queries !

- a delete only operates on a single object !

so you should perform TWO delete statements !

Since you have DRI implemented (FK) ,...

That's even easier than I thought. (using the help/about in ssms) :hehe:

The WMI query results to :

Display Name: Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU...

Could you perform this query just as a test:

(=your query but used as a nested table expression)

Select *

from

(SELECT c.comm_id AS [ID],

...

you'll have to check the dll library of sql2005 at client level.

WMI softwarelist may also help out.

Check out the ranking functions of SQL2005.

There are a couple of good articles at CCS.

- http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

- http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/sequentialordering/2261/

- http://www.databasejournal.com/features/mssql/article.php/3773091

Especially because it is a 3th party product, I do not advise to add columns to tables.

To achieve the thing you want, create another logging table and populate that using...

As already stated, doing this with a trigger is not a good thing.

However, as also mentioned, the fastest way of doing it is using a service broker solution. (i.e. inner...

- Was the sql2000 query also remote and using linked servers ?

- are the linked server settings equal ?

- do the databases use the same ansi settings ?

- I...

Niyala (10/31/2008)

---

Thanks for the nice explanation.

How about the issue of licensing? If I have many databases in one instance, I guess I have to pay licence fee for a single...