Viewing 15 posts - 1,051 through 1,065 (of 1,478 total)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 31, 2009 at 4:17 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 31, 2009 at 4:08 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2009 at 7:45 am
Just add the following to your where clause:
and abs(datediff(ms, b.dta_alteracao, a.dta_alteracao)) > 500
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2009 at 4:50 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2009 at 4:43 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2009 at 4:36 am
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?...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2009 at 3:10 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2009 at 2:10 am
Catcha (3/25/2009)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 30, 2009 at 1:08 am
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,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 29, 2009 at 9:31 am
MANU (3/28/2009)
Try specifying max server memory to 2GB and see how it goes.MJ
I don’t know why Dave is getting those errors, but I don’t think that granting less memory to...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 29, 2009 at 9:25 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2009 at 6:35 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2009 at 6:09 am
I would do it with an instead of trigger and not with a trigger.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2009 at 5:42 am
I think that this will do it, (at least the query's results have the same records that you showed as the results that you are looking for), but next...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 25, 2009 at 7:16 am
Viewing 15 posts - 1,051 through 1,065 (of 1,478 total)