👻 Ghost Records 👻

1:39 PM

@PaulWhite - is there any way to have questions that are deleted from main automatically show up in the Dropped Question Archive?

Would we even want that?

I know I would like a place to see deleted questions easily... the Trusted User tools is, shall we say, painful.

Paul White

1:53 PM

@MaxVernon I don't think so. Deletions don't show up for non-mods in any of the tools/APIs I can think of. Even very privileged users can only search for their own deleted posts. They're not in the SEDE dump either.

Probably not what you want anyway, no.

Questions get deleted all the time for all sorts of reasons not associated with the work of this room.

And if a candidate question expires in here through lack of agreement or interest, well not much has been lost has it?

Max Vernon

@PaulWhite good point.

@PaulWhite agreed

hot2use

@MaxVernon Thanks for the feedback.

Max Vernon

my pleasure

hot2use

In that case I'll remove myself from the delete process for the time-being and earn my 10k rep and come back later.

Good Hunting! :-)

Max Vernon

you don't need to do that... you can assist simply by pasting questions in here that are no good

hot2use

1:58 PM

If I come across any, then I certainly will.

Thanks.

Max Vernon

@hot2use - have you seen this? dba.meta.stackexchange.com/questions/3109/…

hot2use

Yes, Read it and voted it up and your meta post too (both: read & upvote).

Max Vernon

cool

hot2use

I rate myself as being a DBA.SE regular which means I track both META and DBA.SE.

this question: dba.stackexchange.com/q/124401/15356

Q: 0 / A: 0 / Value: None. Answer only slightly touches on original question and OP is probably up-to-date on SQL Server.

Max Vernon

@hot2use for me, I think that question could be edited to improve grammar, and the answer could fairly easily be provided that shows how to delete orphaned users along with their schemas. Think of poor quality questions as a target for improvement first, then if there is no room for improvement, consider delete.

Paul White

2:23 PM

You'd think that would be a duplicate

Max Vernon

@hot2use - I don't mean to be pesky, but have you seen this meta post on titles? Myself, I regularly forget to edit titles.

@PaulWhite it is quite surprising that there doesn't seem to be a good candidate (admittedly, it was a slight cursory search) - probably the requirement to remove schemas based on orphans makes it somewhat more unique.

Paul White

yeah I came to the same conclusion

perhaps someone needs to write a good, modern answer

Max Vernon

agreed

Paul White

ah maybe a dupe of dba.stackexchange.com/q/34976

hot2use

2:44 PM

@MaxVernon I edited the title, but didn't remove "How to..."

mea culpa

Max Vernon

@PaulWhite yah, that's a good target

@hot2use are you working an answer to that question -> I'm about to hammer it closed as a dupe and don't want to interrupt you.

Paul White

already done based on you saying "that's a good target"

Max Vernon

sweet

hot2use

I was going to, but hang on a sec.

Max Vernon

that raises the question of what to do with this entire conversation ;-)

Paul White

2:53 PM

do we need to do anything with the convo?

hot2use

OP seems to have some (oracle) notion of schemas and users and there is a slight difference in SQL Server 2008 R2 in the handling of schemas, which was later removed in newer versions. Just removing the orphaned user, might not remove the schema if I recall correctly. In Oracle that automatically happens. If you issue a DROP USER xyz CASCADE; then user and all related objects (SCHEMA) get deleted.

Anyhow if the question is gone, then so be it.

Paul White

it's not gone, just marked as a dupe

Max Vernon

@hot2use that might make a worthy addition to the target question if you can flush it out a bit with an example. I know schemas are a real source of confusion for a lot of people, especially those coming from Oracle.

Paul White

there is an answer on the dupe target that addresses the schema issue to some extent

Max Vernon

yah, I saw that. I was considering adding a column to the output for DROP SCHEMA, but it looks like @hot2use is "on it".

I'm also considering updating Mark's answer to get away from syslogins and sysusers but I'm guessing there are a lot of answers with deprecated stuff.

Paul White

3:03 PM

@MaxVernon you'd have to be careful to do that without breaking the attribution

Max Vernon

@PaulWhite true. I wonder if Brent wants to update his site ;-)

Paul White

@MaxVernon the post is no longer there, the link is to the wayback machine

