My feature request (or anti-feature-request perhaps) is the following:
Let's stop displaying a user's accept rate.
For those of you who know "Fawlty Towers", the whole issue of a visible accept rate and our behavior towards it starts to feel like "Don't mention the war!".
We generally seem to ...
When it comes to dates, the best practice is to give the written alternative to the month - that way there is no chance that the day and month can get mixed up along the way. Try inputting the dates as string in the following format:
'dd MMM yyyy'
$query = "asistencia_virtual '01 Jan 2012', '31...
@bluefeet WOW - that is a surprising turnabout, I think. Yes, it does seem to allow bad behavior. However, we do still want to encourage people to accept an answer SO THAT OTHER PEOPLE KNOW WHICH ANSWER BEST SOLVED THE PROBLEM. But I always cringe when I see people be told to work on their accept rate. I've been told to work on my accept rate - I told that user to go try to answer the questions I didn't accept an answer on.
Whoever wrote that particular parser ... or rather, whoever vetted that particular date parsing format, somewhere out in old France or something, should be kicked in the head.
@billinkc you can, as long as (a) you don't use any Enterprise features and (b) you don't exceed the data file size limitation of Express (10GB for 2008 R2 & 2012).
@jcolebrand indeed. I've been yelling about this for years but Microsoft won't listen. At least the format doesn't break the new types (yyyy-mm-dd is perfectly fine when explicitly casting to DATE). However it introduces yet another inconsistency - dashes are safe for date but not for datetime. <shrug>
@AaronBertrand @billinkc and as we have our suspicions at this point, you can have 20,000+ instances (probably not all attached at once) on SQLExpress ;-)
@AaronBertrand What I don't get is how people don't just intuitively grasp the concept of "least to most specificity"
year -> month -> date -> hour -> minute -> second -> subdivisions of seconds
It's so pure, I'm sure a child could figure out that was the best way to find non-colliding indexing of dates.
I mentioned in here the other day - I put 1974-02-01 on my daughter's birth certificate forms, and they messed it up (birth certificate arrived with January 2nd)
It's not like I pulled a Canadian (01/02/1974 vs 02/01/1974). That format really should be unamfuckingbiguous.
@AaronBertrand I estimate 60mph regardless if the interstate is 60, 65 or 70 in between, then add a half hour (or an hour if the arrival time will be roughly rush hour)
@AaronBertrand I do need to get out to the NE at some point. Been to Baltimore once and that's the extent of my experience there. The SQL Saturday in boston area conflicts with something else
@AaronBertrand I invariably run up on patches of slow traffic, have to weave through them, and re-accelerate. I've found that this estimate of travel time usually allows me to arrive early, but sometimes I'm reduced to "right on time". I also get plenty of time to stop for piss breaks and stretching my legs.
Good afternoon,
I'm looking for a good client tool to replace "Oracle SQL Developer" (the tool I currently use) which supports
Oracle DB 10g, 10gR2, 11g
Running SQL code
Debugging SQL code (with walk-through... click error, jumps to error line)
Do you know of one (preferably free)?
Thanks f...
I agree, like I said in my comment on there; "Personally I find these kinds of questions both interesting and useful, as they may share valuable insight into relevant products and use cases"
But then I don't make policies around here, just trying to understand them :)
@Roy The problem is they can quickly degenerate into spam traps for link farmers. Also, keep in mind that the focus of SE sites is fact over opinion. Shopping style questions are by their nature very subjective.
@MarkStorey-Smith Won't community moderation/voting take care of both problems?
@MarkStorey-Smith Not entirely sure I see why book, software or other product references can't be just as factual (or not) as any other aspect of the site.
Anyone experienced an out of memory exception in Sql server 2008 r2 standard? I read in the following link http://msdn.microsoft.com/en-gb/library/cc645993(v=sql.105).aspx that it can utilise 64gigs of memory, so i decided to run a "select *" query in ssms to see if i could max it out. In task manager its only showing 855mb and then im getting this error.
@MarkStorey-Smith I am assuming its an SSMS exception (i might be wrong) as its displayed in the "Messages" tab in ssms. This is the actual error "An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown. "
@MarkStorey-Smith I'm just not sure that product references tied to use cases are any more opinionated than any other "how may I accomplish this" kind of question. :)
@MarkStorey-Smith Ayway, my question was about that particular question, and why it has been around for a year when it very much looks like it is a violation of site policy.
Just wondering if there was something about that question that made it exempt from the general rule about shopping lists
I have a function that has one parameter of a table type, i want to loop through all the fields and return the column that has a null or empty value.
CREATE OR REPLACE FUNCTION toned.function_validate(varmember tbl_member)
RETURNS text AS
$BODY$
...
The definition of tbl_member below
CREATE...
@HansRudel That's an error from the SSMS grid results component. Try the 'results to text' option instead - the grid is very slow and consumes a lot of memory. Better still, enable the 'discard results' option in SSMS if all you are trying to do is test the time it takes for SQL Server to send the results to the client app.
@SQLKiwi i was just looking to check that all the data had been loaded initially. Changed the query to Select top 1000 * instead. Cheer for the tip about "discard results/results to text", will make a note of that.
@HansRudel not sure if this was mentioned elsewhere, but I never rely on Task Manager to tell you how much memory a process is taking. Use perfmon or one of the sysinternals tools.
@aaronbertrand, id never heard of prefmon before, just found a guide on setting it up so will have a look. Atm im having some issues with the Entity Data Model Wizard seeing my database.
@HansRudel ok, I'll bite. Is your database attached to an instance of SQL Server already? What is the instance name and is it on the same machine as Visual Studio? What does "having issues seeing my database" mean? Do you get a specific error message? What is it?
And what is the connection string or other method that you used to point Visual Studio at your database?
Is the there network issues preventing you from seeing the database in your project? Do you have to right login credentials to connect to that database? Or is the issue you cannot find the database in wizard to begin with?
@HansRudel no, you definitely have two instances of SQL Server there. Show us a screen shot of SQL Server Configuration Manager > SQL Server Services (with the "Name" column fully visible).
@HansRudel probably because you installed Visual Studio and accepted the default option of installing an instance of SQLEXPRESS, then installed a real instance of SQL Server.
@HansRudel if you only need one instance, perhaps, but then it really depends - if you are writing software for distribution, for example, and you plan for it to run on SQL Server Express, you should develop on Express so that you don't use any features that are only supported on better editions.
Might be safer to go into Control Panel > Administrative Tools > Services, find the SQL Server (SQLEXPRESS) service, stop it, and set its startup to manual. This way it is not taking up your resources but you can fire it up if you ever need to.
So the database HistoricalData is not on the express version though right? I just closed everything down and reopened and there is no option to select FrazMann-PC\SqlExpress
just checking. ok, just set sqlserver(sqlexpress) to manual. If im sure i wont need the express version, can i set it disabled? I dont want to accidentally open it instead
For anyone here who has read more than a couple of my posts on sqlperformance.com, I made some cosmetic changes last night (primarily to fonts). Can you let me know if it looks ok, and especially if you find any of the text blurry or otherwise hard to read?
Also we have been troubleshooting some speed issues, particularly on the front page, and as a result made a bunch of changes to various plug-ins. I'd love to hear whether you found the site fast, tolerable, or frustratingly sluggish.
I want to make sure the resource is usable. Thanks in advance!
I have the following case statement and the IsNull portion is not registering and I am curious if I have it setup correctly.
CASE WHEN IsNull(2010) THEN 0 END) * CASE WHEN IsNumeric([Dur_In_Hours]) =1 THEN CAST([Dur_In_Hours] AS FLOAT) ELSE 0 END) AS Cost
How do I aggregate like sets of data.
The example below shows how the raw data and desired output.
DECLARE @Data TABLE (PID INT, CID INT)
INSERT INTO @Data
VALUES (1, 1), (1, 2), (1, 3), (3, 1), (3, 2), (3, 3), (2, 1), (2, 2), (4, 3), (4, 4),
(5, 4), (5, 5), (8, 4), (8, 5), (6, 6), ...
We have a table which keeps the log of internet usage inside our company. this table is filled by a software bought by us and we cannot make any changes to its table. This table does not have a unique key or index (to make the data writing faster as its developers say)
I need to read the data in...
@Zane I think what have you tried is often a valid question. Do you know how many times I've spent 15-20 minutes crafting an answer, only to be told they'd already tried that and it wasn't an option because of <x>? And sometimes even been down-voted for it? It may come across as snarky but it's a question that shouldn't NEED to be asked.
@Zane start up user wouldn't show an accept rate at all until they had <n> questions (I don't know the algorithm). So it's not like it would show 0% on their first question.
@bluefeet sure, if they were using a double before, suggesting a float could be sensible. But looking closer at the column names, I want to know why this needs to be a float - especially when multiplication is involved. That could potentially be some ugly-ass output.
What is the algorithm for question ban? Somewhere between this and one more bad question?
@jcolebrand I have two MBPs with Mountain Lion but I'm having a real hard time seeing the actual issue in your screen shots. Is there a pixel difference that 20/10 vision is just not picking up?
@rfusca Don't ask about anything that is not pertinent to the job. Thus: marital status, religion, home town, age, etc. Seems like simple stuff but it's easy if you're trying to get a feel for their personality to ask something that could be construed as leading to discrimination.
@jcolebrand spaces are built in - just lets you switch between multiple desktops (where app windows stay with a certain "space"). So it is easy to switch from e-mail mode to code mode etc.
@jcolebrand plus on two 30" monitors, where I do most of my work, window layout is a little more fluid.
@jcolebrand in Mountain Lion (or maybe Lion? I forget now) they incorporated spaces into launchpad / mission control. Hit Ctrl + left-arrow or right-arrow.
@jcolebrand Yes, my first world problems know no bounds. It turns out that it doesn't really have 4 useful inputs either. Just two that can be either DVI or displayport ;P
@swasheck it takes time to write such a thing, and I already have one app on my plate. And besides, I'm thinking of making it have two "modes". drop me into edit so you can only edit the question from those guys, because obviously that's what they need, or return me to the front page. Because that seems like it might be best for the FR.
@swasheck However, what it sounds like you want is just a blank panel that comes up over the post when you get to the page, that says something like "help vampire behind this shield"
@ConcernedOfTunbridgeWells Yeah, I've seen that sorta thing. Annoying as feck.
For anyone that missed this going around and wants a giggle: http://channel9.msdn.com/Forums/Coffeehouse/Visual-Studio-Achievements-theyre-not-Xbox-live-right
@swasheck bleh, you have to occasionally sync it up to a webservice to make it useful, to have everyone's input as a group. Then you need onscreen buttons to add them to the "DNR" list.
@AaronBertrand Mine has an XW9300 at one end and a laser printer at the other, plus a whole lot of other junk on it. Can't furnish a picture ATM though as it's about 200km away.
> As for myself, I'm working on a movie that I put on kickstarter and I pick up a lot of chicks at clubs showing my gamerscore on my phone. Right now, I'm getting more cred and respect from my cheevos, but later I will probably make a lot of money from it.
@jcolebrand no, not using synergy. I like things to be separate. When I'm on travel or want to take the laptop into the TV room or elsewhere, it's because I don't want to be doing desktop-y work.
I have full access from both laptops to the desktop drives (including externals) if I need it. One of the laptops is being phased out, it's just a matter of me being lazy about it.
@Zane bing.com somehow tricked me into the daily rotating wallpaper on my desktop at client work site. I left it, because it is nice to have something different each day.
@jcolebrand as an aside through that forum i just realized that i went to school with tina wood who is now " the Executive Producer of new programming for Xbox"
@Zane Not sure I understand what it is you want there. Some sample data with expected output and the query you already have would be helpful. Perhaps in a SQL Fiddle.
When it comes to dates, the best practice is to give the written alternative to the month - that way there is no chance that the day and month can get mixed up along the way. Try inputting the dates as string in the following format:
'dd MMM yyyy'
$query = "asistencia_virtual '01 Jan 2012', '31...
Good afternoon,
I'm looking for a good client tool to replace "Oracle SQL Developer" (the tool I currently use) which supports
Oracle DB 10g, 10gR2, 11g
Running SQL code
Debugging SQL code (with walk-through... click error, jumps to error line)
Do you know of one (preferably free)?
Thanks f...
I have a function that has one parameter of a table type, i want to loop through all the fields and return the column that has a null or empty value.
CREATE OR REPLACE FUNCTION toned.function_validate(varmember tbl_member)
RETURNS text AS
$BODY$
...
The definition of tbl_member below
CREATE...
I have the following case statement and the IsNull portion is not registering and I am curious if I have it setup correctly.
CASE WHEN IsNull(2010) THEN 0 END) * CASE WHEN IsNumeric([Dur_In_Hours]) =1 THEN CAST([Dur_In_Hours] AS FLOAT) ELSE 0 END) AS Cost
How do I aggregate like sets of data.
The example below shows how the raw data and desired output.
DECLARE @Data TABLE (PID INT, CID INT)
INSERT INTO @Data
VALUES (1, 1), (1, 2), (1, 3), (3, 1), (3, 2), (3, 3), (2, 1), (2, 2), (4, 3), (4, 4),
(5, 4), (5, 5), (8, 4), (8, 5), (6, 6), ...
![i.imgur.com/RE4jJNO.png?1[/IMG]](http://i.imgur.com/RE4jJNO.png?1[/IMG]){kind=link}