Hi everyone I have more than 100 SQL Server jobs scheduled to run simultaneously and continuosly. Several of these jobs are not running and with the status 'Waiting for a Worker thread'. Can anyone please tell me what this status means and and how to avoid it ? I have tried increasing the CPU...

Can be contract or permanent. Salary range is $60k/yr, depending on experience. Position is located in Lake Worth, Florida. ---- The Sr. Data Systems Analyst (DSA) plays a pivotal role in the development of MagNet operational applications. Reporting to the Sr. Solutions Architect, the Sr. DSA is responsible...

Good working knowledge of MS SQL Server 2000/2005. Experience in working with multiple 50GB to 100GB mission critical databases.writing, debugging and optimizing stored procedures, functions, triggers and cursors. DB Structure Design and Optimization. Reporting Services experience an advantage. Visual...

All, I do not like using the native sql server 2005 maintenance plans but rather script out tasks to perform maintenance. I do the following... Backup databases nightly (full) using Redgate. 15 minute t-log backups using Redgate. Defrag any index greater than 30% fragmentation rate every night (the logs...

HI Friends One of server my job is getting fail. It will showing log speace is full but log speace is 24GB But actually my log file actual speace is 30GB How can i handile this isssue plz help me urgent Thanks MS

Should have good working knowledge in MS SQL Server 2000/2005. Should able to debug and analyze problems in complex environments. Hands on exp in Performance Tuning. Strong technical and analytical skills with special emphasis on MS SQL Server, Analysis Services, Crystal Reports. Should be good at writing...

YOu may not be update system tables data directly in this case. Try applying the SP2 for the client tools as they are few fixes in this case.