The Heap™ – Consultancy ©® - 2014-04-24 (page 1 of 2)

« first day (1206 days earlier) ← previous day next day → last day (3654 days later) »

12:21 AM

I mean a database or script where I can set up your object and get the same result as you when I run your query. Seeing it happen (and being able to trace/XE/debug the app) is going to help figure out what's going wrong, vs. just having the end result with a plan missing and no way to trace back to the cause.

It's not that I don't believe it's happening; but I can't take a .queryanalysis file back to engineering and tell them to figure out where it went wrong. They're going to kick it right back to me and tell me to reproduce the problem; sadly, I've tried, and failed.

Also I forget if I asked you this before but what if you keep the DBCC stuff in a different batch? Does it really need to be executed all together? I'm not saying that's an answer, but I am curious if it's a workaround.

@AaronBertrand totally fine. i was just wondering what it'd look like in this case. what's a stats-only copy?

@AaronBertrand only takes the first batch

12:51 AM

Well that's what I mean - if your big honking query is the only one in the batch...

mssqltips.com/sqlservertip/1999/…

@AaronBertrand yes. you had me try it different ways.

@AaronBertrand neat!

It's tedious but extremely useful. And lets you share a repro with, say, us, without sharing actual data. You have to trust the vendor (or whoever) with your schema, of course, and it gets really tough if you have login, cross-database, linked server dependencies etc.

And if anyone is ever nervous about sharing their schema with us, I pledge a year's salary that we will never, ever, ever use it for anything other than reproducing an issue.

Remind me what happened when the big query was the only thing in the batch? Sorry, my brain has been mush since my pre-con. Paul can validate that I think.

1:10 AM

Confirmed. Aaron's brain was indeed mush at that point in time.

And bear in mind you don't need to script the whole database, just the tables (and indexes and statistics) needed by the query.

@PaulWhite are you an independent contractor?

@Kermit Sometimes. Always independent. I think I'm mostly a writer these days.

@PaulWhite i'm just curious how you make your income

... whether independent consulting is lucrative

@Kermit I'll never be rich because I made the choice not to be a long time ago. I suppose I could make a lot of money if I prioritized that. When I do work, rates are in the hundreds of US dollars per hour, depending on the circumstances.

2

user image

@PaulWhite what was behind to not be rich?

1:21 AM

@Kermit I prioritize free time spent with family and friends over work and Ferraris.

@PaulWhite but Ferraris

no, but seriously. that's great

Yeah I know. I make bad choices like anyone else :)

1:33 AM

user image

flappy2048.com

2:29 AM

Tequila and grapefruit juice.

=

I love y'all

Also ... I'm convinced that statistics are the dark arts of sql server.

No, collation is.

Fair enough. I'm vet confused about how the optimizer would use a filtered stat especially if it's using an index that has it's in stats object.

Very not vet

@kermit I wish I could just pay @paulwhite to mentor me

Buy me a Ferrari and we'll talk.

Seriously, you can send an email any time.

@PaulWhite If you ever happen to be around Dunedin I know people that know people, I might be able to get you a ride in one ;)

I can't even afford a mazda

@paulwhite so the stats thing is very perplexing tomme

2:40 AM

Typing with your nose today?

To me. Mobile chat + tequila = lulz

@SimonRigharts You clearly move in privileged circles. I would like to see a game at Forsyth Barr one day.

How does the optimizer choose which stat histo to use? I can invest a ton of effort into filtered stats, but how do I know it'll help?

@swasheck It generally will use the "better" stats if it can. The rules are a bit complicated.

"SQL Server: the rules are a bit complicated"

4

2:43 AM

Sad but true.

How does it define "better?"

@swasheck That's the "complicated bit". It generally prefers more recent stats, full scan over sampled, filtered over non-filtered ... things like that.

It's not documented, so things can change. I've not noticed big changes over time though.

But then I have better things to do most days than check for changes in that area.

Sure. That's understandable.

The main thing with filtered stats is to check the optimizer can use it for the query, i.e. it's not going to be reused with a different value that might not meet the filter condition.

Why would it do that?

2:47 AM

Auto-param for example

Ah. I see.

If you like it then you shoulda put a RECOMPILE on it.

3

Nice

I don't always recompile but when I do I do it in production on a 15bn row fact table

