sriharsha2410 (8/1/2012)

---

Im using SQL Server 2012 and I have a case where I have to delete sql jobs. I found two approaches which are as follows:

Approach 1

DECLARE @jobId binary(16)

WHILE...

I think the relevant points in the question are that the transaction was committed on the primary and the log was successfully sent to the mirror prior to the crash....

If by 'databases' you just mean the Database Engine then I can say I have not run into any issues connecting and managing 2000, 2005 or 2008 R2. Then again...

New day (at least in this time zone, Mountain) so new word:

Worth

The DEFAULT option works as you described, but you'll need to set @path this way if you want to pickup all default trace files:

SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])),...

I know the...

I installed a named instance of SQL 2000 Developer Edition after already having 2005 and 2008 R2 installed and have had no issues.

Open the xdl in Notepad to see the two statements involved.

You can. I just tried it. You'll just need to install the 2012 Native Client to get the provider.

Code to create a Linked Server that uses the logged in user...

marek_polko (7/26/2012)

---

Sorry for the confusion guys. The view had a join on the Request_ID field to an another table where this field was a varchar type. I did not convert...

GilaMonster (7/30/2012)

---

Yes, but the specifics, not the general rule. Maxdop is per...

GilaMonster (7/30/2012)

---

Two operators running with 4 threads, 2 co-ordinator threads. They won't all be running,...

htt (7/30/2012)

---

Yes that was a critical issue but thanks god we had it resolved. The problem was a search query. We finally had the query tuned and the...

It sounds like you're approaching a situation that may become critical in a hurry, if it has not already.

How many cores per CPU? Must be at least 8 each given...

No, not the picture again. The XML. That picture is rendered off an XML document which contains important troubleshooting information.

Right click the row in Profiler and click Extract Event Data...,...