Hello. I'm using this analysis query , Which I think is pretty popular (And i'll be happy to be corrected , if there's a better one) but my question is : Is it possible to add the actual object name to the query ? I've already seen that name can be found , But In my SP above , there is no dm_exec_procedure_stats . How can I include object name into my query ?
dm_exec_sql_text will return NULL in <= 2008R2 for adhoc and prepared statements. Whereas plan_attributes would return the database in which the statement was compiled and executed
Depends if that is of importance to you or not
It may still be the case in some scenarios (I never changed this once upgrading to 2012), so you could always check both and let us know
It's "fat tuesday" today (at least that's what it's called in Sweden). Translated to french, that's "mardi gras".
Personally, I think the day signifies the point where people break their new-year's resolutions, stop going to the gym and start eating buns with whipped cream.
Scenario - I've got a database with a couple of very crappy, poorly designed tables. We wrapped these crappy tables up in a couple of views that make a lot more sense logically. Is attempting to insert directly to the views rather than the crappy underlying tables pure insanity?
Looking at the create-view statements I think it might be. They include table functions and at least one of them includes calls to sql_variant_property.
@Lamak might look into that myself then. We currently have a trigger based auditing solution (dating from when we ran 2005) and I'm wondering if we'd benefit from running a temporal solution (space, performance, querying ability) in SQL Server 2016
I'm a front end dev and this is my first time doing serious database work. I have json sent to the client that looks like this:
prop[0].event.history = 'foo'; //can also be 'bar'
I wanted to inspect the database to specifically find values of foo or bar.
how can I search pgAdminIII to find th...
Searching for solution to SSIS problem. Find answer on Stack Overflow by @billinkc. Answer starts: This is not as straight forward as it ought to be. That or I need to go back to SSIS class.hopes_deleted.png
This is not as straight forward as it ought to be. That or I need to go back to SSIS class.
The OLE DB Command component can't add new rows to the dataflow, as it's a synchronous component.
It also cannot add new columns to the data flow. That's the first thing that was non-intuitive. So you'l...
Oh, yeah, that too. The client I'm on does the same thing - except they used a derived column to generate the placeholder versus faking it in the query
Is a stored procedure plan a thing? I thought that after OPTION (RECOMPILE) was introduced, a stored procedure plan became merely a collection of the plans of the SP's individual statements. (Or perhaps it's been so always, we just had little control over the individual parts.) Anyway, is there more to it than that?
Does anyone know what happens if a HP Vertica audit reveals higher than licensed usage? (Not by a whole lot, just a little -- Was contacted by HP just wondering what the fall out may be).
Not really experienced with here, just looking for any past experiences, any guidance here?
@KrisGruttemeyer Then by that definition an index rebuild is modifying the underlying index structure. Stand by your down vote and I will stand by my answer. A fill factor change does not take much longer than a rebuild. Three fill factor changes and a sort - worth a try in my book. — Frisbee2 hours ago
If you have enterprise version, you probably need to consider partition switching. This way you will be able to plug-in big portions of data in milliseconds. Just prepare empty table with exactly same structure, use tablock hint for insert and then switch it into the production table. If you ran into issues you may want to check this link: sqlfool.com/2009/10/partitioning-tricks — yahor1 min ago
@yahor nothing in the OP's question leads me to believe that partition switching will help him. He needs to find a way to eliminate that spool that's costing so much however without more query info may be hard to say how. — Zane52 secs ago
And seems to be at -2 +2 since my comment on that mess, so finally downvoted (I didn't want to downvote right after the comment because that gets his panties in a bunch)
@Zane Ha reminds me of some guy. After a support call with Microsoft the trace flag disabling lock escalation fixes an issue, he's now suggesting it as a best practice saying "it was recommended by microsoft and in that example it cut execution time by 70%"
@bluefeet I don't think I understand @mikeTheLiar's problem well enough to begin an SSIS answer but I strongly suspect it starts with "I'd preprocess the file with C#"
@TomV I like your following take on normalization, particularly because you emphasize the importance of the meaning and nature that the things hold in their own specific context (and this is my interpretation of what Codd prescribed). This approach is commonly much more practical than the use of abstractions, as you rightly point out.
I think you need to reconsider whether the payment for the dates is done on the hire (or rather the transaction) or the customer.
When thinking about normalization you need to think in terms of properties of an entity rather than something abstract so I want you to think if day in and out, and t...
@zane And a lot of the detail was added after my answer. If you will note in the comments I was the first to ask if the query itself was slow. — Frisbee31 secs ago
Is there a reason to use sys.database_files over sys.master_files? Especially if I'm about to write a cursor to pull the size/model/etc data for all the databases?
I'm a front end dev and this is my first time doing serious database work. I have json sent to the client that looks like this:
prop[0].event.history = 'foo'; //can also be 'bar'
I wanted to inspect the database to specifically find values of foo or bar.
how can I search pgAdminIII to find th...
This is not as straight forward as it ought to be. That or I need to go back to SSIS class.
The OLE DB Command component can't add new rows to the dataflow, as it's a synchronous component.
It also cannot add new columns to the data flow. That's the first thing that was non-intuitive. So you'l...
Does anyone know what happens if a HP Vertica audit reveals higher than licensed usage? (Not by a whole lot, just a little -- Was contacted by HP just wondering what the fall out may be).
Not really experienced with here, just looking for any past experiences, any guidance here?
