Perry Whittle (9/24/2012)

---

braju (9/24/2012)

---

From what I have seen as reponses, I think we should set the MAXDOP to default to 0 and adjust cost threshold of parallelism if needed or...

Look for ACEOLEDB.DLL on your machine. It should be in an Office14 folder in one location or another depending on whether you have Office installed or whether you installed the...

Sorry I misunderstood the scenario. Try changing the input file encoding from UTF-16LE (what Microsoft calls "Unicode") to UTF-32 and see if passing that file works. It's a workaround but...

I have worked with Idera sqlDM, nagios & SCOM. It might be the most basic of monitoring tool functions, i.e. monitoring if a service is alive, so pretty much any...

I would recommend setting up monitoring from atmleast one other machine. You could use WMI to check the service status periodically and email if there is a problem. There are...

The short answer is yes, the settings in the configuration file will be used instead of the info hardcoded into the Connection Manager object.

There is an order of precedence on...

GilaMonster (9/23/2012)

---

opc.three (9/23/2012)

---

In a heap, when an existing row is updated and that row no longer fits on the page where it lives a forwarding record is created to hold...

I could see that for restoring a snapshot in a production rollback scenario.

To be fair and complete you have to be out of the DB to restore WITH REPLACE...

Just curious, are you applying your own algortihm using sys.sysindexes.rowmodctr?

The tables sound like good candidates for havaing their non-clustered PK converted to a clustered PK.

I'd like to expound on a couple points in your post.

If the PK is turned...

Dave Ballantyne (9/23/2012)

---

Done the same sort of thing, but when there are apps that fire continously then they can get the single user connection .

Had to re-sort to pausing the...

You cannot replicate a regular view because in a regular view the data is not materialized. You can however replicate an indexed view for that same reason.

It sounds like one...

This technique works for me. It guarantees success when there are apps are running with sysadmin-level permissions:

USE YourDatabase;

ALTER DATABASE YourDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE; -- forcefully kills all user...

The disadvantages of setting Max Degree of Parallelism to 1 is that queries that would have benefited from executing with a parallel plan will not be able to and that...

You have numerous configuration management options in SSIS. Personally I like using XML Package Configuration files for this kind of work. When I deploy a package to 'dev' or am...