Viewing 15 posts - 1,786 through 1,800 (of 2,458 total)
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...
-- Itzik Ben-Gan 2001
February 5, 2015 at 10:16 am
Tom John-342103 (2/5/2015)
Steve Jones - SSC Editor (2/5/2015)
Could be parameter sniffing, perhaps a plan flush that compiled poorly the next time, it's not the index itself.
We identified the offending query...
-- Itzik Ben-Gan 2001
February 5, 2015 at 9:52 am
This will give you the info that you need:
How to Post Performance Problems[/url]
-- Itzik Ben-Gan 2001
February 4, 2015 at 10:10 am
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...
-- Itzik Ben-Gan 2001
February 4, 2015 at 10:01 am
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...
-- Itzik Ben-Gan 2001
February 4, 2015 at 9:44 am
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]
-- Itzik Ben-Gan 2001
February 4, 2015 at 9:39 am
Anju Renjith (2/3/2015)
(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 ...
-- Itzik Ben-Gan 2001
February 3, 2015 at 12:17 pm
I want the output as
GTT taken
Check sugar today please
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...
-- Itzik Ben-Gan 2001
February 3, 2015 at 11:57 am
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...
-- Itzik Ben-Gan 2001
February 3, 2015 at 10:57 am
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....
-- Itzik Ben-Gan 2001
January 29, 2015 at 11:41 am
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...
-- Itzik Ben-Gan 2001
January 29, 2015 at 10:54 am
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,...
-- Itzik Ben-Gan 2001
January 29, 2015 at 10:28 am
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,
...
-- Itzik Ben-Gan 2001
January 28, 2015 at 9:39 am
Michael Valentine Jones (1/26/2015)
Some of the third party backup tools...
-- Itzik Ben-Gan 2001
January 26, 2015 at 9:41 am
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.
-- Itzik Ben-Gan 2001
January 26, 2015 at 9:14 am
Viewing 15 posts - 1,786 through 1,800 (of 2,458 total)