« first day (2668 days earlier)      last day (2190 days later) » 

Evan Carroll
Evan Carroll
12:01 AM
 
 
5 hours later…
hot2use
hot2use
5:09 AM
Good morning
 
hot2use
hot2use
6:09 AM
@jadarnel27 Thanks for those links
 
McNets
McNets
6:53 AM
morning
 
Andy K
Andy K
7:04 AM
morning and evening
 
Andriy M
Andriy M
Morning
 
Paul White
Paul White
7:39 AM
morning
 
ypercubeᵀᴹ
ypercubeᵀᴹ
8:36 AM
which reminds me of similar disaster, a few years ago
Jul 7 '16 at 18:09, by ypercubeᵀᴹ
Jun 28 '12 at 18:53, by ConcernedOfTunbridgeWells
@swasheck RBS is a large bank here in the UK that outsourced a lot of its operations and has just had a very embarassing outage.
 
Tom V
Tom V
@ypercubeᵀᴹ We had a similar incident a few weeks back
the bank asked their customer to send their transfers in by mail, I am not kidding you
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV I believe you.
 
Tom V
Tom V
> In the latter case, customers were asked to mail their name, address, date of birth, account number and transfer details.
 
Tom V
Tom V
9:14 AM
That's our job http://www.commitstrip.com/2018/04/24/thats-our-job/ -- Sponsored by @OpenClassrooms who is hiring mentors for their great mentorship program ! => http://mentor-en.jobs.openclassrooms.com/
Tweeted by CommitStrip on April 24, 2018 at 6:30 PM
 
 
2 hours later…
James L
James L
10:49 AM
@MikaelEriksson Have you had any problems with inconsistent query results when running XQuery against an XML column (one that isn't changing)?
 
Mikael Eriksson
Mikael Eriksson
11:10 AM
@JamesL I have seen strange things happen with memory when using OPENXML but nothing out of the ordinary with the XML datatype.
 
James L
James L
11:35 AM
@MikaelEriksson Do you know much about how the hid (hidden?) attribute is used in seeks on primary XML indexes? The value of hid used in the index seeks is the only difference I've found so far between the version of a plan that retrieves data and the version that retrieves none.
hierarchy id, maybe
This stuff, I mean: 
<StartRange ScanType="GE">
                                                            <RangeColumns>
                                                              <ColumnReference Database="[LPS]" Schema="[sys]" Table="[xml_index_nodes_2066106401_256000]" Alias="[key:2]" Column="hid"></ColumnReference>
                                                            </RangeColumns>
                                                            <RangeExpressions>
                                                              <ScalarOperator ScalarString="'ã€Á€'">
Sorry, maybe I should post this as an actual question now that I'm starting to get an idea of where the issue might be.
 
Mikael Eriksson
Mikael Eriksson
11:54 AM
@JamesL If I remember correctly hid is a representation of the path to the xml node stored reversed (Item#ParentItem#RootItem) so it can be used to seek on path expressions. Because it is stored reversed it can also be used to seek on descendant path expressions (//Item) using a "like" range seek.
 
James L
James L
Thanks
 
 
1 hour later…
James L
James L
1:21 PM
Well that was weird. It looks like it's intermittently searching for a (wrong) absolute path instead of a relative one.
I'm hoping the developers are interested in not using XML indexes anymore.
 
sp_BlitzErik
sp_BlitzErik
@Taryn looks like y'all hit an index fragmentation problem
 
Taryn
Taryn
@sp_BlitzErik not my fault
 
sp_BlitzErik
sp_BlitzErik
are the indexes rebuilt now?
@MaxVernon you didn't have any good competition here:
2
A: CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?

sp_BlitzErikHold on hold on hold on While the performance and licensing aspects are interesting, they're not the only aspect of a workload to consider. One thing that can have an impact on processor choice is worker threads. Worker Threads? Yeah buddy! They're the things that your SQL Server will use to...

 
Max Vernon
Max Vernon
1:39 PM
@sp_BlitzErik nice one. Also, connection pooling.
 
sp_BlitzErik
sp_BlitzErik
sounds like developer talk
 
Max Vernon
Max Vernon
or should I say, badly written handling of open connections in lousily written client apps that use connection pooling
ask me how I know
 
sp_BlitzErik
sp_BlitzErik
i can probably guess
ahem
but i won't
 
Max Vernon
Max Vernon
@MikaelEriksson since you're here, and such a fantastic person, how do I write an xquery to see if an attribute value contains an "@" ?
@sp_BlitzErik my ego thanks you
30,000 user connections is a lot, is all I can say.
d'oh, Mikael is gone.
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon whatever[contains(@attribute, "@")]
 
Max Vernon
Max Vernon
1:45 PM
I tried [@attribute][contains(., "@") = True], but that makes me look dumb.
@sp_BlitzErik of course. I'll give that a whirl
cheers
 
Mikael Eriksson
Mikael Eriksson
@MaxVernon not really gone, only busy doing boring work. Looks like Erik sorted things out for you.
 
sp_BlitzErik
sp_BlitzErik
@MikaelEriksson hopefully that works!
 
Max Vernon
Max Vernon
@MikaelEriksson yes, that seems to have almost worked. Like so many things in XML, it's a mater of tiny slices of my life gone whenever I try to figure out xquery syntax.
I guess my problem is I really need notcontains
 
Taryn
Taryn
@sp_BlitzErik shh
 
Max Vernon
Max Vernon
I'm trying to get sequences where a specific attribute doesn't have an "@" in the value.
 
Mikael Eriksson
Mikael Eriksson
1:52 PM
Well that’s it for me. Back tomorrow :)
 
sp_BlitzErik
sp_BlitzErik
lol
 
Max Vernon
Max Vernon
:-D
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon can you post sample xml in pastebin or something?
 
Paul White
Paul White
Apparently @Nick_Craver just shut down @StackOverflow rather than deal with the GDPR.
Tweeted by BrentO on April 25, 2018 at 1:28 PM
 
Taryn
Taryn
nailed it
 
Max Vernon
Max Vernon
2:07 PM
@sp_BlitzErik this should do the trick: 
DECLARE @x XML = '<xml>
<customer name="Max"><email address="mvernon@mvct.com" /></customer>
<customer name="Erik"><email address="erik@your-mom.com" /></customer>
<customer name="Brent"><email address="brentcom" /></customer>
</xml>';
SELECT FullXML = @x
    , WithValidEmail = @x.query('/xml/customer/email[contains(@address, "@")]')
    , WithInvalidEmail = @x.query('/xml/customer/email[contains(@address, "@")] = False');
WithInvalidEmail returns "false" in the column instead of the actual sequence of <customer name="Brent"><email address="brentcom" /></customer>
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon does that work how you want it or do you need help with something?
 
Max Vernon
Max Vernon
@sp_BlitzErik I'd like it to not return false, I'd like it to return the sequences where addresss attribute does not contain an "@" character.
ahhh, I think I figured it out. 
WHERE @x.query('/xml/customer/email.exist('/xml/customer/email[contains(@address, "@")]') = 0;
thanks for your help, Erik - much appreicated
 
sp_BlitzErik
sp_BlitzErik
i think you can shorten it, hang on
 
McNets
McNets
0
Q: Editing other people's answers

Bertrand LeroyI'm new on this forum and I'm learning new things everyday (which is great!), and I am also learning about how to behave on this forum so here's a question about etiquette and all that, specifically about the etiquette regarding the editing of other people's responses. For example ... I posted a...

sql
 
Max Vernon
Max Vernon
actually that doesn't really do it. I feel like I'm close, but stoopid.
 
McNets
McNets
2:16 PM
It should be moved to meta, where it can be closed as duplicated
 
Max Vernon
Max Vernon
@sp_BlitzErik I'm going to ask it on main, where people can really make fun of my skillz
 
Master Database
Master Database
0
Q: Editing other people's answers

Bertrand LeroyI'm new on this forum and I'm learning new things everyday (which is great!), and I am also learning about how to behave on this forum so here's a question about etiquette and all that, specifically about the etiquette regarding the editing of other people's responses. For example ... I posted a...

discussion
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon lemme know when it's up, i have an answer
 
Max Vernon
Max Vernon
sweet, almost there
0
Q: Return xml sequences where an attribute doesn't contain a specific character

Max VernonConsider the following simple XML: <xml> <customer name="Max"> <email address="me@you.com" /> </customer> <customer name="Erik"> <email address="erik@your-mom.com" /> </customer> <customer name="Brent"> <email address="brentcom" /> </customer> </xml> I want to get a lis...

sql-server xml xquery
 
sp_BlitzErik
sp_BlitzErik
2:38 PM
@MaxVernon there you go
@MaxVernon you want to return it as xml or as the values inside?
 
Max Vernon
Max Vernon
@sp_BlitzErik I'd like the xml. Although, having the values of course is helpful too!
this makes me feel like a total nooob.
 
Paul White
Paul White
@McNets Moved and answered.
 
sp_BlitzErik
sp_BlitzErik
2:58 PM
@MaxVernon that should work
 
Max Vernon
Max Vernon
@sp_BlitzErik OK. .. - who knew!
 
sp_BlitzErik
sp_BlitzErik
yeah xml sucks
3
 
Max Vernon
Max Vernon
thanks very much
 
sp_BlitzErik
sp_BlitzErik
np
 
McNets
McNets
@PaulWhite Thank you
 
jadarnel27
jadarnel27
3:08 PM
@sp_BlitzErik Starred for the enduring truth of this statement.
 
Zane
Zane
Have any of you ran into a situation where OS patches fail and even Microsoft can't figure out why?
Because I can tell you it's very fun.
@sp_BlitzErik that is an easy way to earn some stars in this room.
 
sp_BlitzErik
sp_BlitzErik
@Zane taking the easy way out is my spclty
 
Max Vernon
Max Vernon
3:21 PM
@sp_BlitzErik is "woogy" the technical term?
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon yeah it's short for "woah oh oh god why"
2
 
Max Vernon
Max Vernon
I'm sure when you see what I'm doing, you're going to laugh
@sp_BlitzErik that's some good material right there
lol:
Thanks for this info! However, FYI, I got this error when I tried it: "Msg 6335, Level 16, State 101, Line 2 XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels. " Any thoughts on how to deal with that? — jrdevdba 1 min ago
a hand grenade comes to mind.
FYI, that is unrelated to my XML questions earlier.
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon running on substandard caffeine is the equivalent to waking up drunk
 
Max Vernon
Max Vernon
@sp_BlitzErik without the fun the prior night, I take it. :-)
 
sp_BlitzErik
sp_BlitzErik
exactly
@MaxVernon query plans with > 128 nodes are stored in sys.dm_exec_text_query_plan rather than sys.dm_exec_query_plan
 
Zane
Zane
3:27 PM
SQL Server 2000 yikes....
I've said it before and I'll say it again. If your DBMS is old enough to buy you a pack of smokes it may be time to upgrade.
5
 
Max Vernon
Max Vernon
@Zane 100%
 
sp_BlitzErik
sp_BlitzErik
there was a sql skills email recently about a client problem they ran into with a customer who did an in place upgrade from 2005 to 2012 or something
IN PLACE
on 7 year old hardware
 
Max Vernon
Max Vernon
lord why? new hardware is going to be such a small portion of the cost of that upgrade.
and will make a massive difference!
even if you just ran it on a new laptop, it would be faster
 
Zane
Zane
@MaxVernon Because the moto of most companies is "Short term profits over long term stability"
 
Max Vernon
Max Vernon
@Zane yah, and they get what they get™
 
Zane
Zane
3:32 PM
I should know I work for Wells Fargo lol
 
Max Vernon
Max Vernon
lol
I wonder how many accounts they opened in your name, "for sales".
 
Zane
Zane
@MaxVernon my assumption is it's probably best not to try that on the IT guys.
Probably easier targets than me for this sort off thing.
 
Max Vernon
Max Vernon
lol. probably.
 
dezso
dezso
@BertrandLeroy Ha ha thank you. Not going to delete it (meta is for discussion so comments are rarely deleted here). — Paul White ♦ 58 mins ago
I am a hero, as I could resist no flagging this for mod with 'Except cases'
 
McNets
McNets
@MaxVernon dbfiddle.uk/…
 
Max Vernon
Max Vernon
3:51 PM
@McNets nice. It wouldn't hurt to add an answer with those variants!
 
Tom V
Tom V
Mr MD makes some horrible edits
 
Max Vernon
Max Vernon
@PaulWhite - have you seen this? It sounds like it might be something you'd know about.
 
McNets
McNets
@MaxVernon I'll do it at home tonight.
 
Max Vernon
Max Vernon
cool!
 
ypercubeᵀᴹ
ypercubeᵀᴹ
4:19 PM
1
A: Why would MS SQL server automatically remove manually created indexes?

Ken KimYou can setup a DDL trigger to capture create/drop index. CREATE TRIGGER [DDLAuditTrigger] ON ALL SERVER FOR CREATE_INDEX, DROP_INDEX Here is an article on howto. https://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/

Regarding this answer, where can we find what are the events that can be declared in a DDL trigger?
 
Paul White
Paul White
4:38 PM
@MaxVernon yes will answer later
 
Max Vernon
Max Vernon
cool
That's quite an explicit index name from Microsoft: IX_syspolicy_system_health_state_internal_target_query_expression_with_id
 
Paul White
Paul White
Professionals use a naming convention and spaces in the index name
 
Taryn
Taryn
good thing we're not professionals in here
 
Paul White
Paul White
Well I didn't say which profession
 
Max Vernon
Max Vernon
4:59 PM
what is a UDX plan operator?
> Extended Operators (UDX) implement one of many XQuery and XPath operations in SQL Server. All UDX operators are both logical and physical operators.
 
Max Vernon
Max Vernon
5:14 PM
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon CREATE TABLE dbo.[Your#Mom]
 
Max Vernon
Max Vernon
I knew it. If I see that in code someone dies.
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon blitzcache checks for table scans as well
@MaxVernon ahem
 
Max Vernon
Max Vernon
> There's a number of poor choices that the vendor has made, this is a relatively minor one as far as things go.
:-D
@sp_BlitzErik I added those details to my answer, hope you don't mind!@
 
sp_BlitzErik
sp_BlitzErik
not at all
god, of all the things for a monitoring tool to warn you about, and you to focus in on
 
Max Vernon
Max Vernon
5:26 PM
@sp_BlitzErik I'm assuming you're talking about the OP?
 
Tom V
Tom V
I tested and confirm that by turning SERVER AUDIT off on 2016 SP1 CU8 and SP2, SET ALLOW_SNAPSHOT_ISOLATION ON worked as expected otherwise it would just hang. Thanks Tom V. — donger 20 mins ago
Glad that wasn't a comment answer @PaulWhite ^
 
Max Vernon
Max Vernon
@TomV that's a weird bug
 
Tom V
Tom V
@MaxVernon especially for a cu
 
sp_BlitzErik
sp_BlitzErik
@MaxVernon yeah
 
Max Vernon
Max Vernon
@sp_BlitzErik I provided that answer as part of my quest to provide answers for all the sql-server-2008-r2 questions without answers.
I'm thinking it might take a while.
 
sp_BlitzErik
sp_BlitzErik
5:30 PM
@_@
 
Max Vernon
Max Vernon
and probably no one will be using it by the time I'm finished. Oh, who am I kidding, 2008 R2 will be in use until at least the 2030's.
 
sp_BlitzErik
sp_BlitzErik
that doesn't mean you have to support it
 
Max Vernon
Max Vernon
lol
we have some 2000 instances still hanging around here
granted they are on the way out, but you know.
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@MaxVernon that's a lot of instances ;)
 
jadarnel27
jadarnel27
@MaxVernon When I read that at first, I thought you meant you had 2,000 instances of 2008 R2 :o
 
Max Vernon
Max Vernon
5:32 PM
@ypercubeᵀᴹ and @jadarnel27 nice one.
let me rephrase that; "we have around 8 SQL Server 2000 instances still hanging around."
ahhh the vagaries of the English language.
 
jadarnel27
jadarnel27
lol
Sorry, could not resist.
 
James L
James L
Wow it's quiet in here today.
 
Max Vernon
Max Vernon
hi James!
 
Tom V
Tom V
6:12 PM
People complaining about unresolved issues but refusing to log those issues in a ticketing system...
'we told somebody already and it still doesn't work'
Put the damn support email in cc and it'll create a ticket automatically, how hard can it be
 
jadarnel27
jadarnel27
The CC field is so far away though.
 
Tom V
Tom V
@jadarnel27 it seems it isn't if they want to complain and let managers know
 
jadarnel27
jadarnel27
@TomV LOL wow. That whole situation sounds quite frustrating.
 
Tom V
Tom V
@jadarnel27 oh does it show?
 
jadarnel27
jadarnel27
I'm just good at picking up on the subtle undertones of people's chat messages.
=)
 
McNets
McNets
6:32 PM
@TomV @TomV what ticketing system are you using? I've recently contracted Zendesk
 
Tom V
Tom V
@McNets ours is crap but works. I would have to look up the name but wouldn't recommend it anyway
For some customers we use theirs but I'm not impressed either by most of them
I'd say zendesk or Jira would be my pick
 
ypercubeᵀᴹ
ypercubeᵀᴹ
6:53 PM
This doesn't look like an answer. You can suggest it as an edit to the question (and delete this) — ypercubeᵀᴹ 23 secs ago
Does that make sense? (If yes, I can make the edit to the q.)
 
billinkc
billinkc
HI GUISE!
0
A: SSIS - Convert string variable to GUID

Hardik MasalawalaPlease try with Perfect Answer CONVERT(uniqueidentifier,'Your String Value') SELECT DocData FROM docsRepo WHERE DocumentGuid = CONVERT(uniqueidentifier,'53A394A7-5D2B-40C0-A04D-90553E4535C3')

"Perfect Answer"
 
Max Vernon
Max Vernon
good Lord, HELLLO BILL!
 
Tom V
Tom V
@ypercubeᵀᴹ hmm. It's between a comment an edit or even a new question
 
Max Vernon
Max Vernon
@billinkc perfect answer. nice.
 
Tom V
Tom V
:44217191 struggled with mobile. Sorry for the pingd
 
Max Vernon
Max Vernon
7:01 PM
@billinkc hmmm good point
something must be wrong with the continuum. None of the answers on that question have a downvote.
 
Tom V
Tom V
I don't know enough about the subject of scaling out but it happens we have the ssis guru in here so maybe bill can judge
 
Taryn
Taryn
@billinkc a wild Bill appears
4
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@TomV Ssis guru? Oh, you mean Bill!
 
Max Vernon
Max Vernon
its funny how few people understand that the model database is used as a basis for each new database created.
 
Lamak
Lamak
7:39 PM
@billinkc you're still alive?
 
billinkc
billinkc
I suppose so
y tu?
 
Lamak
Lamak
7:54 PM
yo también, gracias
@billinkc I suppose you could be of some help
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@MaxVernon like the template1 in Postgres.
 
Evan Carroll
Evan Carroll
8:24 PM
 
wBob
wBob
8:40 PM
No woogy required
SELECT @x.query('/xml/customer[email/@address[not(contains(., "@"))]]') answer
2
 
sp_BlitzErik
sp_BlitzErik
oh who asked you, four eyes?
 
wBob
wBob
Getting woogy with it
Yes, yes I did that; dual Phil Collins AND Will Smith references in nearby comments. Believe.
 
sp_BlitzErik
sp_BlitzErik
i like it
 
 
1 hour later…
Max Vernon
Max Vernon
9:47 PM
@wBob ahh good old "not". Was wondering what the syntax for that was.
 

« first day (2668 days earlier)      last day (2190 days later) »