I have also had luck with recruiters. I have a couple that I have worked with for years and they periodically send me a 20 hour-project where someone needs some...

Tom John-342103 (2/5/2015)

---

We identified the offending query...

This will give you the info that you need:

How to Post Performance Problems[/url]

I don't get exactly what you are trying to do but I know that a calendar table is helpful in this kind of situation. If you don't have one available...

If using option Recompile fixes it then you may be dealing with parameter sniffing. One way to know for sure is to capture the query plan when running the query...

I just left a longer reply and got an error when I attempted to post it :angry:

Anyhow, take a look at

SQL University: Advanced Indexing – Indexing Strategies[/url]

Anju Renjith (2/3/2015)

---

create table tblxmldata

(id int, xmltext xml)

insert into tblxmldata values(1,'<associatedText><value type="PO">GTT taken</value></associatedText><associatedText><value type="PO">Check sugar today please</value></associatedText>')

insert into tblxmldata values(2,'<associatedText><value type="PO">Check BP today please</value></associatedText>')

I want the output as

1 ...

SELECT id, xmltext.value('(/associatedText/value/text())[1]','varchar(100)')

FROM tblxmldata;

Note that you don't need the nodes() method in this case because you are only retrieving one value...

I have had to read from the registry when creating DTS (back in the day) and SSIS packages. Some app developers like to store information about that custom app in...

Something to note...

If you are only looking to extract report data from the reportserver..catalog table it's good to filter for Content that is not null and [Type] = 2....

I agree with all the previous comments, particularly what Jeff said about the "better" jobs find you. I am certainly not anywhere at the same DBA skill level as say...

DDL, more sample data and a better description make this easier but here is a possible solution...

-- (1) Sample Data

DECLARE @table TABLE (ID int, Seq char(2), [desc] varchar(50), DateOpen date,...

You can lose one cross apply and further simplify the query like this:

SELECT

o.value('(del_Nr/text())[1]', 'VARCHAR(10)') as PONbr,

o.value('(del_Third_Nr/text())[1]', 'VARCHAR(10)') AS NCubeID,

...

Michael Valentine Jones (1/26/2015)

---

I haven't seen much improvement in compression using third party backup tools compared to the native SQL Server 2008R2 backup compression.

Some of the third party backup tools...

As far as 3rd party tools are concerned, SQL Backup Pro[/url] has worked well for me. It has a lot of other useful functionality in addition to compression.