Viewing 15 posts - 1,786 through 1,800 (of 2,462 total)
Using the unpivot method in Dwain's article I came up with this solution...
(Note that I used 4 numbers for brevity)
USE SSRS_POC
GO
IF OBJECT_ID('tempdb..#tablewinners') IS NOT NULL DROP TABLE #tablewinners;
IF OBJECT_ID('tempdb..#tableguesses') IS...
-- Itzik Ben-Gan 2001
February 5, 2015 at 12:12 pm
Igor Micev (2/5/2015)
Alan.B (2/5/2015)
Igor Micev (2/5/2015)
Alan.B (2/5/2015)
Or you can run DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS (caution: this will cause other queries to slowdown as they will need to recompile)....
-- Itzik Ben-Gan 2001
February 5, 2015 at 11:29 am
Interesting...
I have never unpivoted a table, but I think I understand what it is your are saying. I will read up on unpivot to see how to make it...
-- Itzik Ben-Gan 2001
February 5, 2015 at 11:18 am
Igor Micev (2/5/2015)
Alan.B (2/5/2015)
Or you can run DBCC FREEPROCCACHE & DBCC DROPCLEANBUFFERS (caution: this will cause other queries to slowdown as they will need to recompile).
No this! It...
-- Itzik Ben-Gan 2001
February 5, 2015 at 10:49 am
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
Viewing 15 posts - 1,786 through 1,800 (of 2,462 total)