Hi all - there was a post about 2 hours ago offering to sell EU passports and other ID documents. I flagged it as illegal activity but I also deleted the text. I was then told by "Undo" not to edit spam. Is the only course of action to flag and nothing else? It was particularly egregious so I thought that I was doing the right thing - but what is the group consensus?
@Vérace I agree with you. I think I would have done the same, after checking if there were any mods around the Heap. Assuming we're talking about dba.se
@AndriyM Hard to say about what the question is about. Should the title be "(Cross Apply over inline sub-query) vs (CTE over inline sub-query)"? And the CTE query provided is invalid so...
@PaulWhite Yes - it was dba.se. It's the only one of my forums on which I have the power of editing without needing approval. I did flag it to the mods, but they were taking their time (not there?) and I thought that the best thing was to get rid of their excrement.
@AndriyM Not sure what to do with this one. If you have an answer for him you could write it. And perhaps vote the SO question over to dba and then close as duplicate. It also probably could be closed here as too broad, at least when enough of us has figured out what he is actually asking about :).
For one thing, I think I've seen a question here recently closed with a custom reason as a cross-post (unanimously, judging by the number of votes on the close reason comment). But also, since the SO question has already got answers and the DBA one hasn't, we could migrate it the other way and close as a duplicate at SO.
But the execution plan for both is same as shown below:
The plans are different. One is an inner join, the other is an outer join. The results may be the same in your simple test, but the semantics are different. In more complex queries, the difference may cause more obviously different exec...
I think duplicates do not end up rejected migrations. If I remember correctly, it has been done in the past (closed as a duplicate, then merged). I might misremember, though.
I have to select 2 values that were less that the given id and greater than the given id. I have tried this query but is there any better way to do it
Fiddle Sql
Begin
declare @rootValue int
declare @repID int
set @repID = 2
set @rootValue = (select Id from tblLookups where Id = @repID)
dec...
I agree that it doesn't explain the problem in the clearest possible way, but... Three people upvoted and two starred it, it's got two answers, one accepted too. So the overall situation makes little sense, don't you think?
@PaulWhite Yes - it was dba.se. It's the only one of my forums on which I have the power of editing without needing approval. I did flag it to the mods, but they were taking their time (not there?) and I thought that the best thing was to get rid of their excrement. Just to be clear, the excrement I'm talking about was the spammer's - my language was ambiguous, it could have been construed as a critique of the moderators, which it wasn't.
@Vérace re your question about editing spam, I think we have enough active users here that obvious spam gets swatted quickly enough, so I think the logic on this M.SE post applies here too:
This was recently brought up at the Super User Meta also.
Why shouldn't we edit spam posts?:
Usually spam is easy to spot, and gets removed very fast. 6 spam flags deletes the post.
Moderators can easily see (or search for) the links posted by spammers, and can blacklist sites once it is pos...
Install MS SQL server 2000 via setup instead of AutoRun... setup can bypass the compatibility check very easily...
Try this...
Thanks and regards
Qaiser Hameed
If ever you want to port this system to another RDBMS you'll be in trouble. New programmers won't understand this. You should change this now. — Vérace17 hours ago
@Vérace I see this argument ever so often when choosing from syntax alternaives
@MarkSinkinson most Oracle folk still know what it means and I work with a DBA who still prefers the syntax
the risk of digging through old working code just to change the join style is completely disproportionate to the benefit, so I think the comment is misguided
most of the time you have to work with what is already there
@JackDouglas I would agree with that, however if you're already making a change to an existing query, or are developing something new, I'd tend to bring it inline with current standards
@JackDouglas @Vérace I think I'd still edit it if I had flagged it as spam and nothing had been done about it after an hour or two. The site can be very quiet at weekends.
@MarkSinkinson I have. Someone wanted to move the system I work with from SQL Server to MySQL to save money in a hosting solution. I provided some feedback on what we had to do to make it happen and have not heard from them since.
:22685093 Where function is like a loop which checks each record and try to match given parameters ,
Where(bool match) // looping function
{
if(match == true)
{
// Do this, e.g. Update this record or update it
}
}
can't see any exception rising there by any chance :)
@Learner "SQL has been developed by C++" nope. SQL is a language. And then there are products like Oracle, MySQL etc that use SQL to allow a developer to do stuff with the data. There is usually some feature in those products that allows you to look at how the SQL command was executed. For SQL Server it is the query plan.
Written in C, C++ https://en.wikipedia.org/wiki/Microsoft_SQL_Server
Sorry I meant SQL Server..
BEGIN
DELETE FROM dbo.Membership
WHERE
((ID=@ID OR @ID IS NULL)) OR (
(CompanyID=@CompanyID OR @CompanyID IS NULL) AND
(UserSID=@UserSID OR @UserSID IS NULL) AND
(Role=@Role OR @Role IS NULL) AND
(StartDate=@StartDate OR @StartDate IS NULL) AND
(EndDate=@EndDate OR @EndDate IS NULL))
END
with this stored procedure, I would like to either update record with provided ID, or otherwise with rest of all provided para
First, you have to be able to connect to the database in order to run queries. This can be achieved by
REVOKE CONNECT ON DATABASE your_database FROM PUBLIC;
GRANT CONNECT
ON DATABASE database_name
TO user_name;
The REVOKE is necessary because
The key word PUBLIC indicates that the privi...
You get the message
No relations found.
because the user does not have the USAGE privilege on the schema (neither granted directly, nor through the public pseudorole). You can check this by comparing \dn+ mra_dev_schm_99999 on the two databases.
This is what the documentation says about t...
You have at least two options.
The first one makes use of a small query and a text editor. We have to collect the schemata of our interest:
SELECT nspname
FROM pg_namespace;
You can add a WHERE clause if you want to limit the scope. Copy the output and amend it, so you get a number of G...
Anyone know a good procedure to quiesce a CHILD process? It's only meant to be active in daylight hours, but recently has refused to accept the SLEEP command. IO seems to be working properly. The Chief Operator's off duty, after dealing with several days on-call. I hope its not a system bug.
This is the scale-out instance which was only installed just over a year ago. I think the warranty's expired, though, and I can't find the documentation.
Hmmmm .. saturate the input stream and cause the system to crash overnight. Worth a try!
Train footage would very very acceptable test data, given the system's current development. Thanks.
these problems just go away by themselves - the only problem is that you never know after how much time
in our case, co-locating the process with the parents also helped a bit (having the backside that when the CPU load raised overnight both parent sleep() calls were interrupted immediately)
@dezso Downtime has been achieved. We've had success with a co-location solution but, as you say, it puts extra strain on the parent table, so we try to keep that as a DR solution. Anyhoo, time for some essential system maintenance. Catch you later.
@dezso Granted porting is not common - what is far more common is for companies to try for the "of course we support your database sir, of course"... which leads to common-denomitorism - which is related, but not identical to, porting. BTW, when you said "argument ever so often", did you in fact mean "argument ever so often" or "argument every so often"?
A colleague asked to check in with me every couple of weeks. I would like to respond that it would be wonderful if they checked in ever so often. But, I don't believe that sounds correct. How should I phrase it?
I'm making an hotel reservation app.It has the following features
Promo Codes:
The guest can choose to pay half a certain percent of the total_amount or the entire total_amount.
I want to use stripe, paypal and authorize.net as payment gateways.
Reservations are stored here
CREATE TABLE `res...
> How do I keep track of such things ? I mean what is the right way to structure these tables ? I don't have any idea on how to fetch this for later use and for other operations.Can someone give me a tutorial link about ecommerce with discounts and deposits(I google a lot but couldn't find one similar to my app) or give some help on this?
sure it might need a little cleanup, but the stuff below was not edited..
@AndriyM "Every so often" means "once in a while" - "Ever so often" means "frequently/regularly" , perhaps even more - it's almost a lament. Since it's an easy mistake to make for a non-English speaker, I was just wondering how forceful @dezso 's argument was.
@ypercube once we had a lunch with some colleagues - a Brazilian and a Colombian had Hungarian girlfriends, the third one some Hungarian cousines, and I was the fourth
I am trying to understand if there is RAID best for data warehouse.( for version SQL Server 2012 or 2014). so
What is the best RAID for data Warehouse performance wise?
What is the recommended RAID for SSAS and SSRS?
@MarkSinkinson I don't think it's terribly uncommon for vendor apps that are either ubiquitous (e.g. SAP) or verticals where there aren't enough customers to insist they all run the same database platform.
In my experience it results in an app that either uses the database in a weird way or applies coding patterns that work well on one database but cause horrible problems on another.
I agree it's close to irrelevant in the context of that question, though.
@JamesLupolt It's pretty uncommon for vertical market players to support more than one database platform. SAP does - Oracle doesn't (except maybe for legacy Peoplesoft and JDE customers). Most smaller, niche market players will only support one platform.
You are a good contributor and I don't see anything wrong with you posting this as an answer - though perhaps you should make your association with TwinDB more clear? — Jack Douglas ♦52 secs ago
^^^ That's on a post that was flagged as spam
happy to be out-voted if you all think it should go...
@ConcernedOfTunbridgeWells Maybe it's just a coincidence, but I've come across a few in energy trading: Openlink Endur and Exxeta. I think Intellimatch might too, but I can't find a reference online and it's not really an energy trading specific app anyhow.
In some cases I'd guess it was because a customer was willing to pay a vendor extra not to have to buy an Oracle license, or an Oracle DBA.
I helped a few customers with MySQL -> SQL Server migrations at Rackspace, but those were fairly abnormal. MS Access + VB -> MySQL + PHP was a more common (and more painful to watch) platform shift.
But the execution plan for both is same as shown below:
The plans are different. One is an inner join, the other is an outer join. The results may be the same in your simple test, but the semantics are different. In more complex queries, the difference may cause more obviously different exec...
I have to select 2 values that were less that the given id and greater than the given id. I have tried this query but is there any better way to do it
Fiddle Sql
Begin
declare @rootValue int
declare @repID int
set @repID = 2
set @rootValue = (select Id from tblLookups where Id = @repID)
dec...
This was recently brought up at the Super User Meta also.
Why shouldn't we edit spam posts?:
Usually spam is easy to spot, and gets removed very fast. 6 spam flags deletes the post.
Moderators can easily see (or search for) the links posted by spammers, and can blacklist sites once it is pos...
Install MS SQL server 2000 via setup instead of AutoRun... setup can bypass the compatibility check very easily...
Try this...
Thanks and regards
Qaiser Hameed
A colleague asked to check in with me every couple of weeks. I would like to respond that it would be wonderful if they checked in ever so often. But, I don't believe that sounds correct. How should I phrase it?
I'm making an hotel reservation app.It has the following features
Promo Codes:
The guest can choose to pay half a certain percent of the total_amount or the entire total_amount.
I want to use stripe, paypal and authorize.net as payment gateways.
Reservations are stored here
CREATE TABLE `res...
I am trying to understand if there is RAID best for data warehouse.( for version SQL Server 2012 or 2014). so
What is the best RAID for data Warehouse performance wise?
What is the recommended RAID for SSAS and SSRS?
