Viewing 15 posts - 586 through 600 (of 1,155 total)
1. Enable PAE (Physical Address Extension) at the OS level .
2. Enable AWE and Set Max Memory = 6 GB
3. Use Lock Pages in Memory
...
May 12, 2011 at 6:01 pm
Yep.. DBAs will be hired by the Cloud Providers like MS, Amazon, GoGrid....
...
May 12, 2011 at 5:40 pm
1. Even if you add additional memory, it is necessary to configure the above settings to get optimum Performance. If it is dedicated SQL Server BOx, then always enable Max...
May 12, 2011 at 5:36 pm
Use Transparent Data Encryption to encrypt the backups or a third part tool to encrypt them 🙂
...
May 12, 2011 at 5:26 pm
If they are personal, save them onto a windows folder on disk and separate them by categories. Take a backup of those scripts regularly. If they are shared scripts then...
May 12, 2011 at 5:20 pm
I'd go with SQL Server 2008 R2 . Better version with additional features.
Thank You,
Best Regards,
SQLBuddy
May 12, 2011 at 5:10 pm
Don't rely on Task Manager to check the SQL Server Memory utilization. Follow Gail's advice. She made it very clear.
...
May 12, 2011 at 5:07 pm
Check for the Entry Level Jobs in the Jobs board like Dice.com, CareerBuilder.com and Indeed.com etc.. You will definitely find one.
...
May 11, 2011 at 10:48 pm
Yep. You can do that. But you need at least 2 SQL Server instances to setup mirroring.
...
May 11, 2011 at 10:47 pm
As Homebrew mentioned, you can do Backup\Restore Method which reduced the amount of down time but the easiest approach would be the Detach\Approach.
Check these Links below.
http://www.sqlservercentral.com/articles/Upgrade/65872/
http://www.sql-server-performance.com/articles/dba/migrating_databases_checklist_part1_p1.aspx
http://pollus.blogspot.com/2008/06/easiest-sql-server-instance-migration.html
...
May 11, 2011 at 10:44 pm
Sp_startjob starts the Job but doesn't wait until the Job completes.
If you use that as a Job step then, the Job step will always succeed and goes to the next...
May 11, 2011 at 10:35 pm
I agree with Warren. When is the Job scheduled to Run ? When are you are you running the Sp manually ? Are the times adjacent ?
May be the...
May 11, 2011 at 10:24 pm
Follow Warren's advice.
1. First set Max Memory for SQL Server and also enable Lock pages in Memory.
2. If this server is dedicated for SQL Server then you can...
May 11, 2011 at 10:18 pm
Try these steps from EvilDBA
1. Lets assume you're local admin of server or domain admin.
2. RDP to the server.
3. On command prompt NET STOP MSSQLSERVER (stop sql server)
4. On command...
May 11, 2011 at 10:07 pm
May 10, 2011 at 9:55 pm
Viewing 15 posts - 586 through 600 (of 1,155 total)