Max Vernon

oh

Paul White

see the revision history

Max Vernon

geez how did you figure out it was from Brent?

you're a never-ending source of wonder, Paul

Paul White

3:09 PM

there was an old comment pointing to Brent's site

Max Vernon

oh :-)

damn ephemeral comments

Paul White

I referenced the comment in my revision note

Max Vernon

d'oh. I'm just dumb.

Paul White

it's easy to miss

hot2use

After reading the DROP SCHEMA... code I agree that it could be closed as dupe. If OP of "closed as dupe" question would like to add more details and/or reopen his question, then I'm ok with the current state.

Paul White

3:13 PM

yep seems like a satisfactory ending

Max Vernon

if no one has any objections, perhaps it would be useful to clean up this conversation thread (move the trash)?

we should try to keep this room fairly clean, so we can see questions that need to be deleted more easily.

chatting in The Heap™ would be great

thoughts?

Paul White

I don't know. Seems useful to keep the discussion in context. The delete candidates are fairly obvious by being one-boxed.

Max Vernon

yah, I was of two minds about it myself. Of course, the one-boxed question itself no longer belongs here because it's been taken care of.

one-boxed questions, in my mind, should only exist here if they are still targets for possible deletion.

Paul White

I can fix that for you if you like

Max Vernon

sure.

(waits with bated breath to see what will happen)

Paul White

3:17 PM

just removed the one-boxing by editing the message

not a perfect solution but it will do I think

Max Vernon

works for me!

Paul White

you could argue the whole discussion belongs in the archive room (even though it was not actually deleted)

I'm fine with that, if you want to handle it that way

Max Vernon

sure. I thought you wanted to keep the archive room free of "chattiness"

but if that works for you, I'm behind it!

Paul White

3:20 PM

I don't have a strong view either way. A lot of this is trial-and-error to see what works best in practice.

Max Vernon

great point

with the archive being a gallery, can any room owner here move messages into the archive?

Paul White

try it and see

Max Vernon

I knew you were going to say that!

hot2use

No objections to cleaning up chat

Max Vernon

@PaulWhite - I don't even see the archive room on the list of target rooms that I can relocate messages to. I suppose I need to request access?

Paul White

3:27 PM

well that's a pain

Max Vernon

yah

Paul White

try it now

Max Vernon

← 65 messages moved from DROP QUESTION queue;

← 6 messages moved from DROP QUESTION queue;

Max Vernon

3:54 PM

Thanks, @PaulWhite much approved!

Andriy M

4:06 PM

@MaxVernon Thank you for the invitation

Max Vernon

4:27 PM

@AndriyM my pleasure!

Paul White

5:01 PM

room topic changed to 👻 Ghost Records 👻: Archive for questions that have been dropped from the site via the DROPPED QUESTION queue chat room. (no tags)

Tom V

6:42 PM

I still vote for ghost records

Max Vernon

@TomV that's now in use in the archive room.

Tom V

Ha lol I missed that

I blame mobile

Max Vernon

yah, I love the emojis

Tom V

Any reason the 2 questions I posted in here are still live?

If you guys disagree on them I'd love to know why I was wrong

Max Vernon

my votes are in place, just needs one more vote for each question before they "join the choir invisible."

Tom V

6:49 PM

I would vote for this one dba.stackexchange.com/questions/222005/…

Max Vernon

@TomV do it!

I mean, if you want to. I have.

Tom V

I'm not sure why I can't since it has 3 down votes and is closed

Max Vernon

@TomV curious. There is no "delete" link?

Tom V

No

Max Vernon

@TomV and that's gone

Tom V

6:51 PM

Maybe it hasn't been closed for long enough

Max Vernon

s'weird - I see a delete link.

Tom V

You are 20+

Andriy M

@TomV Because I didn't vote, and I have now.

Max Vernon

← 1 message moved from DROP QUESTION queue;

@TomV maybe that's why

Andriy M

← 1 message moved from DROP QUESTION queue;

Max Vernon

6:53 PM

NICE!

Andriy M

Easy-peasy

Tom V

@AndriyM thanks

@PaulWhite when most of the crap is dealt with 8 votes per day should be more than sufficient

Max Vernon

@TomV and as you get more rep, that number goes up, which is nice.

