Viewing 15 posts - 1,456 through 1,470 (of 1,479 total)
YSLGuru (9/24/2008)
--------------------------------------------------------------
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/
September 24, 2008 at 11:59 am
andrew.critelli (9/23/2008)
--------------------------------------------------------------
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/
September 23, 2008 at 9:07 am
James Morrison (9/22/2008)
Recovery Model is Full
Database backup is Full ( run at 9 PM)
Transaction Log backups are daily at 12 PM CST
I will work with...
--------------------------------------------------------------
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/
September 22, 2008 at 11:58 am
los (9/22/2008)
--------------------------------------------------------------
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/
September 22, 2008 at 11:36 am
ALIF (9/17/2008)
saw the link but unable to understand, where to put the bak file location.
You should use @path variable for that.
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/
September 17, 2008 at 1:10 pm
In this case of course it will not cause fragmentation on your data file. The question is why do you want to shrink the log's size. If 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/
September 17, 2008 at 12:34 am
Adi Cohn (9/15/2008)
--------------------------------------------------------------
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/
September 15, 2008 at 10:39 am
If you want all databases to have log shipping, then you’ll need to setup each and every one of them. Of course you have a choice to 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/
September 15, 2008 at 1:45 am
You can write a small script with revoke key words in order to revoke permissions on working with an object. You can find more details (very easily) in BOL
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/
September 15, 2008 at 1:41 am
You can just disable the job that does the restore to the database. Another option that I sometimes used is to modify the job that does the restore. ...
--------------------------------------------------------------
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/
September 15, 2008 at 1:23 am
I’m not sure that you’ll get an answer from this forum. You are trying to create a table in Excel and this forum is about SQL Server. You’ll...
--------------------------------------------------------------
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/
September 12, 2008 at 4:41 am
I recommend a great article that among other things explains the statuses that each SPID can have. Don’t be alarmed by the article’s size. Most of it 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/
September 12, 2008 at 4:20 am
You are asking the forum’s readers to do the impossible thing – to help improve performance of a database that we know nothing about. If tuning the database and...
--------------------------------------------------------------
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/
September 11, 2008 at 6:02 am
From the way you wrote your question I understand that by successful you mean that at least one row was effected and not that the update statement caused a runtime...
--------------------------------------------------------------
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/
September 11, 2008 at 1:23 am
marco.crescini (9/5/2008)
Update statistics is enabled, and automatics.
Product version is 9.00.3068.00 (workgroup edition).
The o.s. is windows 2003 server SBS 32 bits. 4 mbyte ram
Yesterday I changed...
--------------------------------------------------------------
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/
September 5, 2008 at 8:06 am
Viewing 15 posts - 1,456 through 1,470 (of 1,479 total)