My dropcleanbuffers brings all the devs to the yard and they're like ...

I'm lucky to figure out how to index and @paulwhite is telling the optimizer how to use stats

:)

A few minutes on the heap and I feel like a moron. Yes. I know. It's not a feeling.

@paulwhite Have you decided on pass vs MVP?

3:19 AM

Both are the same week in the same place

Yeah. I thought you said you were going to decide on one or the other.

Hoping to go to both.

3:38 AM

Ah. Then I'd love to buy you a few beers at summit. It's the least I can do

4:34 AM

Sounds good.

@PaulWhite Mike's around from next Monday until the following Friday. Should we show him how this rugby game works?

(by 'show' I mean explain it to him from a nice warm bar with a nice cold beer on hand)

Rugby's easy. Seek and destroy.

Oh yeah ... There are points involved.

@swasheck And a few rules. Not many, and definitely less than american football, but there are some

4:49 AM

:)

4 hours later…

8:55 AM

Yawn. Day off

Heard in the pub last night: "I think I'm an alcoholic. I'm drinking a bottle of red wine per week!". If he was drinking 3 bottles a day, then yes :P Some people have no idea

9:21 AM

@FreshPhilOfSO My grandpa would not sit at the table to eat without a small bottle of wine.

He lived to 92.

1 hour later…

10:49 AM

@FreshPhilOfSO My personal guideline is more than a bottle a day is problematic (nb: I don't drink wine - and I don't drink that much either)

Mark Storey-Smith

11:05 AM

@ypercube I like his style!

2 hours later…

12:43 PM

Of course you need dynamic SQL. You can't just say "select * from tname" because the interpreter expects that to be an actual table name, not a variable. You'll have to use the working example that you give in your question. Something like select * from $tname (if it actually worked) would look messy, be hard to read (how would you know what was being selected), would have security implications (sql injection etc) and would be a nightmare for the parser (lots of hard parses, big CPU overhead), and would also encourage people to use it lots - all of a sudden it's all gone a bit PHP. — FreshPhilOfSO 33 secs ago

I need to stop ranting incoherently

@FreshPhilOfSO that's your natural state

@Kermit it's easier than 2048

I got 65536 on my 5th try

@Lamak ha

@Kermit and I've only gotten to 4096 in 2048

it's okay

1:03 PM

@Kermit very true

@SimonRigharts I hope you are not referring to League

1:54 PM

Anyone have any good articles on why we shouldn't use the money datatype?

107

Q: Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?

I'm curious as to whether or not there is a real difference between the money datatype and something like decimal(19,4) (which is what money uses internally, I believe). I'm aware that money is specific to SQL Server. What I want to know is if there is a compelling reason to choose one over the...

sql-server types

sqlblog.com/blogs/aaron_bertrand/archive/2008/04/27/…

sqlblog.com/blogs/aaron_bertrand/archive/2009/10/12/…

databases.aspfaq.com/database/…

See I knew I came to the right place. :)

We are getting weird rounding issues with reports, etc I think it is probably from the money datatype

@bluefeet either money or float/real

@AaronBertrand we use money in most tables then we wind up being off a few cents here or there in different reports based on how we are aggregating/processing data

1:58 PM

money is stupid

I know it is the wrong datatype to use, I just want some proof to back a suggestion to possibly change it

I just don't see the advantage of storing data using that type, except that it makes it obvious: "Hey dufus, the price column is of type money. That means the units are dollars."

Hopefully you get enough backing from those links (and you should be able to simulate a few of your reports by copying the data to tables with proper types, and demonstrate the inaccuracy without changing anything else).

@AaronBertrand good idea, I'll try to find some time for that

someone DV'ed and flagged one of my old link-only answers today instead of comment asking me to fix it.

the other mods sure enjoyed giving me a hard time for that answer

@bluefeet I don't think that there is much incentive into leaving comments. And meta is filled with the "downvotes are the right way to do it"

Yeah I've run in to too many Guffas to bother leaving comments much of the time

"If you don't tell me why you down-voted, how can it improve the answer?"

2:05 PM

@Lamak I typically comment before I do anything to the answer

you are a special mod

He clearly copies and pastes that response, because nobody could make that typo every single time.

I typically comment too

@Lamak I'm not jaded yet