I can cast 30 delete votes per day which seems like a lot to me. :-)

Tom V

#boss

Max Vernon

lol

Tom V

7:09 PM

← 1 message moved from DROP QUESTION queue;

Self deleted by the op

Max Vernon

@TomV RESULT!

Tom V

7:22 PM

At least he didn't disassociate his account after reading the comments

Max Vernon

agreed

← 11 messages moved from DROP QUESTION queue;

← 53 messages moved from DROP QUESTION queue;

Tom V

← 5 messages moved from DROP QUESTION queue;

Max Vernon

← 16 messages moved from DROP QUESTION queue;

Tom V

Yes I was thinking the same

Maybe we should move the chatty messages to regular trash instead of the audit trail room though

Just a thought

As to not clutter the trace with (for lack of a better word) irrelevant things we just want out of the way

Max Vernon

7:38 PM

I initially thought it would be great to have just deleted questions in there, but then it's always good to have context about what happened as well. Moving the chatty messages to the Trash room might take away some of that context, or at least make it harder to piece together.

Max Vernon

7:49 PM

5

Q: Which SQL datatypes exist since when and in which RDBMS?

I found a general comparision of different SQL implementations that only covers some data types (BOOLEAN and TIMESTAMP) and a comparision of datat type support in different RDBMS from 2009 that does not list which data types are standard since when. Do you know of any comparision that lists SQL d...

1

Q: unable to run multiple create index scripts in pgadmin query tool

I have created CREATE INDEX scripts using the indexdef column of pg_indexes in one database and tried to run the script on another database. When each line of the script is executed separately it runs successfully, however if I try to run all together I get an error that index already exists. ...

postgresql query pgadmin

1

Q: PL/SQL problem statement for homework study

Good afternoon, I have a PL/SQL (&etc) exam in a few weeks, so I thought it would be good to do a couple of PL/SQL projects/assignments in preparation. Can you give me a good resource of homework problems? Thanks, Alec Taylor

plsql

-1

Q: Hello, I want to build up Postgresql 9.0 replication on Ubuntu 11.04

I want to build up replication on postgresql 9.0 that too on Ubuntu 11.04. Please let me know through which method it is possible? I have tried many options including slony, streaming replication & repmgr. However none of them worked. So please let me know the method through which replication can...

postgresql replication

0

Q: time interval period in sql

How to display the time period of the most widely in use in ms sql server I have purchase data, such as: hours the number of purchases 10:00 2 12:00 4 13:00 5 14:00 1 I want to show the period of time with most buyers. So the results would be with the most purcha...

sql-server t-sql

Tom V

← 3 messages moved from DROP QUESTION queue;

Max Vernon

well that seems to be working!

Andriy M

← 1 message moved from DROP QUESTION queue;

Max Vernon

0

Q: Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2?

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2 ? updated to answer the 3 questions: mysql> show variables like 'version%'; +-------------------------+------------------+ | Variable_name | Value | +-------------------...

mysql innodb ubuntu

Tom V

@MaxVernon That was my last vote for today

Max Vernon

8:02 PM

@TomV cheers!

2

Q: Permon counters on SQL 2005 mirroring (user defined counter log file is empty)

I've been attempting to gather performance counters for mirroring using perfmon, over a period of time and saving this to a log file. I am able to do this without problem for general SQL Server counters (Using this tutorial by Brent Ozar: http://www.brentozar.com/archive/2006/12/dba-101-using-per...

sql-server performance mirroring

3

Q: Membase data shared between users

I have begun writing a website using Membase (php memcached library) and I've come up against a conceptual wall. This is my scenario: I have some data that is stored in a key-value pair which will be accessed and modified by more than one user. If one of these users wants to update the data th...

I hit the wrong link

Muppet

@TomV made me lol

← 1 message moved from DROP QUESTION queue;

← 3 messages moved from DROP QUESTION queue;

Max Vernon

1

Q: how to split the column with cross apply in sql server 2008

I have a table like this VM1 SPLA - WINSVRSTD #P19-9999 QTY 1 VM2 SPLA - WINS ST #P29-9 9 QTY 2 : SPLA - WINSVRENTAAA #P39- 9 9 99 QTY 3:SPLA - WINS ST #P29-9 9 QTY 2 : SPLA - WINSVRENTAAA #P39- 9 9 99 VM3 SPLA - WINSVRSTD #P39-9999 QTY 4 VM4 SPLA - WINSVRSTD #P59-9999 QTY 2 : SPLA - WINS...

