I want to query in must_not on a nested field. This is my query:
{
"query": {
"bool": {
"must_not": {
"terms": {
"socmed_crawl.fb_url_retrieve_status": [
3,
4
]
}
}
}
},
"sort": {
"followers_count": {
...
How do you execute raw SQL in SQLAlchemy?
I have a python web app that runs on flask and interfaces to the database through SQLAlchemy.
I need a way to run the raw SQL. The query involves multiple table joins along with Inline views.
I've tried:
connection = db.session.connection()
connecti...
There are some minor advantages by using SQLAlchemy - to build the SQL. Like we won't be worried when we change the tables design slightly, i.e. a column addition or rename.
I've just been going through some old stored procedures, doing some optimizations and stumbled across this oddity:
SELECT ISNULL(bt.BusinessTypeID, 0) AS BusinessTypeID
FROM BusinessType bt
LEFT JOIN Business b
ON b.BusinessTypeID = ISNULL(bt.BusinessTypeID, NULL)
This is a slightly simpl...
Basically: I want to create a procedure out of this simple SQL syntax, where value of userId should be input bý user. --select * from Users --where userid like 'Idea'
First there was darkness. Then came the strangers. They were a race as old as time itself. They had mastered the ultimate technology. The ability to alter physical reality by will alone. They called this ability [pause for effect] Tuning.
@PaulWhite Hi Paul, I've updated that SQL Azure diagrams answer. I'm a little short on time today but could flesh it out more, eg screen prints of the SSDT process I've outlined, some more hyperlinks. I also need to check the new tooling for 2016 doesn't already do this...
ALTER PROCEDURE [dbo].[getTableWithUserId]
@userId nvarchar(max)
AS
SELECT @userId = RTRIM(@userId) + '%';
SELECT *
FROM Users u
WHERE u.Id LIKE (@UserId);
GO
EXEC [dbo].[getTableWithUserId] @UserId = 'idea' ;
GO
Just wanted to make sure no sensitive information is there :)
ALTER PROCEDURE [dbo].[getTableWithUserId] @userId nvarchar(max) AS SELECT @userId = RTRIM(@userId) + '%'; SELECT * FROM dbo.Users u WHERE u.userId LIKE '@UserId'; GO EXEC [dbo].[getTableWithUserId] @UserId = 'idea' ; GO
but they want me to let end user be able to modify current SSRS reports by adding filters to each column (have around 40-50 in different tables) and show hide columns as well IN the browser :/
before they were not explicit about it, they wanted adhoc for all tables, and I wasn't able to figure out how I was going to figure out relationships between tables if they selected more then 2 tables having 3 levels of data
@AndriyM sort of, lets start by hiding and showing columns, is there anyway other then adding 50 report parameter to show hide columns
maybe I can add a single multi value report parameter then add expression to report columns to check if column is in the report visible column value
It looks like the entire thing is still in development. They might not yet be sure what they want (or might not know how to put that in words or specs).
@Mathematics That's what I was thinking too, but I've absolutely no idea about SSRS capabilities.
@Mathematics I understand about passing the column names that you want to filter, but how do you know the specific filters?: WHERE column1 >= something AND column2 = somethingelse
Question about the term "MSSQL" vs. "SQL Server". To me the term MSSQL is used by rookies, or people who don't work much with the product. It would be an interesting study to measure average vote count (up or down) on questions that initially used "MSSQL" vs questions that initially used "SQL Server"
@MichaelJSwart too bad we couldn't capture how people say SQL... pretty sure the people who say it as ess queue ell are newbs whereas those who say sequel are pros.
@PaulWhite Hi all - I just saw what I thought was a perfectly good question downvoted. It might be an idea, if one is downvoting, for a popup to appear and request a reason - an ignore option could be provided with or without anonymity - personally, I normally tell the person whom I have downvoted (rare). Any thoughts?
@AndriyM Mostly I wonder about the actual quality of the question asked by people who use either term. I'm not too curious about whether the term influences voting. So in fact if the term was corrected, it measures a little more accurately the quality of the question.
@MichaelJSwart the quality of the question is directly related to the presence of the sql tag. If that tag is there, it almost always means the OP doesn't really know what they are doing (unless the question is actually about the language)
@MaxVernon I used to add the tag explicitly when I saw the question was to do with a SQL query. It would often have a platform tag but no sql tag, and I thought its presence help making the question more specific (which it certainly did, in my opinion).
Haven't done that much on DBA.SE, though, but it was almost a rule with me when I was more active on SO
@AndriyM I guess for me, tags express what the problem relates to. If the question is about "how do I write a particular query", then sure, sql is appropriate. When the question is about "how do I shrink my transaction log" and the sql tag is present, it just shows the OP has no idea.
The comments are there for people who want to explain their downvotes.
The only thing I can think of is an AJAX <div> reminder for users when they cast downvotes:
Please consider adding a comment if you think this post can be improved.
After the first downvote, we can't say we didn't rem...
@MaxVernon But don't get me wrong, I can confirm that people have been misusing the sql tag a great deal. I only meant to explain that its presence or absence may not be saying much about the quality of the question.
@MichaelJSwart I don't care enough to go looking for it to correct it (some users do, as is their right) but if I am editing a post anyway, I will correct non-standard forms to the proper name, SQL Server. Occassionally, Microsoft SQL Server if the context dictates.
I've noticed on the tools section that several comments from posters asking why their post has been downvoted are being flagged.
Is it now considered bad form to ask for downvote-reasons? Is the flagging of these comments directly aimed at such queries, or at "inane banter" in general? Are there...
No.
Explaining votes is almost pure noise, meta-conversation and punditry. Your votes are your own to do with as you please; you owe no one an explanation, nor is a discussion of your voting habits likely to be helpful.
What is helpful is constructive feedback:
Please consider adding a commen...
I encourage people to leave constructive criticism. But if they choose not to, that's all good as well. The down vote alone says there's something that could be improved. A comment can be helpful if it is not obvious what that improvement might be.
But honestly there's little point fretting about how others vote in general.
@Mathematics sorry, I just don't get it, you don't only need the columns to applied filters, you also need the actual filters....and I'm kinda burned about this ever changing issue
@AndriyM I get that sinking feeling all the time. When something goes down moments after I touched it. I get worried that I did something. Luckily, it's not my site :-)
Where I work everything is quite segregated, the dba's touch everything from the service to background process of the database, how often we take backups, etc. There's another team in charge of the OS, one in charge of the SAN, one in charge of the tape backup handling, etc
@TomV They want to start learning it and are looking for a "pathway". I see there isn't really a "stairway" over at SSC. Suggested reading, videos, blogs etc. We can all google it, but they are looking for recommendations ( ie "I've tried that ...it's good" rather than "I've googled that ..."). Thanks!
My opinion, FWIW, read up on datawarehouse design first, a good star schema (no snowflake) prevents you from running into messy stuff in your SSAS solution
And if you have the chance to solve something in the DWH, do it there instead of in the cube
Around 7:30pm every evening we receive the following message and the server experiences an outage of 2 minutes.
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1868 seconds. Working set (KB): 2096696, committed (KB): 18...
We once had a production server run on a old desktop (old in the sense that it was once a developer's machine but retired and he got a new desktop)
I was asked to write an application, but nobody thought about the fact we needed a server to run it on
at golive everybody scrambled to find "something, god please, anything", so they found a machine with a broken network card, and a dev had to give up his NIC to switch it into the new "server"
I am assuming that your task is to create a set of backups where you can restore all of them to a single static (no open transactions) point (all in sync). Similar to what a quiesce point will do for you in DB2. Unfortunately there is nothing in SQL Server that does exactly that. However, assu...
@Lamak So the extra raid was because the taxi driver called the police saying "hey I dropped those guys off, they had more bags than I could fit in my trunk so I bet there's more at that adress"
How do you execute raw SQL in SQLAlchemy?
I have a python web app that runs on flask and interfaces to the database through SQLAlchemy.
I need a way to run the raw SQL. The query involves multiple table joins along with Inline views.
I've tried:
connection = db.session.connection()
connecti...
I've just been going through some old stored procedures, doing some optimizations and stumbled across this oddity:
SELECT ISNULL(bt.BusinessTypeID, 0) AS BusinessTypeID
FROM BusinessType bt
LEFT JOIN Business b
ON b.BusinessTypeID = ISNULL(bt.BusinessTypeID, NULL)
This is a slightly simpl...
The comments are there for people who want to explain their downvotes.
The only thing I can think of is an AJAX <div> reminder for users when they cast downvotes:
Please consider adding a comment if you think this post can be improved.
After the first downvote, we can't say we didn't rem...
No.
Explaining votes is almost pure noise, meta-conversation and punditry. Your votes are your own to do with as you please; you owe no one an explanation, nor is a discussion of your voting habits likely to be helpful.
What is helpful is constructive feedback:
Please consider adding a commen...
Around 7:30pm every evening we receive the following message and the server experiences an outage of 2 minutes.
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 1868 seconds. Working set (KB): 2096696, committed (KB): 18...
I am assuming that your task is to create a set of backups where you can restore all of them to a single static (no open transactions) point (all in sync). Similar to what a quiesce point will do for you in DB2. Unfortunately there is nothing in SQL Server that does exactly that. However, assu...
