Viewing 15 posts - 976 through 990 (of 1,478 total)
As far as I know Microsoft didn't document the way that the server decides on the sampling rate.
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/
May 25, 2009 at 2:51 am
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...
--------------------------------------------------------------
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/
May 25, 2009 at 1:45 am
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...
--------------------------------------------------------------
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/
May 25, 2009 at 12:49 am
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...
--------------------------------------------------------------
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/
May 21, 2009 at 6:40 am
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...
--------------------------------------------------------------
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/
May 20, 2009 at 10:06 pm
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...
--------------------------------------------------------------
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/
May 20, 2009 at 7:07 am
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....
--------------------------------------------------------------
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/
May 20, 2009 at 6:59 am
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...
--------------------------------------------------------------
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/
May 20, 2009 at 12:44 am
I'm not aware of such limitation. I would check it with the person that is in charge of the exchange server.
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/
May 19, 2009 at 8:11 am
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...
--------------------------------------------------------------
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/
May 19, 2009 at 5:24 am
I would set the filter on TextData column to the value - %create%table%#%
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/
May 11, 2009 at 10:31 pm
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...
--------------------------------------------------------------
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/
May 8, 2009 at 12:54 am
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...
--------------------------------------------------------------
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/
May 8, 2009 at 12:47 am
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. ...
--------------------------------------------------------------
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/
May 5, 2009 at 1:25 am
The database only handles the data it self. It has nothing to do with the presentation of the data. The application that gets the data should be able...
--------------------------------------------------------------
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/
May 5, 2009 at 12:39 am
Viewing 15 posts - 976 through 990 (of 1,478 total)