I have an MDF back up of a database.
I need some information from this MDF.
When I try to attach this MDF, it requires the log file with which it shipped.
I don't need the log file, but it insists on the LDF file.
I tried to point it to the same log file with which it shipped, but I am gettin...
@gbn Just before we get to that - you say you tested on build 3218, but there is no such public build - did you mean 3128? If so, that's essentially SP1 without CUs.
@ChrisTravers Hard to know for certain. Is there a Stack Exchange site dedicated to wood working issues? We could ask there.
Why does Facebook make it so difficult to contact Facebook at Facebook Support? You should have a place on Facebook devoted to problems - it took me nearly 3 hours to find this, and I don't even know if this is the right place. I have a few problem that FB can not answer my problem. The problem i...
So, since the progression of this was apparently somewhat difficult to follow the first time around:
I attempted a completely boring, been-done-a-thousand-times-before copy of a database using the copy database wizard with the detach/reattach method.
The copy failed. The log indicates that it ...
I'm writing a node.js app and have a series of functions that interact with a postgresql database using pg. They look like:
retrieve: function(query, complete){
pg.connect(connection, function(err, client, done){
client.query(query, function(err, results){
...
@bluefeet I'll give him the benefit of the doubt. If he is using the comma syntax only when he is joining 2-3 tables and he knows the benefits of the JOIN syntax, ah well. The question has no DBMS tag anyway and we've seen questions for dbms without JOIN :) (or without GROUP BY, I don't remember well.)
I just can't. I think we should be showing users especially new users proper ansi join syntax. Like I said to him, he would switch to ansi syntax if it was a left join. Why not make it the same both times?
Now my current database is working in SQL Server 2008 R2 and we are uploaded its only in 1 server. How can I migrate my existing database in to Hyper Table ? (My current database has huge amounts of data). I am not aware with Hyper table, any one help me?
I am using sql server 2012, I have a table of credit card transactions as follows:
CardScheme RespCode
=========================
Visa Declined
MasterCard Approved
MasterCard Approved
MasterCard Declined
Visa Declined
MasterCard Approved
MasterCard Declined
Visa Approve...
We moved from MS SQL SERVER 2000 to SQL SERVER 2005.
The client software, which I can not change, creates a user without option
CHECK_POLICY = OFF;
After creating a user, I have to run the command
ALTER LOGIN username WITH CHECK_POLICY = OFF;
Disable the policy, as recommended, I can not.
...
I'm trying to return a table with the depth of a node in a hierarchy represented using the nested set model, I'm following this tutorial but the query used in the section 'Finding the depth of Nodes' doesn't work for me: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/
SEL...
@MarkStorey-Smith proprietary RAID config is the first black magic that comes to mind. nobody can really explain it. "well, it's kinda like RAID 6 and kinda not"
I know this sounds like a newbie question, but it's pretty quick and specific. I'm a hardcore developer, and work mostly with mongo-db. I have some MS-SQL-Server experience. I need to get hands on and mind blowingly good at MySQL in a couple months. What would be the best way to get going in a live/realworld environment? Should I rent an AWS instance and build a MySQL based app?
Any other specific suggestions? (I should end up being comfortable with MySQL on Linux)
Amazon's free tier for the first 12 months actually looks pretty neat, they had a few different versions of MSSQL and MySQL, there may have been other RDBMSes as well
@gideon If you need to really learn administration, then mucking around in a VM is definitely going to give you learning opportunities that you won't get from a hosted database service.
@swasheck good idea! Why do you think postgres would be better, (not starting a flame war, i'd just like to know your opinion)
Also, I try and play with the data-stackexchange site but I still haven't really got a hang on writing eloquent SQL queries and stored procs.
Will this come with playing with the database? Or I'm thinking it's very data related, if you have complex data spread over tables then you'll be writing crazy queries for them.
Well part of the problem that I see is you have two tables that are de-normalized, meaning you basically have two tables that are designed as spreadsheets and not tables. The best solution to this problem would be to restructure your tables.
If possible, my advice would be to change the table st...
I read the book once. it's quite funny, but it was ghost written in the 1960s by a playwright, so the language is quite florid.
However, they did coin the phrase 'percussive sublimation', which was a great inspiration to me. I've suggested that certain people get their MCSE exams paid for so they get a better job - making them someone else's problem.
@gideon my opinion is that mysql allows too many standards-breaking "features." postgresql is quite good at being oracle-ish and holds to standards quite well (though most RDBMS' toss in their own variants on the standard). postgresql has some really remarkable advanced features whereas mysql has some "convenience" features that (generally) allow you to break standard.
worst-case has 34 questions with it and no tag wiki. Many of the questions appear to be very close to not constructive/too localized i.e what's the best case/worst-case for this?
Unless my lack of experience in the complexity (which many of these are also tagged with) is showing, this seems lik...
Disk writes are actually going to memory (NVRAM) on the filer, to be flushed to disk later - on an idle filer, these will be incredibly fast, and iops of 20,000 are quite believable (you'll see similar speeds from most SSDs).
Reads, on the other hand, need to come from disk unless they already h...
thankfully we have root access to the filers and FilerView - I know better than to change anything but at least we can really know what's going on
Though not for much longer, hopefully - since discovering SSDs we're moving most of our busy DB servers to solid state PCI cards or more SSD-friendly SANs
the only constraint we have at the moment is shared-storage stuff, which consists of most of our MSSQL Clusters (really bummed that AlwaysOn is an Enterprise feature), but at least we don't have any RAC or PureScale to worry about
@swasheck TBH I don't think SANs are all that complex as such, but the storage config definitely encourages an 'every problem is a nail' mentality in SAN admins. Same thing goes with VMs
shared-nothing redundancy at the DB level has been maturing as quickly over the past few years as fault tolerance / live migration in virtual environments, and it's hard to know which horse to back. Maybe I'm just leaning towards redundancy at the database level because I have more control over it
my goodness, it's after midnight, I should get some shut-eye. 'night all
I know that I've made checkins to files, particularly because I know that Paul and I worked on the one, and someone else is investigating slow performance, and guess where my code is ...
@jcolebrand Previous versions, or changes overwritten by someone checking in a file based on a version that you hadn't made the change in - I've found TFS is prone to race conditions if you're using optimistic locking.
I want to see if I can get my city to upfront some of the cost to see if google would be interested in MSP. If we just spent 500 Million dollars to cover the other half of a stadium I don't see why they wouldn't want fiber.
We've now removed the WIT, so that leaves SCC and CI
I can configure some other CI system in a matter of days (we have a lot of disparate projects here to build) that will work just as well, and we can use the default baked-in MSBuild support to do the CI deploys
@gideon certainly. i'll be honest and say that i learned database stuff on mysql ... but that was primarily basic DDL and DML ... nothing "advanced." once the advanced usage needed to kick in i was already on to SQL Server and postgres
I have an MDF back up of a database.
I need some information from this MDF.
When I try to attach this MDF, it requires the log file with which it shipped.
I don't need the log file, but it insists on the LDF file.
I tried to point it to the same log file with which it shipped, but I am gettin...
So, since the progression of this was apparently somewhat difficult to follow the first time around:
I attempted a completely boring, been-done-a-thousand-times-before copy of a database using the copy database wizard with the detach/reattach method.
The copy failed. The log indicates that it ...
I'm writing a node.js app and have a series of functions that interact with a postgresql database using pg. They look like:
retrieve: function(query, complete){
pg.connect(connection, function(err, client, done){
client.query(query, function(err, results){
...
Now my current database is working in SQL Server 2008 R2 and we are uploaded its only in 1 server. How can I migrate my existing database in to Hyper Table ? (My current database has huge amounts of data). I am not aware with Hyper table, any one help me?
We moved from MS SQL SERVER 2000 to SQL SERVER 2005.
The client software, which I can not change, creates a user without option
CHECK_POLICY = OFF;
After creating a user, I have to run the command
ALTER LOGIN username WITH CHECK_POLICY = OFF;
Disable the policy, as recommended, I can not.
...
I'm trying to return a table with the depth of a node in a hierarchy represented using the nested set model, I'm following this tutorial but the query used in the section 'Finding the depth of Nodes' doesn't work for me: http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/
SEL...