@bluefeet but if anybody down-votes (before or after you), they'll assume it was you.

2:06 PM

@AaronBertrand yeah that's true especially now because the 10k flag queue is gone so there are more reviewers seeing stuff

I'm not perfect but I suspect a large majority of my down-votes are just revenge because people assumed I down-voted them (and probably, often, they are right)

@AaronBertrand that happens too often too. And I have to post a comment "not my downvote, but I guess that you are getting those because....."

@Lamak I say that even when it is my down-vote. :-)

@AaronBertrand haha, I do too

did you hear that?, that was my bubble exploding

2:07 PM

when I see link-only though, I normally DV and comment. Then I'll circle back to see if they change it

I remove my down-vote if they fix it. Unfortunately there is still no way to know they fix it, unless they @-comment or you bookmark the stupid thing

How do you keep track of what to circle back to?

@AaronBertrand I check out my comment history

@AaronBertrand what question are you two talking about

@Kermit someone flagged my answer here to be deleted -- stackoverflow.com/a/10402764/426671

The first version was link only. the SO mods gave me a hard time about it so I fixed it

@bluefeet what was the reason

ah

lol

yeah

2:10 PM

@Kermit they used Other > link only answer - then downvoted no comment

@bluefeet it was a legit reason

@bluefeet Out of curiosity, in what way did they give you a hard time?

I'd say flaming bag of poop on the porch

@AndriyM in the mod chat room - why I still had a link only answer out there

one of the other mods flagged it as well

@bluefeet "still"? As in "you've been a mod for (however many) months, and you still..."?

2:14 PM

@AndriyM yup - I'm sure I've got others

@bluefeet you didn't go threw all of your answers to make sure they weren't link only?!

@Kermit no, I've got 3.5k answers

@bluefeet chop chop!

jk

@AaronBertrand it definitely was bad before. But I fixed it and I would have if someone commented

@Kermit yeah in all my free time I'll get right on that

I'm sure I have some answers like that too, from back when it was ok

2:16 PM

I'm sure even Jon Skeet does.

@AaronBertrand But not on the site where you are a mod, surely.

@AndriyM I certainly hope not. But the site where I'm a mod, never accepted those in the first place. The site where bluefeet is a mod is a lot older.

@AndriyM I've gone through a lot of my stuff and cleaned up - removed bad crappy answers

@bluefeet I did that recently as well.

Removed anything that turned out to not be helpful.

@AaronBertrand Exactly. Most likely anyone more or less actively using the site for something like 4+ years will have answers of, er, questionable quality. I understand how a mod might need to lead by example, but some things need time too.

2:22 PM

@Zane a lot of people do

@Zane how do you know? I like to think most of my answers could or did help someone, even if they don't get up-voted or accepted (the people that find it useful may not be able to up-vote, for example, and aren't always the OP). And you never know who it might help tomorrow.

i mostly just pepper the sites with stupid questions.

Who let aptem in here?

2

@AaronBertrand where do you see this

> i mostly just pepper the sites with stupid questions.

2:25 PM

@Kermit he was mocking me ... calling me aptem based on my stupid questions comment

:-)

@AaronBertrand Just looking at it with fresh eyes I could see I was on the wrong track as to what the OP was on about.

Got it!

@Zane the funny thing about these sites, though - if you misinterpreted the question, someone searching for the question you answered (rather than the question actually asked) might come across it for the same reason. But I do agree that if you were just plain wrong, toss it.

@AaronBertrand I'm still embarrased about my highest voted answer

2:27 PM

What's wrong with that answer?

I think he's probably just annoyed it's his highest voted. It always seems to be the easy ones that get more Upvotes.

i think that i have the record for the highest rep:contribution ratio (meaning my rep has far outstripped my actual contribution)

Sure, I mean this is stupid

388

A: Update a table using JOIN in SQL Server?

You don't quite have SQL Server's proprietary UPDATE FROM syntax down. Also not sure why you needed to join on the CommonField and also filter on it afterward. Try this: UPDATE t1 SET t1.CalculatedColumn = t2.[Calculated Column] FROM dbo.Table1 AS t1 INNER JOIN dbo.Table2 AS t2 ON t1.Co...

31

A: How to edit data in result grid in SQL Server Management Studio

