sk.ruhulla (3/10/2014)

---

[font="Comic Sans MS"]Hi

Iam working on sql server and performed some queries and got required tables as results.

Now I want to Export the table to a CSV file USING...

Is this 32 bit or 64 bit system ? What are your memory settings ?

How frequently do you do index rebuilds and update stats ? Do you have MAXDOP...

Keith Tate (3/11/2014)

---

I would check the maintenance plan, or some other job that might be doing maintenance, to see if your recovery model is getting changed thus breaking you backup...

It shouldn't affect.

--

SQLBuddy

HanShi (3/10/2014)

---

I would suggest to script out all users (and logins) with their permissions. You can find many script to do that on the internet and on this forum (http://www.sqlservercentral.com/search/?q=permissions&t=s&sort=relevance)....

What's your SQL Build no ? Also try to collect these counters (Perfmon) which gives us more insight ..

Processor – %Privileged Time

Processor – %Processor Time

Processor – %Interrupt Time

Processor...

You are welcome, GBeezy 🙂

--

SQLBuddy

shahgols (3/10/2014)

---

Hi everyone, I am trying to start a job on a sql 2008 r2 server from a sql 2012 server. I have the following code:

exec msdb.dbo.sp_start_job @job_id =...

muthyala_51 (3/10/2014)

---

CLR is enabled and the server holds linked servers. Maxdop setting is 4. For CPU settings, both processor affinity mask and i/o affinity mask were checked. We also...

curious_sqldba (3/11/2014)

---

This means Parallelism has been disabled at server level and SQL Server generates serial plans...

Also check if Parallelism is happening on the server ? What are your MAXDOP settings ..

Best Regards,

SQLBuddy

ChrisM@Work (3/11/2014)

---

curious_sqldba (3/11/2014)

---

Exactly, but...

Where did you find that ? I don't see any Parallelism operator...

muthyala_51 (3/10/2014)

---

I went through all the logs and grabbed some info for you guys. The following links gives us the exact scenario which happened at that time.....

Error 1: There was...

MAXDOP =1 means disabling the parallelism. That's why SQL Server doesn't consider parallelizing the query.

That's why I couldn't see that in the execution plan you posted.

--

SQLBuddy