GilaMonster (9/10/2014)

---

Kinda hard without more information.

From the looks of that code, it should take single-row locks on the two tables (locking the inserted rows) and hold them until the end...

robert rogers-466427 (9/8/2014)

---

Hello my Fella DBA's

I need your opinion. I just start a new job and most the Sql Server environments only have 3 San drives.

Being that I only have...

Sri8143 (8/11/2014)

---

Hi,

There are multiple temp tables with different suffix in the tempdb which i cant drop or delete it as it is from a different session which is not active...

Tara-1044200 (8/11/2014)

---

I am planing to upgrade sql 2005 to sql 2008 R2 but would like to do as a separate instance in the same physical box due to the server...

Mike Aguilar (8/11/2014)

---

Hi, I can run this job from SSMS no problem: EXEC msdb.dbo.sp_stop_job @Job_name='Main_Job'

But when I schedule it in an SSIS job I get "The specified @job_name ('Main_Job') does...

Silverfox (7/22/2014)

---

I still don't understand how one person can work as a DBA for one company and then in next role at another company be a architect, it is the...

Welsh Corgi (6/19/2014)

---

I got myself in a bind.

I performed a rebuild of Indexes on all tables in a Database.

The Database grew in size from 406 GB to .9 TB.

I shank...

homebrew01 (6/17/2014)

---

"The fill-factor value is a percentage from 1 to 100, and the server-wide default is 0 which means that the leaf-level pages are filled to capacity.

Fill-factor values 0 and...

I will add my comment too.

"No"

We perform shrinks all the time and stop them half way no issues. (The other side is it's not good to perform shrinks...

Hi Although I might not help with answers, I do have more questions 🙂

So for...

Hi I saw your post and wondering have you resolved it and what was your resolution?

If you have not have you checked trying to re install system drivers?

More specifically...

GilaMonster (4/16/2014)

---

Cached plans don't contain the degree of parallelism. If there's a parallel query in cache, it's the query execution engine which decides what DOP to use or whether to...

GilaMonster (4/16/2014)

---

No conflict.

Maxdop query hint overrides the server Maxdop setting.

If resource governor is enabled and a Maxdop is set via resource governor, then that is the max value allowed. A...

I do a lot of restores in my Dev and QA environments. They both have a wealth of little connection greedy web services running against them so I had...

Good one...