DVD copy with an automated job sounds like more than a world of hurt. You cannot...

tamer.h (1/8/2014)

---

Thank you ChrisM@Work

it works perfectly.

I'm now trying to copy the result of query to another table in another DB useing INSERT INTO but it always creating a new...

New Born DBA (1/3/2014)

---

I am having some performance issue when one of a developer is running a simple query from a view. He is complaining that the DB is really...

It is...

mbrady (1/7/2014)

---

The loads that are done are incremental, however I do know what percentage of records the typical load represents. I know from another guy on the team that...

mbrady (1/7/2014)

---

I would run the package from my local machine if I went that route.

I had two batches in successfully and 3/4 through the 3rd the lead architect decided she...

My concerns with SSIS is overhead, especially if the package runs on the SQL server. You have sql set to consume all available memory. This isn't a best practice (set...

Is there any identity that is unique? You could cluster on a non-unique ID but...

Do you have an IDENTITY column on this table with no PK? If so, and NULL is not permitted, then create an unique clustered index on it. Your...

Hi MBrady...

You have both a SQL issue and an office politics issue. 😀

As to the SQL Issue, in the thread I see you trying to loop to take smaller...

The end of this is that the stats and indexes were set up optimally. We looked at this carefully. We have created a last resort solution that does...

I thought that this was the case, but apparently you need more oomph than that.

Testing this from a SQL login that is not a sysadmin and...

nihal9200_kwada (1/3/2014)

---

Can I use DBCC RULEOFF and DBCC RULEON in a trigger ? I want to disable merge and hash joins optimizer rules.

And also Do I need to provide any...

Jeff Moden (12/31/2013)

---

What about DBAs using it to elevate their privs as you have just done? It's not the usage of xp_CmdShell that caused that risk. It's the...

Hi.

As much as I hate loops, this is the right place for one in order to remove the data without ballooning the transaction log.

declare @rowcnt int

select @rowcnt = COUNT(*) /...