@swasheck It's hard to guess without a copy of the data to examine. Ordinarily I would not expect the plan to recompile after that many modifications, so something is missing there. Other details might matter too e.g. which version/cardinality estimator were you using ... and so on.
@JNK That's nothing. I recently investigated an issue, only to find out I had written about it already!
@PaulWhite I wanted to filter a result set on that property and predicates like FUNCTION(Column) = Value always make me think about SARGability. Performance wasn't important in that particular case but I thought it might help to know in the future.
@James changing the elevator/scheduler setting to deadline or noop did not help. I have changed innodb_doublewrite as well and it looks like the stall times have gone up from 1-2 minutes to 3-4 minutes. WTF.
It's just a Google search page because I think you're fairly capable of following the relevant links there, and discover why UDFs in check constraints are a bad idea, without me having to copy and paste each link individually for you... — Aaron Bertrand20 secs ago
@Marian It's about isolation mostly, and it's really restricted to the metadata helpers like OBJECT_ID, OBJECT_NAME, etc. I should do some testing with OBJECTPROPERTY - I have a blog post coming out soon about this.
I don't think OBJECTPROPERTY is as complex under the covers - it's older and I suspect it's not prone to the same problem.
The constraint can't even be added to the table if there already exists a row with IsSuccess = 1 ... and if the constraint is added to an empty table (which isn't the OP's use case), no row with IsSuccess = 1 could ever be added. The important part to note here is that the constraint checks the existing data in the table and the row(s) just inserted. — Aaron Bertrand36 secs ago
But a lot of installations and kits (like Wordpress, Drupal, etc.) are old out there and using the MyISAM engine. Which is not improved any more. Focus is given on InnoDB.
@the-wabbit well, usually I post a direct link, but in this case there are several. Gordon is a big boy and should have been able to read the links without being a smartass about it.
@ypercube No, I thought so too, but that doesn't quite work, since it would still allow rows with 0 to be inserted. I think a trigger should be used here.
I think you would have to do this by defining a function. check constraints only work on one row's worth of data, and there is nothing within a row that distinguishes an allowable update or failed update. I also cannot think of a way to use a unique index for this problem. But, something like ...
@JNK From time to time, I stumble upon a question with a well-researched answer which I want to upvote - only to discover that I can't because it is my answer.
hello, Is there a Visual Studio Deveploper edition like SQL developer Edition microsoftstore.com/store/msusa/en_US/pdp/…, that the price would be not too expesive, less than 100 dollars?
> The app has received USD$1 million in investment from a group of investors led by Moshe Hogeg, CEO of Mobli, who had originally asked Arbel to design a single-button app to call his assistant.[2] In July 2014 the app was also released for Windows Phone.[3] The app was valued at between $5 and $10 million in July 2014 and received a further $1.5 million in funding
@PaulWhite sure. sorry i left out that information. sql server 2014. both estimator versions (using trace flaggery). specifically recompiling the plan with option (recompile), though (so as to brute force no parameter sniffing, though i'm sure i'm missing something given the trivial plan).
I have one table in vertica. Table name sub_temp. Mapping key is an identity column.Data is as follows:
MAPPING_KEY | SUBSCRIBER_KEY | DATASOCCODE
-------------+----------------+-------------
1 | 1 | 123
2 | 1 | 456
250001 | 1 |...
I'm newer to MDX than Rob Ford is to sobriety. Im not sure if the Keys are the same, but the captions are. To be honest, I don't even know what information to give you such that you are able to answer my question effectively. Super String Theory is easier for me to wrap my head around. — Gemione5 mins ago
I will stay off of my soapbox for now, except to say this: To most end users, that is all your Data Warehouse is. You can create the best model, the most effective ETL, but your end users usually see none of that. Your reports (or the methods by which they do ad hoc) are the way you deliver information to clients. The entire purpose of a DW is to deliver info to the business.
@mmarie as true as that may be that doesn't mean I have fun using it. Query and index tuning are fun for me to do. SSIS development I also find quite enjoyable.
@swasheck as @mmarie, database is a simple matter. Just like any other DB on an AG. For the actual SSRS implementation, you need to do a scale out deployment
@JNK it's an internal black-ops thing. not really ever going to happen because "cognos is the standard." however, if we can use report designer to copy some of the reports and then demonstrate a code quality and performance improvement, then at least we can remind them that it's their model that sucks and not sql server
Ok, DBAs, I need help. I had to DBA promote a stored procedure to production. It works perfectly in the other environments. When I run it in prod I get Msg 2797, Level 16, State 1, Procedure DW_Column_Profile, Line 18 The default schema does not exist. I understand this to mean that there is a non-existent default schema set for my user...
when i select schema_name() I get null
i don't have a specific login. I think i have access through an AD group that is mapped to a login or something. How can i figure how what login it is that has no default schema on the database?
The default schema is set at the database level, so you need to map sys.server_principals to sys.database_principals to figure out what the default schema is at the db level (they join on sid).
(Also you can probably get around this completely by calling the procedure right, e.g. EXEC dbo.DW_Column_Profile instead of EXEC DW_Column_Profile)
And make sure the references inside are also explicit by schema. Then it doesn't have to check the current user's default schema at all.
This question: unloading data from oracle dbf files
Was closed as a duplicate. I went to find out the original question (and answer): http://dba.stackexchange.com/questions/43637/restore-oracle-database-from-dbf-files
And received a "Page not found"?
yeah, their knowledgeable dba is out right now. they have a brand new dba who doesn't know anything yet. I'm trying to work through this for him and tell him what to do if I can't do it myself.
@mmarie tell him to suck it up. what happens if there's a disaster or something? "sorry, cant restore backups without the sr. dba telling me to do it."
@mmarie You're right, my bad, I've never used it that way before. Anyway the problem is still the same - the user doesn't have a default schema, and SQL Server is trying to find it because of some unqualified references somewhere.
@mmarie um, it's a clustered instance of SQL Server? He shouldn't care that it's a cluster because he shouldn't be connecting to physical node, he should be connecting to the virtual server name. In a clustered instance there isn't one that's write and one that's read only. There is one instance that lives on one of the nodes - the other nodes are standby and aren't running SQL Server at all until there is a failover.
Stack Overflow, please stop sending us your </facepalm> users
@ZoKu And like I said, this assumes you can control - forever - that this procedure will never change and that it will always be the only way you ever run an update against this table. That's not a very safe assumption. If this is school work, wasn't any of this material covered? — Aaron Bertrand ♦1 min ago
I am looking for free sql server tool with the following features.
Visual schema management for adding tables and fields.
Sync schema with other schema and build upgrade script.
Simple query editor.
Free tool will be best, if you know one.
I am using sql server express 2012.
Thanks
@Kermit can he e-mail you anywhere? I know you are very protective of your e-mail address. I suggested you get a different account (like kermit_loves_boys@gmail) but Max is suggesting setting one up for you.
@MaxVernon why the hell are you troubleshooting 2000 - can I serenade you with "Let it go" from Frozen?
Stack Overflow is beginning an experiment called Stack Overflow TV, or SOTV for short.
It will be a series of fast, smart videos for experienced programmers who want to learn a new thing. The videos will serve as a complement to Stack’s Q&A, and intended for that community. Of course, they will ...
@AaronBertrand lololol. I cannot believe we still have many 2000 instances. and a great many more 2005/2008/2008R2. I think we have 1 2012 instance so far.
Finally got around to datafart.com - why? How could it possibly be easier to put that data into a command line and send to some URL, than charting a billion different ways in Excel?
I guess he admits that it is not useful for most people.
Client :
- Windows 7 SP1 32bit
- With SQL Express - Advance series installed (with VS2008)
Server:
- Database: SQL Server 2008R2 Enterprise Ed., 64bit
- OS: Windows Server 2008
I always get the message "To design IS packages in BIDS, BIDS has to be installed"
What am I missing here?
Real...
I get the below error running a CREATE DATABASE script...
CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'H:\TestDatabase.mdf'
I am logged in as 'sa', which is a sysadmin.
What am I m...
I have a table ACCOUNT(ACCOUNT_NUMBER,BRANCH_NAME,BALANCE)
Now I need to find in Oracle SQL : all accounts with balances over R.100000 receive 6 percent interest whereas all others receive 5 percent.
I need to display the balance with 6% and balance with 5% in two different column.
What is the...
I think you would have to do this by defining a function. check constraints only work on one row's worth of data, and there is nothing within a row that distinguishes an allowable update or failed update. I also cannot think of a way to use a unique index for this problem. But, something like ...
I have one table in vertica. Table name sub_temp. Mapping key is an identity column.Data is as follows:
MAPPING_KEY | SUBSCRIBER_KEY | DATASOCCODE
-------------+----------------+-------------
1 | 1 | 123
2 | 1 | 456
250001 | 1 |...
This question: unloading data from oracle dbf files
Was closed as a duplicate. I went to find out the original question (and answer): http://dba.stackexchange.com/questions/43637/restore-oracle-database-from-dbf-files
And received a "Page not found"?
I am looking for free sql server tool with the following features.
Visual schema management for adding tables and fields.
Sync schema with other schema and build upgrade script.
Simple query editor.
Free tool will be best, if you know one.
I am using sql server express 2012.
Thanks
Client :
- Windows 7 SP1 32bit
- With SQL Express - Advance series installed (with VS2008)
Server:
- Database: SQL Server 2008R2 Enterprise Ed., 64bit
- OS: Windows Server 2008
I always get the message "To design IS packages in BIDS, BIDS has to be installed"
What am I missing here?
Real...
I get the below error running a CREATE DATABASE script...
CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'H:\TestDatabase.mdf'
I am logged in as 'sa', which is a sysadmin.
What am I m...
I have a table ACCOUNT(ACCOUNT_NUMBER,BRANCH_NAME,BALANCE)
Now I need to find in Oracle SQL : all accounts with balances over R.100000 receive 6 percent interest whereas all others receive 5 percent.
I need to display the balance with 6% and balance with 5% in two different column.
What is the...
