@PaulWhite can you explain? Do you mean something other than still having to ensure that the executing user has the right permissions on the underlying objects?
@PaulWhite i looked at the source from sp_WhoIsActive to see if i could gain any insight from it. i wept at my own inadequacy and closed the query window and had a rye whiskey.
I see a lot of questions pop up on dba (and SO of course) where the OP says "I wanna do this... but I don't wanna use dynamic SQL." In a lot of cases, dynamic SQL is the perfect solution (and sometimes the only), so I'm going to write something up about it, want to make sure I hit all the top objections and either tell how to solve or admit and say, yep, that's a drawback.
I have quite a few tables which contain some common columns (same name and datatype). On these columns I need to perform the same operations and I would like to do that via a stored procedure. However the only way I can make it work at the moment is using dynamic sql, which I'd rather avoid.
Is ...
I'll definitely point there (it's not the most discoverable thing if you don't know what to search for, and not easy to digest the point you're after once you're there, unless you read the whole thing)
@Gonsalu WHICH download page? The blog post that hasn't been updated? That's the problem - it will probably keep saying it's beta for a long time, just like 11.02 will continue saying "here is the latest release"
He needs a landing page like downloadsqlserverexpress.com
i think the point that, without a specific, and dedicated release location for this specific and significant tool, it's hard to tell what is where and where we are in the process.
@Gonsalu thanks! that just opened a fun rabbit hole for me to distract myself from renaming my statistics objects from _WA&*(#&@*()(#HD to something meaningful
I'm not trying to sound like I'm complaining. I'm just saying that it's very disorganized and for the amount of effort he puts into the thing itself (though if 11.11 really is latest, it's been untouched for a couple of years), a little more effort on a landing page would make it such an easier thing to use.
Quick question, is it unusual for a local query (shared memory protocol) on the server to be showing ASYNC_NETWORK_IO as a wait type? I have proc that been running over 15 minutes for me but another DBA can run it on the same server in under 2 minutes. Can lost as to why that might be.
@ShawnMelton also ... are you doing any data loads or anything?
> As a side note - if you are doing server-side data loads that are still showing NETWORKIO, check to see if shared memory protocol is enabled for the SQL Server instance (and then check to see if session is connected using net_transport = ‘Shared memory” via sys.dm_exec_connections).
@AaronBertrand Don't support. DU is a PC based campus. It might take some work to get it to operate, as they are just HDMI or VGA connections, but they don't take Mac specific connectors.
@MikeFal yeah, again, I think that's "support" as in "we don't care if you don't get presenter view, etc." and probably people complaining that it wasn't perfect. That's obviously different from black screen.
(I'm particularly interested in answers that view the question below as a special case of the question: how should a RDBMS enforce structural constraints that are more specific than "one-to-many" and "many-to-many"?)
Much experimental data in biomedical research is collected in "plates" of recta...
I would like to know the main purpose of xp_cmdshell in sql. Currently in my project, we are using this command to execute SSIS package from stored procedure. So i need to know more about xp_cmdshell.
I find that Informatica developers command a higher hourly rate. However, there are far fewer opportunities here for that sort of work so when that well dries up, I'm gonna be mighty thirsty
I am running xampp on Windows - Apache and MySQL start fine, but when I try to go to the directory where I have my example app, it loops infinitely waiting for localhost:
The log shows:
2014-08-22 16:38:18 10016 [Note] Plugin 'FEDERATED' is disabled.
2014-08-22 16:38:18 750 InnoDB: Warning: Usi...
We are deploying our model for use in PowerView and want to be able to retrieve the Top 10 something for any month. I was thinking I'd be able to use this query, add it to the model and then they could splice the data as needed. This doesn't seem to be working out as expected. Is this even something I should be trying to store in a measure? Sorry if this is a dumb question, as we know absolutely nothing about this stuff. We are learning on the fly.
Our other solution would be to create a flag in our table to ID each customer in the Top 10 and then rollup the others or something similar.
feel free to crush all my dreams of accomplishing this by Tuesday :)
You can definitely create a measure that will give you just the top 10. You can also definitely create a measure that shows that top 10 as a percentage of total.
beware that TopN doesn't work the same in DAX as it does in other languages though. there is an article on that somewhere
I imagine if you can get to the top 10, you can get to the rest. It might not be very straight forward
I don't think it's infeasible. I think the calculations might get a bit messy. I'm not sure you can create a rollup of everyone not in the top 10 since you don't really create new calculated members/sets. You could do it if you weren't trying to dynamically set the time period.
actually, i think you can make the measure work, but you might not be able to make it show up correctly in Power View
as you wouldn't have a member for the nonTop10. so if you dragged in customers, you would get the same number repeating.
I am making a query that returns all the columns of any table EG in a table with this columns the query would return this value:
Table1
col1 int
col2 varchar
col3 datetime
Result:
col1, col2, col3
I am writing this query because I am so tired to write all the columns to do a query, and I...
@bluefeet I am 100% sure you can do everything you need except the Others group with tabular and Power View. But instead of showing the Others group, could you just show the % of total that the top 10 represent?
If you want to through a question out on DBA.SE or SO, I will tweet it out to BI people and see if anyone can offer a solution.
Assuming I remember my sql peeps correctly, DataOnWheels was part of the team that helped write Target's initial data mining / shopping cart algorithm. The one that famously predicted the teen girl was pregnant
I remember one time I had a meeting with a consultancy firm, they brought an "expert" in datamining. This expert went on to explain how he basically started the concept of datamining in the world, how he personally designed and did the break through in the "beers and diapers" (fictionally) case study.
I would like to know the main purpose of xp_cmdshell in sql. Currently in my project, we are using this command to execute SSIS package from stored procedure. So i need to know more about xp_cmdshell.
I am running xampp on Windows - Apache and MySQL start fine, but when I try to go to the directory where I have my example app, it loops infinitely waiting for localhost:
The log shows:
2014-08-22 16:38:18 10016 [Note] Plugin 'FEDERATED' is disabled.
2014-08-22 16:38:18 750 InnoDB: Warning: Usi...
I am making a query that returns all the columns of any table EG in a table with this columns the query would return this value:
Table1
col1 int
col2 varchar
col3 datetime
Result:
col1, col2, col3
I am writing this query because I am so tired to write all the columns to do a query, and I...