You can do something similar to what you want. Right click on a table and select "edit top 200 rows" (if you are on SQL Server 2008) or "open table" in SQL Server 2005. Once you get there, there is a button on the top that says "SQL"; when you click on it, it lets you write an SQL statement and y...

And then this, only +52:

52

A: Comparing DateTime structs to find free slots

So imagine some tables: USE tempdb; GO CREATE TABLE dbo.Users ( UserID INT IDENTITY(1,1), Username VARCHAR(32) ); CREATE TABLE dbo.Groups ( GroupID INT IDENTITY(1,1), GroupName VARCHAR(32) ); CREATE TABLE dbo.Membership ( UserID INT, GroupID INT ); CREATE T...

2:32 PM

@AaronBertrand I've got one of those

140

A: How to Delete using INNER JOIN with SQL Server?

You need to specify what table you are deleting from, here is a version with an alias: DELETE w FROM WorkRecord2 w INNER JOIN Employee e ON EmployeeRun=EmployeeNo Where Company = '1' AND Date = '2013-05-06'

It's probably partly because the simple problems get the most views, because many people hit those problems. Anything more complex, unique or specialized, like my free slots thing, are unlikely to be seen by a lot of people because they aren't trying to solve that problem, and is also unlikely to be discovered by even by those searching, because what are your search terms?

@AaronBertrand My assumption is that answer suffers from TLDR as well.

@AaronBertrand Not surprising, as it's clearly a TL;DR in comparison.

Er, sorry @Zane, didn't mean to copy your comment.

@AndriyM right but anything that doesn't require a solution that isn't TL;DR for anyone probably shouldn't belong (RTFM)

Even this one - not overly long, but far more useful than correcting update syntax, and only +9?

9

A: How to get the stored procedure name from a trigger when an update operation was performed?

This won't always be 100% reliable, and it sometimes will capture the outer procedure call even if that procedure called an inner one. But you can at least get some idea of what the user called that ended them up in the trigger. ALTER TRIGGER dbo.whatever ON dbo.something FOR UPDATE AS BEGIN ...

Ugh

RTFM people

0

Q: Return Auto Increment value after inserting a record on a table

