I’m sorry, but I still have few questions. The main question is how do you decide about the order. If I was in one group and moved to...

Why is it important that there will be no gap? An ID should be used for identification regardless of the next and previous ID. Can you explain why...

It isn’t very clear what you want to do. Do you want to get a list of databases in the instance? If this is what you want you...

No, it can’t be done. This should be done in the presentation layer and not in the data layer (just like you can’t decide on font and color...

Just add the following to your where clause:

and abs(datediff(ms, b.dta_alteracao, a.dta_alteracao)) > 500

Adi

This should be done in the application because it is a presentation issue. You can do it from within SQL Server, but the fact that it can be done...

You didn’t specify how the rounding was done, so I’m assuming that it was using 500 ms as the “border” (bellow 500 ms rounded to the same second, 500 ms...

Please use the correct terms, so we’ll all understand what you need. Do you want to find a login that has no mapping to user in any user’s database?...

Here is something that I wrote a while ago. Notice that I only checked if the user belongs to the sysadmin server role, but you’ll might want to check...

Catcha (3/25/2009)

---

[Code]

select top 100 u58.deal_type_cde , ucb.*

from u58_deal_hist u58

join ucb_exp_hist ucb on u58.deal_id = ucb.deal_id

where ucb.batch_id = 297326

and u58.batch_id = 297325

and ucb.deal_id like 'IMGATD%'

[/code]

There are...

It also depends on the database’s size. If the database is very small and there is no need to use features such as restore to a point of time,...

I don’t know why Dave is getting those errors, but I don’t think that granting less memory to...

This depends on the trigger’s code. For example if inside the trigger you wrote something like that:

Waitfor delay '00:05:00'

You can expect a huge degradation. Without knowing the...

Let me see if I understand – You can restore a database on the server (and over write an existing database if it exists), but you can’t shrink the log...

I would do it with an instead of trigger and not with a trigger.

Adi