That's one of those MySQL "features" where it silently ignores your request to do something because it's simply not implemented:
From http://dev.mysql.com/doc/refman/5.5/en/create-index.html
"An index_col_name specification can end with ASC or DESC. These keywords are permitted for future exten...
@JamesLupolt Not that I'm using MySQL or otherwise interested in its capabilities, but that's a surprising fact to learn nevertheless. Doesn't seem like a hard feature to implement, but I might be underestimating its complexity.
That's how I got onto this topic this morning. I was reading that, got to the figure, and realised that my DESC indexes I created circa 2006 were a prank played upon me by MySQL...
Oracle lets you specify NULLs FIRST/LAST in a query apparently, but not in the index.
Of those mentioned, only Oracle and PostgreSQL support NULLS FIRST/LAST, and they also happen to be the only two products that sort nulls last by default. Curious.
You'd think they did that to allow the behaviour compatible with other products, but NULLS FIRST/LAST is also part of the standard, if I'm not much mistaken.
I have a very old Access application that uses SQL Pass-Through Queries. This application has been nursed along through multiple server upgrades, and we recently moved up to SQL 2012.
I now get a syntax error. The last two lines of the code are where the problem is. I believe it is some kind ...
a bigger system, say, is not less than 100 concurrent users at any given time (except downtimes :), with subsecond (expected) answers for any given request
uptime is when there is a chance of getting answers to requests :)
@ypercube, sorry to start commenting again, but I could use the query, I made my researches and deleted those hypotetical indexes. But when I query SELECT QUOTENAME(OBJECT_NAME([object_id])) AS [TABLE],* FROM sys.indexes WHERE is_hypothetical=1 I can still see Hypotetical indexes. notice the first column has tables with _dta_. Are those hypotetical indexes views or something? — Rafael Piccinelli40 mins ago
@TomV I suppose these comments/questions are for you ;)
@AaronBertrand I got to plug one of you blog articles on a StackOverflow, article which I have read more than once in the past but never put 2 and 2 together until just yesterday that it was part of your "Bad habits to kick" series :)
(I'm also open to anyone who has more ideas on how to improve this answer to that homework post, I haven't done much performance tuning on MySQL so I'm sure one of you all would know some things I don't)
Has Microsoft published a roadmap for the next version, identifying a planned release date?
If not, how long do you think before the next version becomes production ready?
Anyone against, editing this question into a "generic" question based on Aaron's answer? I think it would be useful based on the info he provided and could be used as duplicate for any future questions on "when is ___ version going to be released".
@MaxVernon 2005? That sounds pretty risky to use something that hasn't been out in the wild for at least 15 years... What if there is some undiscovered bug? I can't believe you'd recommend something that has only been in production for ~10 years ;)
@Erik I've built several systems to integrate PLCs with PCs, which is always fun. I build some software that controls a carpet cutting machine from the PC. You do things like enter the length of carpet in a nice simple form on the PC, and it proceeds to tell the PLC to advance the carpet through the machine to the precise length desired, then tells it to cut the carpet. Etc. etc.
@Phrancis my guess is that if he sees that log file he will figure it out himself though
@TomV oooh good idea! I have logging enabled on the "parent" SSIS package that's running overnight, but all I'm seeing for these specific packages is "Succeeded" at 4:25AM - I'll add that, redeploy, re-run, and update with more details! — Mat's Mug1 min ago
@AaronBertrand done, but strange that your second suggestion only has 5 votes while the rest has 30+
I feel 2 is more important than 1
@AaronBertrand while you are here, I had a test setup (inherited, yay) where builtin\administrators was sysadmin, and I was local admin on the machine but couldn't login into 2016 latest CTP, is that a known issue or something documented?
@TomV It was created half an hour ago, the others have existed for ages
@TomV sure, new versions of SQL Server don't add builtins or installer as local admins unless you explicitly do so during setup. Who knows what the installer did when they added it to your vm?
Well, you can start by installing Management Studio. (How else do you plan to perform maintenance tasks once you have access to the instance?) I recommend the most recent version of SSMS Express (SQL Server 2012 SP2) which is fully functional, manages 2005 instances just fine, and is completely f...
well the vm is something you can do now with dynamics ax, you click "i want a new AX" in some web interface and they spin up a machine (beta for AX too)
@TomV Yeah I don'y know how roles and permissions work in an Azure VM, sorry. There might be some block on inheritance, don't know. Use the method I highlighted above, and add your explicit domain account instead of relying on builtin\admins
as a low-level partner we get to go through the first line support so it's not worth anybody's time I guess, nevermind. We'll see what it does when everything goes RTM
Did you log to a text file or something? Are they overwriting one another? If done right you should be able to get detailed info of every step on the child package. Meet me at the heap if you want to chat — Tom V3 mins ago
I didn't see how I could launch a private chat, sorry
I put a similar comment on another person's answer earlier that got flagged and put in the low quality post queue. I figured if I didn't say something with you then it wouldn't be fair.
Using the DATE datatype is clearly the superior approach
SELECT C113 AS C114, C119 AS C120 FROM (SELECT C112 AS C113, C115 + C116 AS C119 FROM "database"."schema"."table" C12, "database"."schema"."somethertable" C13 WHERE C12.C120 = C13.C121)
Does the sql server 2007 work on windows 10? I've been trying to install it but i faced 2 problems 1st it cannot lunch on windows 10 and second my licence has ended
I have a very old Access application that uses SQL Pass-Through Queries. This application has been nursed along through multiple server upgrades, and we recently moved up to SQL 2012.
I now get a syntax error. The last two lines of the code are where the problem is. I believe it is some kind ...
Is it possible to parse JSON in TSQL?
I dont mean to create a JSON string, i mean to parse a json string passed in as a parameter.
Has Microsoft published a roadmap for the next version, identifying a planned release date?
If not, how long do you think before the next version becomes production ready?
Does the sql server 2007 work on windows 10? I've been trying to install it but i faced 2 problems 1st it cannot lunch on windows 10 and second my licence has ended
