Viewing 15 posts - 376 through 390 (of 1,179 total)
I guess testing of tool performance should not be based on the fregmentation. The reason is that index fragmentation is always vary through out the day due to many DML....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 12:48 am
kbhanu15 (3/26/2014)
what is the difference if we create index (at time create table or after insert data into that table ?)
Is this interview question?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 12:37 am
Find additional link with reference to this:
http://www.sqlservercentral.com/Forums/Topic128881-24-1.aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 12:06 am
Many people face this issue including myself. The issue would be with the Maintenance JOB creation. Check in delete backup location and extention of file should be trn
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 27, 2014 at 12:01 am
Try using SQL Server authentication. Refer following link for further detail:
http://support.microsoft.com/kb/321822
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 11:44 pm
You can use perfmon tool; refer the following link for further details:
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 11:39 pm
What is the error message? Do you have proper credentials for linked server and/or local machine?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 10:59 pm
What is transactions/sec on your server/database?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 10:49 pm
SQL Server Profiler is the best tool to use. You can use respective filters as per your requirement. However just keep in mind that Profiler is resource consuming and avoided...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 10:47 pm
I have double checked and working fine. I am able to set 90 min. without any issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 6:10 am
Yes, Grant Fritchey's books on performance tunning are good and best to start for performance tunning.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 4:53 am
Which window service?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 4:16 am
Cody K (3/25/2014)
Why did statistics need to be updated when attaching to the new version of SQL Server? I did a little googling but couldn't find a reference for it....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 1:14 am
It depends. What is the size of data?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 12:57 am
Cody K (3/26/2014)
Move the comment header to between the lines ALTER/CREATE PROC and AS.
What if 1000 PROC is replicating? Need to edit 1000 PROC?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 26, 2014 at 12:55 am
Viewing 15 posts - 376 through 390 (of 1,179 total)