sql-server sql-server-2005 cross-apply

^^^ way too localized in my opinion

2

Q: Copy database wizard between servers results in Access Denied error.

I'm trying to copy a database from SQL Server 2008 R2 to another server, using the Copy Database Wizard in SQL Server Management Studio. I get an error telling me to check the error log on the destination server. The log says: Event Name: OnError Message: Access to the path '\\server\folder\db...

sql-server sql-server-2008-r2 windows

2

Q: Give permission to SQL Server Express database to Visual Studio MVC project?

(I am very familiar with MySQL but not SQL Server). On my dev machine is installed: SQL Server Express 2008 (Windows Authentication) SQL Server Management Studio Visual Studio 2010 (with ASP .NET MVC 3) The database that was created using the studio now needs to be added to a MVC project. I...

sql-server-express

1

Q: why is MySQL 5.1 on ubuntu 10.10 not starting?

I just installed a MySQL 5.1 server on Ubuntu machine. after installation the server should automatically start but it does not start and gives me an error start: Job failed to start . Even when I manually tried to start it using service MySQL start, it gives me the same error. Help is always a...

mysql mysql-5 installation mysql-5.1

1

Q: mysql pre-start process (23901) terminated with status 1

I installed a new Mysql server version 5.1 on machine which was running on 5.0. Now when I try to start the mysql server using command service mysql start it gives me an error start: Job failed to start. I even checked if the my.cnf is present or not. It does exist and it is accessible. Even wh...

mysql mysql-5 installation mysql-5.1

3

Q: What do I need to do to avoid ORA-32696 errors?

I have a SELECT query using several WITH blocks. Sometimes it runs successfully. Very often it fails with the error "Lookup Error - Oracle Database Error: ORA-32696: HTI: No free slot". I Googled the error, but the only advice is to "Increase memory". There are several discussion boards where peo...

oracle oracle-10g

1

Q: Oracle faster overlap check

We've a table with two columns beginrange and endrange, which contain hex values. To this table no overlapping ranges should be inputted. We had implemented the check by having a composite functional index(to_number(beginrange ,'xxx..'),to_number(endrange,'xxx...') and used the same in the whe...

oracle

1

Q: PostGIS - Effects of polygons with large number of verticies

I have a large table that stores, among other attributes, a geometry type. I have a GIST index on this attribute. However, when I perform even the most basic queries [say, select count(*) from table where the_geom && st_geomfromtext('polygon(...)', 4326)], it doesn't use the index unless I force ...

postgresql spatial

COBOL!

1

Q: sql data to a csv-file via cobol

I 'm using the following code : string 'insert into ' delimited by size 'tgamGameTeams ' delimited by size '(Id,Name,RemainingBudget,TeamGamePoints,GameId) ' delimited by size 'values ' delimited by size '(:kolomid , :kolomName, :kolomBudget ' del...

csv

1

Q: Moving database to another SQL Server instance

I have an old database running on compatibility level 6.5 on a SQL Server 2005 instance. The support for compatibility level 6.5 has been deprecated as of 2005 and removed on 2008. The place where I work is split in various different companies, each responsible for different things like Databas...

sql-server migration compatibility-level

^^^ SQL Server 6.5 (!)

3

Q: Circular relationship

I'm trying to design a database model and I have a question. I need to represent this: An order could have zero or one QAP. An order could have one or more E-Report. An E-Report must have one QAP. To represent this, I have this model: If an orden doesn't have a QAP, user must select one to ...

database-design

^^^ crossposted to Stack Overflow with an answer there

4

Q: Conversion of GRIB and NetCDF to my database

I have downloaded "High Resolution Initial Conditions" climate forecast data for one day. The file had an .tar.gz extension so I extracted it in my local directory and I get the files listed here: I think the files without any extension are GRIB data, because the first word in them is "GRIB"...

csv

Paul White

11:33 PM

← 2 messages moved from DROP QUESTION queue;

Transcript for

♦ 👻 Ghost Records 👻