Late to the party and many good songs have already been played. But I bring some more good ones:
Shortest
SELECT DISTINCT n FROM observations, unnest(ARRAY[a,b,c,d]) n;
However, a less verbose version of Andriy's idea is not much longer, but more elegant and faster.
For many distinct / few du...
I actually hoped he would, as I was almost sure he'd bring more value to the already good material available.
I have two tables, PROJECT and BILLINGS, as follows:
Project_ID Project_Client
---------- ------------------
P1 ABC Company
P2 DEF Company
P3 GHI Company
Proj_ID Bill_Date Bill_Amount
---------- ----------- -----------
P1 01-01-2013 123.45
P1 ...
Purely hypothetically speaking, of course, let's say the database client you are using does not support the BEGIN, COMMIT, or ROLLBACK instructions (or they are not thread safe, and your code must run in multiple threads), but can otherwise issue valid SQL commands.
What are some techniques you...
@AaronBertrand so if i have a filegroup spanning multiple disk mounts, one is capped (for space reasons) and one is on a fresh mount, what happens when 1117 tries to grow both of them?
Of course if you have filegroups with multiple files and they're different sizes and you only want some of them to ever grow, that's probably already enforced with either read size cap or no space available
I didn't try with a full disk but I did try with setting a max size = current size and it worked no problem, only growing the file that could, and no errors or warnings.
@AaronBertrand Did you notice that Books Online for 2016 talks about "Multiple TempDB Databases", but then goes on to describe creating multiple files? I wonder if multiple TempDB DBs was the original plan
Is the sql a good tag for DBA.SE? It seems like it is far too broad for most questions considering we'd need RDBMS, etc as a tag with it. I saw this post and this is sort of a follow up
@JamesLupolt i think contained logins does something funky with tempdb. it's like it spawns a db-specific tempdb or something. don't quote me on that ... but it's something i think i recall from a conversation with a coworker
@JNK I'm asking because I poked Shog about adding the warning to DBA when someone uses the sql tag to also include rdbms (similar to SO). He asked me if sql is even a good use on DBA?
Ideally, if we could force an RDBMS tag on all questions, that might be better. This is a DBA site, so most questions must be regarding a specific database?
Although there may be some specifc instances when people are asking about the standards...
@AaronBertrand Good to know. Someone did tell me multiple TempDBs was a common request, but I wasn't sure if there was anyone looking at implementing it.
Both DBA.SE and Stack Overflow suffer from a similar problem, when users post sql related questions there is a tendency to solely tag the question with sql but exclude the RDBMS.
This is great if they are looking for an ANSI standard answer but more times than not, they want an answer for a spe...
At one point, test database deployments within my department were handled directly by the database developers. The typical process was that the developer would unit test their changes in the development environment, then:
1) Migrate their changes to the test environment.
2) Send an email to the...
maybe I'm a bit stupid, or just missing some little detail. What is the point of closing questions if they don't get deleted? See this question, for instance:
I did some Googling and couldn't find an answer to this question more recent than a few years ago, so I thought I'd ask. Oracle's RAC feature offers load-balancing for both read and write transactions, as well as scale-out and high-availability without downtime (at least, as I understand it - we'...
@Lamak ok, I can see that. but "Closed as off-topic -> Shopping list question" should not stay, surely??? The reason we close it is so we don't have out-of-date carp on the site, no?
I guess I'm not going to VtC any shopping list questions 'cuz, why?
why waste my effort, I mean.
either that or I'm going to go and hit "delete" for all the "shopping-list" questions.
unless someone can show me the logic as to why they should be kept around.
Send this command to the server: set global general_log=1;
Find the log file (the default on Win7 it resides in
C:\ProgramData\MySQL\MySQL Server 5.1\data) and has a name just
like the computer.
Examine the log :)
Set the general_log back to 0 to return the DB server performance
back to norm...
Just set it once. And don't spend a lot of time on this, either. Every little bit helps, but if we draw an analogy from sports, the extra efficiency you get here is often going to be similar to the reduction in drag a swimmer gets by shaving their knuckles right before a meet. There are many other things you can spend your time optimizing that will be more like removing the 20kg weights attached to their ankles. — Aaron Bertrand ♦21 secs ago
@AaronBertrand i swam competitively in high school. i never once shaved my knuckles. perhaps that's why i never got a scholarship. — swasheck10 secs ago
@AaronBertrand I read your blog post on 2016 and tempdb. It's nice to see those TF behaviors enabled, but weaksauce for multiple tempdb files. I had hoped for more.
While I don't care personally, I can understand how a country would be pissed off if they bid to host the event and it was given to someone who gives better handjobs
You could try placing your hand on your chin and glancing upwards and say in your head "I wonder what my database was like back then" in the hopes of triggering a flashback. — Zane10 secs ago
I have a T-SQL agent job that I've created that adds steps to itself depending on a query of the MSDB database.
I am able to run the query outside of the agent, inside a query editor window, but when I try to run the query as a job I get the following errors:
Executed as user: [user with sys...
I know what happens when a cluster fails over. I'm asking you what happens with your services when you manually fail over. Does everything start working as expected? Or do you run into this problem no matter which node SQL Server is trying to use? — Aaron Bertrand ♦17 secs ago
Trying to figure out if he copied his response from a really bad training manual or really thinks I was asking how failover works
Sounds like he frankensteined his cluster together and has no idea how he even got it working in the first place. This is why my very first question was "who set up your cluster?"
It would be great if the suggested tag synonyms page:
http://dba.stackexchange.com/tags/synonyms?filter=suggested&tab=newest
Where displayed in the standard "Review" queue:
http://dba.stackexchange.com/review
This would encourage users with enough rep to actually up or down vote tag synonyms.
Late to the party and many good songs have already been played. But I bring some more good ones:
Shortest
SELECT DISTINCT n FROM observations, unnest(ARRAY[a,b,c,d]) n;
However, a less verbose version of Andriy's idea is not much longer, but more elegant and faster.
For many distinct / few du...
I have two tables, PROJECT and BILLINGS, as follows:
Project_ID Project_Client
---------- ------------------
P1 ABC Company
P2 DEF Company
P3 GHI Company
Proj_ID Bill_Date Bill_Amount
---------- ----------- -----------
P1 01-01-2013 123.45
P1 ...
Purely hypothetically speaking, of course, let's say the database client you are using does not support the BEGIN, COMMIT, or ROLLBACK instructions (or they are not thread safe, and your code must run in multiple threads), but can otherwise issue valid SQL commands.
What are some techniques you...
Both DBA.SE and Stack Overflow suffer from a similar problem, when users post sql related questions there is a tendency to solely tag the question with sql but exclude the RDBMS.
This is great if they are looking for an ANSI standard answer but more times than not, they want an answer for a spe...
At one point, test database deployments within my department were handled directly by the database developers. The typical process was that the developer would unit test their changes in the development environment, then:
1) Migrate their changes to the test environment.
2) Send an email to the...
How I can check which tables causing growth during six months time in SQL SERVER 2008?
I have a T-SQL agent job that I've created that adds steps to itself depending on a query of the MSDB database.
I am able to run the query outside of the agent, inside a query editor window, but when I try to run the query as a job I get the following errors:
Executed as user: [user with sys...
It would be great if the suggested tag synonyms page:
http://dba.stackexchange.com/tags/synonyms?filter=suggested&tab=newest
Where displayed in the standard "Review" queue:
http://dba.stackexchange.com/review
This would encourage users with enough rep to actually up or down vote tag synonyms.