Here is the query that I have. In my Table User, the schemas is CREATE TABLE [dbo].[User]( [UserId] [int] IDENTITY(1,1) NOT NULL, [UserFirstName] [nchar](33) NOT NULL, [UserSurname] [nchar](33) NOT NULL, [UserDob] [date] NULL, CONSTRAINT [PK_User] PRIMARY...

uh, never realised how many zero score answers I have

(did I wrote "realised" correctly?, or is it "realized"?)

2:42 PM

We'll accept the former but prefer the latter

or the latter

I had crushed the unsung hero badge for the longest time

I have 15 pages or so of 0-score answers. They start on page 98 (of 113)

stackoverflow.com/users/61305/…

@billinkc So, does that mean that both are correct-ish?...but I should use "realized" in the future?

Hey @billinkc when are you flying into Chicago?

2:44 PM

Z is 'merican spelling, S is the british

@Lamak "realised" is British spelling. We're never going to misinterpret what you meant.

@AaronBertrand I still don't have 1000 answers...thought I had lots more than that

@Zane Arrive 2:30ish Friday

@billinkc @AaronBertrand thanks. So it's a "color"-"colour" thing

right

2:45 PM

<--9:20 AM

3:02 PM

So....I shouldn't expect Spanish SO beta anytime soon

14

A: Beta launching time

The issue in these three cases is different from almost every other proposal. Most sites will get launched a week or two after 100% commitment. There are a few things we need to do to prep a new site, such a establish the URL, pick the favicon, and so on. But proposals for SO in other language...

Flagged this

0

A: Return Auto Increment value after inserting a record on a table

Use SCOPE_IDENTITY() function.

If I understand the "remove the hyperlink and there still is some info in the answer" thing to flag as NAA, then I'd say that this isn't NAA

just a bad answer

now, in my opinion, it should still be deleted

I didn't flag it as not an answer

oh, then don't pay me any attention

@AaronBertrand what'd you flag it as?

3:06 PM

@AaronBertrand that actually is considered a valid answer because removing the link still gives them the info

But it doesn't give them any info they didn't already have, doesn't tell them how to use it, etc. It should be a comment.

Anyway, they deleted it themselves, so mission accomplished anyway

@swasheck other -> and then a two-sentence rant

i'll still call it a win for the heap

@AaronBertrand i just said something like "needs mod attention->'this would be better suited as a comment and the answerer has the requisite rep to make it a comment.'"

@bluefeet meh. it added nothing to the answer that already existed and was redundant, but i understand the line you are illustrating

In some cases I would agree. But SCOPE_IDENTITY() had been in a comment for 15 minutes before he even posted that answer. If the OP can't search for the doc on SCOPE_IDENTITY() themselves, close the question.

i think what we have here is the fact that the curse of the medium is such that the community appeals to the letter of the law and not the spirit. the mods are, unfortunately, handcuffed because of what's "written." people care more about internet points than useful knowledge transfer and will appeal to the written policy when they start to lose their internet points.

vote to close please

0

Q: Cursor declaration. SELECT and INTO number of variables/rows

I have stored procedure: USE [NRD] GO /****** Object: StoredProcedure [nrd].[generatePrintXSLT] Script Date: 24.04.2014 18:28:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <akovalchuk> -- Create date: <24.04.2014>...

sql sql-server cursor

3:17 PM

I think a community 5-vote (10k+ rep) convert to comment option would be good

@FreshPhilOfSO please no. I foresee that increasing flagging for mods ten-fold because people would want mods to undo that decision

@FreshPhilOfSO i nominate you to put that to meta. that'd be awesome flamebait

@bluefeet THE COMMUNITY HAS SPOKEN.

there was a recent request for that -- meta.stackexchange.com/questions/228175/…

@PaulWhite did you not think that me and my greyhounds couldnt handle this last night? sqlblog.com/blogs/paul_white/archive/2011/09/21/…

@PaulWhite @AaronBertrand turns out it was about 4 estimates that were different between the estimated plan in SSMS and in Plan Explorer. it was still and odd sight at first. for example: SSMS said 1-row key lookup, PE said 29-row (from the same xml)

@Lamak You can suggest yourself as a community manager

3:24 PM

@ypercube community managers are SE employees. I could suggest myself as a mod if needed, but alas, I don't think that spanish SO is very important for SE

@Lamak Wasn't one of the 3 languages that they plan to add - after Portuguese?

aaaaand a Q with only bad answers

0

Q: Conditionally using a SQL Temp Table throws errors

I have a (not normalized) legacy SQL database and am working on a task to gather code from one of several similar tables. I want to execute a lot of identical code against the #Temp table, but the tables it draws from are very dissimilar (with some columns being the same). My code is: IF @Vari...

sql sql-server sql-server-2012

@ypercube yup, the got 100% commitment in Area 51, but the answer I linked to says: "So, for the moment, these three proposals will remain in limbo"

@Lamak why not create your own answer :)

@swasheck I refuse until I understand how the rest of the code he's using is the same if the columns are not. He answered my comment by saying that he's only using 10 common columns, but still waiting confirmation about it

:)

3:29 PM

@swasheck Lack of interest is the reason I'm not answering it.

Cooke out 7 games

Weekes said it should have been 10-12

I kind of agree. Cooke's a douchebag

Length of the Injury.

Yeah they'll never do that though, because Bettman's a tool

He's just grumpy because he looks like the penguin.

3:42 PM

@AaronBertrand I read that as "Batman's a tool" and was confused

user image

lol

I don't think I've ever witnessed @AaronBertrand "lol"

2

He has to be the only President in history who's ever had three labor stoppages over the course of his career. That's usually a pretty dead giveaway that the ship isn't being commanded right.

why does some people don't want to use table aliases?

0

Q: How to construct query to get a single row output in MS SQL SERVER 2012

I am purely newbie on MS SQL programming but I need help on this problem which is I want to get the subscription types from the other table as well as making them a column name if they meet the certain criteria. This query is working but it will duplicate the result set and that's not what I want...

sql-server join sql-server-2012

3:54 PM

Probably using a QBE tool like Access

@Lamak mother

Formatting man formatting. — Kermit 4 secs ago

4:10 PM

@Zane he's not bad for being an NBA guy

@Kermit His response.

This the output looks like <br/> *divisionsname Benchmark Goalgetter Tax Credits <br/> * aaa Yes No Yes <br/> * bbb No Yes Yes <br/> But the code give me something like this <br/> * divisionsname Benchmark Goalgetter Tax Credits <br/> * aaa Yes No No <br/> * aaa No No Yes <br/> * bbb No Yes No <br/> * bbb No No Yes <br/> — user3569493 2 mins ago

@billinkc do you have redgate or did you take the time to format that turd?

Yes and no. I have sqlformat but someone else formatted it, just needed a linebreak in there to make the formatter thing pick up on it

My queries have leading commas and my joins are not in that layout

4:30 PM

@Zane i just use dpriver.com/pp/sqlformat.htm

I like this one better extras.sqlservercentral.com/prettifier/prettifier.aspx

@AaronBertrand looks like it's only for tsql though

Looking through indexes in a client database. Came across a table with unique NC that has (col1, col2) for the columns, and col1 is also the clustered index. I understand that the clustered index column is included in all non-clustered indexes. So would it be the same in this instance to just make the clustered index (col1, col2)?

@Kermit that works fine for me :-)

@AaronBertrand using vertica and mysql makes the dpdriver.com better for me

@ShawnMelton i would think so

4:33 PM

@ShawnMelton Before the smart answers come in, the advantage of your NCI is that it's only going to have the data needed. Whereas the CI is going to have all the data on the page so you could find the data faster with it on NCI via fewer page reads

@ShawnMelton it depends!

Also, changing the CI to include the second column might introduce fragmentation as it might start inserting rows in the middle

@ShawnMelton what is the index being used for? Are some queries only returning c1,c2? Is c1 not unique on its own?

@AaronBertrand CI is primary key on the table, so it is unique.

@ShawnMelton ok, you only said it was the clustered index. Those are not the same. :-)

4:36 PM

@AaronBertrand sorry

@ShawnMelton Then you can't change the PK from (c1) to (c1,c2)

@ypercube forgot about that one...

He could. That combination is also guaranteed to be unique. I just don't think we could possibly get enough information about all the queries and other side effects to know if that's a good idea or not...

@AaronBertrand he could but that would allow 2 rows with same c1 in the table.

@AaronBertrand I don't know the data or workload against the table at the moment and would not want to change anything right now, this was just a question of curiosity

4:38 PM

It's quite possible that the NCI is there for a reason, and it's quite possible that it would benefit some queries better than a clustered index on those two columns might (since the CI would also contain all the other columns).

@ypercube Again, we don't know enough - is it the PK because it's an IDENTITY column?

I've been trying to figure this index thing out more lately. Went through Pluralsight course on indexes that Dave Pinal did but it was just basics.

That's not truly there to prevent duplicates, and you'd have to go out of your way to try to violate that anyway.

@ShawnMelton use-the-index-luke.com

Website looks like shit but there's good info there.

@ShawnMelton brentozar.com/sql-server-training-videos/…

holy nuts

SELECT @@VERSION; in a query window will tell you the edition, so you don't have to guess. As for the maintenance plans, how should I know which ones are required? Every shop is different and sets up different maintenance plans for different reasons (or uses better implementations). If you don't know what they do, can't figure out what they do, and don't know if they're needed, is there anyone you can ask that does? — Aaron Bertrand ♦ 24 secs ago

Eeegads those people put a ton of stickers on their laptops.

4:42 PM

@Zane been using their BlitzIndex a bit as well, that and the code I got from the Pluralsight course brings a lot of info to the table to help but just trying to get an understanding of it all now.

lol what?

Wow. Harsh downvote! — Tom Mac 3 mins ago

Spent way too much time with the misses the last few weeks. So need a few days of Phil time

backticks suck. Makes those scripts so hard to read.

@Zane back of my iPad:

user image

Yikes!

Ouch!

4:46 PM

I suspect that is 7 or 8 layers deep

I'm not much for decorations.

Everything I own is super minimalist.

@AaronBertrand well at least it's protected from nuclear weapons

@AaronBertrand Vuarnet???? i remember that being cool in high school

@swasheck me too!

@PaulWhite i've noticed that you use the QUERYTRACEON hint more than DBCC TRACEON. is this a preference that you have developed in order to test a query with the trace enabled and not enabled without fiddling with your session settings?

5:07 PM

0

Q: How to create and start a PDB for RCU in Oracle 12c

So I've made a fresh install on a virtual machine based on OEL 6.5 x64. All my installs are in /opt/apps I installed a Oracle Database 12c, with the Desktop Version selected (not server), UNICODE encoding, Enterprise Edition. If I get it right, from this point I only have a CDB named orcl that i...

What's the score with self-answer posts on here? He just came here to do that, for no apparent reason

I could spend all day on this site if i did that

@FreshPhilOfSO well, you can look at the most upvoted answer in DBA.SE:

188

Q: What's the difference between a temp table and table variable in SQL Server?

This seems to be an area with quite a few myths and conflicting views. So what is the difference between a table variable and a local temporary table in SQL Server?

sql-server sql t-sql temp-tables

@Lamak That is exceptional though

@FreshPhilOfSO yeah, I know.

connect.microsoft.com/VisualStudio/feedback/details/812643/…

@swasheck when I pick up my computer and drop it on the ground, sometimes it doesn't turn on

5:22 PM

@AaronBertrand that was my impression as well

... and devs think that they're the top of the totem pole

I want to up-vote the workaround

@Lamak i gave you an up-vote and deleted my comment

@AaronBertrand that's pretty funny

@Kermit It really was hard for me to write the query. I don't know why sqlfiddle was throwing errors to some of the syntax I used. I don't understand oracle

@Lamak the real question is what school is teaching oracle?

oh and this is complete garbage

-1

A: SELECT clause with two conditions

i think your query is : SELECT * FROM DEPTLOC WHERE DNAME IN('IT','RESEARCH') GROUP BY (CITY,DNAME);

5:31 PM

@Kermit the real question is how op didn't understand the question

@Lamak the ultimate answer is that op didn't try anything

@Kermit anyway. I think I'll keep answering crap questions so you are forced to leave comments ;-)

@Lamak works for me :)

5:44 PM

@Kermit I told you I would be doing it

@Lamak the question is much better than "give me the codez"

Ate too much need a nap.

@Kermit yeah, you are right

@Zane awoman

didn't notice that the profile was redesigned

user image

@Kermit meta hasn't exploded with complaints so I don't think it was

5:52 PM

@bluefeet the sections have been labeled to the right of the profile pic, and links add on the top right

Look at the heaps of Vertica blogs.

@Kermit I don't see what's different. I'm missing free hand circles

what was the point?

@Lamak, i think you just demonstrated my point ;-/ — Ryan Vincent 1 min ago

@kermit you made me laugh

@Lamak I think the point is that OP has a sh**ty table design. — Kermit 1 min ago

6:09 PM

@Lamak glad i could help

@Zane whatcha talkin bout

@Lamak he's a PHP guy. I don't have high expectations for a lucid discussion.

Man. The Heap™ attacks

@AaronBertrand yeah, I don't know. I mean, I realize that I can be more terse than I want, but did I come across as someone that can't have a discussion?

user image

2

Perhaps they hate chileans

6:13 PM

@Lamak not at all. That's a perception thing on his side; his problem, not yours

@Ryan /unsubscribe. You accuse Lamak of not wanting to have a positive discussion, with absolutely no observable grounds on which to base that accusation. I am asking you what your goal is and explaining why "only positive alternatives" is not realistic for a site like this. And then that is your response. Sounds pretty hypocritical to me. Goodbye. — Aaron Bertrand 50 secs ago

@AaronBertrand thanks

@Kermit I think that is how all profiles have been except for SO

@bluefeet that would make sense

6:35 PM

@billinkc everyone does

"VIVA CHILE MIERDA" A literal translation doesn't seem accurate for this phrase

@billinkc yeah. It's like a literal translation of "GO 'MURICA DAMMIT"

6:59 PM

@Kermit See?, I didn't answer this question

-1

Q: convert period into name i.e. a1 a2 a3

I have a temporary table that I want to use the alias. It looks like this, now I want to name each row as A1-A13 according to the ranking... How do I do this? thanks SELECT * FROM #F Result: Ranking | Period | Fiscal Order --------+---------+--------------- 1 | 2013-04 | 136 ...

@Lamak good work

thanks, I'll take a golden star

« first day (1206 days earlier) ← previous day next day → last day (3654 days later) »

Transcript for

Apr '1424

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile