Viewing 15 posts - 631 through 645 (of 1,155 total)
Ideally you should use separate service accounts for different servers and a recommended approach too.
But in real world, with this approach the management becomes complex if you have large no...
May 1, 2011 at 8:14 am
Granting only the required privileges to the Service account is a good practice.
But making SSIS Package creators as the Job owners is not a good practice bcs the jobs fail...
May 1, 2011 at 7:51 am
This is how you need to remove a file
http://msdn.microsoft.com/en-us/library/ms189493.aspx
D. Emptying a file
The following example demonstrates the procedure for emptying a file so that it can be removed from the...
May 1, 2011 at 7:36 am
Can you post the full error message ? Check the SQL syntax that you are using to run the Backup.
...
May 1, 2011 at 7:29 am
To schedule a DTS Package as a SQL Server Agent Job
1. Select a Job step of type Operating System (cmdExec)
2. Then enter the following command
DTSRun /N"DTS_Pckg_Name"...
April 30, 2011 at 4:17 pm
Cursor.....Cursor.... Cursor...... Kill that Cursor.... Has been the Rule.
Cursor is the Culprit. The query you captured is a Cursor. Cursors will cause 100% CPU often times. So try to avoid...
April 30, 2011 at 1:36 pm
It needn't be a Sysadmin. It may cause security issues as GSquared mentioned. Just make sure that it's a domain account and it has the necessary OS level privileges.
...
April 30, 2011 at 1:25 pm
Even though you select any other drive say D for install, some common files for SQL Server will always be installed on C drive no matter what.
...
April 30, 2011 at 1:21 pm
This High Performance Server is a Physical server or a Virtual Host server . If virtual Host Server then you will definitely notice some degradation on the performance . Resource...
April 30, 2011 at 1:09 pm
Is the "application Redirection to B getting Slowed Down" is happening always or you observed it just once or twice ?
...
April 30, 2011 at 11:57 am
What query are you running to empty the file ?
Thank You,
Best...
April 30, 2011 at 11:31 am
Warwick made a good explanation.
The difference in your case is unless the SQL Server Agent account is running under the service account you specified you can't use it as...
April 30, 2011 at 11:27 am
This could be due to the resource contention on the server or the network contention.
Start a profiler trace and a perfmon trace to find the root cause.
This could also be...
April 30, 2011 at 11:20 am
CXPACKET Waits are due to parallelism happening on the server.
What are your parallelism settings on the server ? Are you using Server level Parallelism or MAXDOP query hints ?
Parallelism...
April 30, 2011 at 11:13 am
If you separate your tables onto different File Groups but on the same disk, you will not get any performance improvement unless you place them on separate physical disks.
...
April 30, 2011 at 10:25 am
Viewing 15 posts - 631 through 645 (of 1,155 total)