I have to setup a linked server from progress DB to MS SQL .
Progress is installed on Linux machine and MS SQL is installed on windows machine.
Please help !!
IMHO this question should be voted to close as "Too broad", not "Unclear". It's very clear what they're asking, but they haven't identified a specific problem.
There is an active feature request on meta.SE by one of the Community Managers, proposing to change the add a comment text below each post to something that better conveys the intended usage of comments on Stack Exchange.
The change on Area 51 uses "suggest improvements":
There is a separat...
I see Thomas' point, but it's not the general case for all those shit databases out there. My peak load has been 50k rows per second in previous gigs. Is that high or low in Thomas' eyes? Or OP's eyes?
The question says "The system is relatively young and our biggest tables are just over a million rows". So it's Excel then
Just wondering if this function is missing an order by. I certainly would add one just to make sure numbers are concatenated in order. Adding it however does not add a sort operator to the execution plan so apparently SQL Server somehow knows that numbers come out in order from Sequence Project operator. But guaranteed? I think not.
@MikaelEriksson Yes TOP should always be accompanied by an ORDER BY unless random results can be tolerated. As you say, adding the correctness incurs no overhead, so why be sloppy. Equally for the ordering part of the XML PATH.
@PaulWhite I would not put it in the cte where top is used but in the xml query. Think I trust riownumber not to skip numbers but not trust ordered rows going to the udx operator.
@MikaelEriksson Right, absolutely, but in principleTOP (LEN(@pString)) (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) could return any numbers in any order.
There's nothing to say that the 'first' row encountered should be numbered 1, for instance.
@MikaelEriksson Historically yes, more recently it can be parallelized on PARTITION BY elements, otherwise yes. Haven't tested that limitation with the new window aggregate though.
But to state it simply, numbering rows is a serial op.
@MikaelEriksson Are you going to mention that anywhere? I was thinking of posting something on the SSC thread about it. Maybe with a raw CLR implementation if I can be bothered.
@sp_BlitzErik So we have really poorly performing queries at work (like, some are taking 30-40s), the Execution Plan recommended two indexes, which we created (total "estimated" impact ~20%), I'm thinking about running a statistics update this weekend, is there any "gotcha" of this? (Never updated stats before.)
@sp_BlitzErik Well most of these tables we indexed are brand new, and over the course of the last month they have literally gained ~500k rows each, running the execution plans have significant differences between the expected and actual row counts (like, expected of 15 and actual of 20k or so), and I'm grasping at straws at this point.
@sp_BlitzErik Yes. IIRC (and I may not) I discovered the blog very shortly before learning he had passed on. Quite a shock when it's someone you 'know'.
I am reminded of a time (about 20 years ago now) when a friend of mine - who now works as a SRE for a major social networking site - got involved in making a bayesian web filtering appliance. This device was primarily intended for use by schools to identify porn sites or other material that folks might not want their little darlings browsing during school time.
In order to train the device they scraped 700 porn sites. We can only speculate what their ISP must have thought of this.
(Showing my age) Back when I was about that age I made a recording of a 976 phone sex line and charged folks 50c to listen to it. I think I got about 3 takers in the end, and back then a long-distance call from New Zealand to the U.S.A. cost about $3/minute.
This would have been about the beginning of the 1980s sometime IIRC.
Clark Joseph Kent is a fictional character appearing in American comic books published by DC Comics. Created by Jerry Siegel and Joe Shuster, he debuted in Action Comics #1 (June 1938) and serves as the civilian and secret identity of the superhero Superman.
Over the decades there has been considerable debate as to which personality the character identifies with most. From his first introduction in 1938 to the mid-1980s, "Clark Kent" was seen mostly as a disguise for Superman, enabling him to mix with ordinary people. This was the view in most comics and other media such as movie serials and TV...
@AndriyM It works for the guy going to jail for stealing millions of dollars as well. One of the early films had Richard Pryor collecting rounded cents.
I'm trying to find a reputable SSRS bootcamp in my area. I've Googled, but I'd like to dig deeper.
Where should I look to find a good bootcamp? Please feel free to point me to another part of stackexchange.
Let's say hypothetically speaking I have two tables, A and B, that have a FK relationship. It's not enforced by the data model but we can assume they have a 1:1 relationship. I need to combine these tables, or more accurately, I need to add all of the columns from table B to table A and then transfer the contexts from B to these new columns in A. Let's also say that table B has several hundred columns and I don't want to have to manually type out all of these column names and data types.
Any suggestions on how to make this an painless as possible? And yes, this is very similar to a problem I had a few weeks ago, except this is more or less in the other direction.
@TomV eh, this should work. It's only a one-time thing so it doesn't have to be pretty.
My Excel/Notepad++ super-user skills are going to get dusted off for this one I think.
The most annoying part is going to be having to do the null -> enter data -> not null conversions but whatever, I wasn't planning on doing anything this afternoon anyway.
> and I don't see the big deal. Need to shrink 1,000 databases? it's just SQL.. just a simple script. I'm a certified DBA, I'm sick and tired of paying for MS SQL licenses
@sp_BlitzErik I worked on a system with 10,000 databases on a single server, it wasn't pretty. There are so many issues that you just never see on systems with only a couple hundred dbs.
So there are Pros and Cons to both methods. Without knowing more about your application or the services you're looking to provide I won't be able to give a definitive answer but I'll throw out some of my thoughts on the matter.
My case for why you should use 1 Database for all clients.
Pros:
...