I am not sure if this question can be asked here or serverfault. I was wondering...Is there is a way to quickly undo the changes made by SQL Server 2005 Tuning Advsor other than recovering from a backup?
i managed to get an answer on stackoverflow, where the community seems more active and they do answer a lot on mysql stuff, i did an INNER join table ON condition (where it displays only the ON condition id's)...and worked :) — Adrian TanaseOct 14 at 7:21
but
The query seems to have several syntax errors. And there is no condition for joining the two tables: myl_contacts and mya_users — ypercubeOct 8 at 14:05
sigh
@dezso I'm pretty sure this one was Phil (unless you have been brushing up on UK slang) :)
@SQLkiwi so do you feel rested after your 3 hours of sleep?
If I have a column with data type varchar(max) in a table that contains a big piece of text, can I make a connection between a word or a sentence in that text with another word or a sentence in another column with data type varchar(max) in different table?
For example, if I wrote a word in the f...
I am planning to apply PAGE compression to some of the big tables in my database (DW to be precise). These tables are fairly big with over 15 Billion rows. When I applied the compression in test environment, the whole process took around 22 hours.These tables are accessed daily with quite long ru...
"My question is how and when does SQL Server create multiple leaf
levels (index_level 0) for the same index."
The 2008 R2 documentation for sys.dm_db_index_physical_stats includes a link to Table and Index Organization, which shows the following diagram:
It describes the data that may b...
There is not a blanket ban on this sort of question, but you must stay within the guidelines in the faq:
You should only ask practical, answerable questions based on actual problems that you face
Your questions should be reasonably scoped.
If your motivation for asking the question is ...
Shouldn't we add that such questions may be asked here as well?
I use PostgreSQL 9.2. I have a table with ~5 Mio rows and 150 columns. The table does not change at all (I replace it once a year). Users query this table with all kinds of filters on any some of the columns, e.g.
select * from table where C > 43 and H is not null;
select * from table where A...
Hello In Full mode the transaction log keeps growing until you back up the database. In Simple mode: space in the transaction log is 'recycled' every Checkpoint.
1) is that mean that when im backingup the SQL , the ldf file will be 0 bytes ?
1. A backup is a copy of all used data pages + any changes that happen during the backup. The LDF isn't backed up. Neither is the MDF for that matter: only the pages
But, the info on them (path, site, growth etc) is also saved so they can be created/replaced on RESTORE if they don't exist or are currently different
Sorry , I must be missing something : if I have a 1gb ldf file. and i backup the whole DB. does sqk start writing transaction logs from the Beginning of the file ? as opposed to not backup , and appending the 1GB ?
@gbn yes though on Oracle at least it is possible to gather statistics without histograms. As an aside, multi-column (aka 'extended') statistics are lush.
One of my co-workers named a stored procedure in our SQL Server 2008 R2 database 'sp_something'. When I saw this, I immediately thought: "That is WRONG!" and started searching my bookmarks for this online article that explains why it is wrong, so I could provide my co-worker with an explanation.
...
Oracle came back with [Error] Execution (1: 1): ORA-03113: end-of-file on communication channel AGAIN! What does this mean when executing one particular proc?
I recreated the package yesterday and the problem went away, but now it's back...
@JackDouglas Windows Server 2008 Std 32-bit. There are two statements in the SP, one which loads a config into a row and then a giant select. One of the later test environments seems to have the same Oracle version, so let me see. It seems unlikely to repro there, because otherwise we would have seen this before. Client has a DBA team who I have forwarded this to. They seem pretty competent. I like to stay in SQL and not have to get into this kind of crap, but stuff like this makes me look bad
@JackDouglas back in the old days, my grandfather would mail me books with tapes of him reading those books to me. that story was one of them. when you said that, i was instantly transported back in time nearly three decades
@JackDouglas It is directly-related to a new piece of code which appends a comma separated list of traits (based on a link table) to a tank name. There is a scalar function which retrieves that, and when I comment that out it doesn't get the error.
@CadeRoux can you repro by calling that function from plain SQL? I'd be aiming for a minimal reproduction before tinkering with the code to work around it...
@JackDouglas This is par for the course with Oracle, isn't it? A cryptic error unrelated to the SQL on perfectly valid SQL and an inexplicable dependency on version and sensitivity to order of operations.
@JackDouglas No, just for stability and not being left behind. Like I would move a bog-standard ASP.NET app like this one on 2000 or 2005 to 2008R2. There's no rocket science in this CRUD app.
@CadeRoux I don't think 11.2 is 'more stable' than 10.2, just different bugs. There is certainly some logic in the 'not getting left behind' reasoning though. 10.2 to 11.2 is reasonably straightforward in my experience but YMMV
Are you licensed for 11.2 or would you have to pay?
@JackDouglas Only problem I have seen when I last tried to do it was issues with the .NET provider/ODP.NET vs. Microsoft driver because this app still has a hodge-podge of data-access mechanisms I'm still trying to clean up.
@JackDouglas Not sure about licensing. This app is small enough (because each site has their own) that I would recommend the express edition. I've mentioned it before, but they are probably worried about support. They are married to Oracle because they run financials on Oracle as well...
@JackDouglas Well, I have dreams for them to get to a proactive state on this entire system. Right now there's a lot of firefighting and janitorial duties.
"i need an update made to my report." "ok. which one?" "MY report." "right. what's the name of the report and how do you get this report?" "isn't that YOUR job? do you give this level of service to everyone?" ...
@JackDouglas I guess so. I made another copy of the package under a different name and it still has the problem. The DBA wanted to test it after bouncing the server. So that's what's going to happen in a few minutes. And then I expect it may still happen and then I think they would want to look at patching it up first before talking to Oracle.
I am not sure if this question can be asked here or serverfault. I was wondering...Is there is a way to quickly undo the changes made by SQL Server 2005 Tuning Advsor other than recovering from a backup?
@swasheck I'm betting it will get paid. Companies have too much invested into the patent culture they can't burn their own bridges or risk damaging the landscape. Even if it means a bit of hurt here and there.
thinG -> thinK of course. First hour of the morning, forgive me spellerings. I'm norwally good.
@RichardTheKiwi And he gave you a bounty :-), you have a groupie
@RichardTheKiwi and now that I remember, a couple of months ago, when you were inactive, I stumbled upon a question in wich the user was upset since you were no longer around and that the rest of the answers were crap
@RichardTheKiwi personally i think that what i've sensed from him (as well as myself) is that the chatroom has taken a turn for the worse. certainly that's subjective, and therefore a matter of opinion.
@RichardTheKiwi This is Microsoft vs. someone with no money - they might settle to save money, but Apple vs. Samsung was an incompetent judge and jury tampering and Apple lost their similar cases in other countries.
SELECT qty_in_stock - qty_sold as qty_remaining FROM products You would expect qty_remaining to be -1, right? Wrong! In fact MySQL returns 18446744073709551615 !
I have a database with about five possible index columns, all of which are useful in different ways. Let's call them System, Source, Heat, Time, and Row. Using System and Row together will make a unique key, and if sorted by System-Row the database will also be sorted for any combination of the...
@DTest Yes, you would expect to get an error. MySQL rarely throws errors, as it always goes over the top to be as helpful as possible around errors, e.g. mixing aggs and non-aggs in a GROUP BY.
SQL-SERVER:
create table t1 (id int, s tinyint); insert t1 select 1,1 union all select 2,2; select a.s-b.s from t1 a join t1 b on a.id=1 and b.id=2;
*Msg 8115, Level 16, State 2, Line 7* *Arithmetic overflow error converting expression to data type tinyint.*
I use PostgreSQL 9.2. I have a table with ~5 million rows and 150 columns. The table does not change at all (I replace it once a year). Users query this table with all kinds of filters on any some of the columns, e.g.
select * from table where C > 43 and H is not null;
select * from table whe...
Title: Do I risk losing the benefits of indexing if I have an index on every column? Question: Is it good design for the above described use case to create an index on every column? Answer: The answer is (almost always) no.
I am not sure if this question can be asked here or serverfault. I was wondering...Is there is a way to quickly undo the changes made by SQL Server 2005 Tuning Advsor other than recovering from a backup?
What is the etymology of of the word "tablespace" in Oracle?
"My question is how and when does SQL Server create multiple leaf
levels (index_level 0) for the same index."
The 2008 R2 documentation for sys.dm_db_index_physical_stats includes a link to Table and Index Organization, which shows the following diagram:
It describes the data that may b...
Some answers on the site like this one and this one include tables drawn with ascii art. Is this done by hand or is there a tool I can use to help me?
I use PostgreSQL 9.2. I have a table with ~5 Mio rows and 150 columns. The table does not change at all (I replace it once a year). Users query this table with all kinds of filters on any some of the columns, e.g.
select * from table where C > 43 and H is not null;
select * from table where A...
I have a database with about five possible index columns, all of which are useful in different ways. Let's call them System, Source, Heat, Time, and Row. Using System and Row together will make a unique key, and if sorted by System-Row the database will also be sorted for any combination of the...
