I don't think that there should be a rule of thumb about the time interval of log backup. It depends on factors such as the importance of the data...

As far as I know Microsoft didn't document the way that the server decides on the sampling rate.

Adi

I don't think that we can see from your code where your problem is. We don't know anything about the views and tables that you are using. Without...

The size of the transaction log is affected by the number of transactions and also by the size of the transactions. For example if I have a table...

Your query can not use any index because you are using a wild card in the beginning of the string that you use to base your search on (and also...

I use sp_helptext and then I copy the text from the results pan to the query pan. One thing that I do at every place that I work is...

I think that noinit is the default behavior (I could be wrong about it). In any case if you don't want to preserve the old backups you can use...

If it works each time that you modify the SA password, then there is a good chance that someone else is also modifying the SA password after you modify it....

Here are 2 ways of doing so (just replace the value 51 with the real value):

select hostname, loginame from sys.sysprocesses where spid = 51

select host_name, login_name from sys.dm_exec_sessions where...

I'm not aware of such limitation. I would check it with the person that is in charge of the exchange server.

Adi

In all places that I worked at least part of the DBA team had administrative rights on the server that had SQL Server installation. There were some cases of...

I would set the filter on TextData column to the value - %create%table%#%

Adi

It is possible. If you’ll give us more details about what you are trying to do, you’ll get better help and examples. In any case the code bellow...

Actually the BMP files don’t prove that it is SQL Server 2005. We can see that the client tool is SQL Server Management studio, but that doesn’t prove that...

There is no way of doing it from the database. You can only do it from presentation tire. Upper() and lower() functions are not controlling the presentation. ...