My locale settings were not properly configured when PostgreSQL was installed. Purging and reinstalling didn't help. I followed the instructions here and that did the trick for me.
Essential parts of the linked information reproduced below:
The problem showed itself in the following manner:
...
I want to query in a database like :
Let us consider a student table A with following attributes: (Id, Age, CGPA, Address, Gender). Our table
contains record for all the student in the world (so my table is Big with million of records). I want to search this table to find out the student of my ch...
@PaulWhite Hopefully the answerer will learn the right lesson ("I'll make sure my future answers will not depend on external references" rather than "I'll post link-only answers from now on, someone will surely make them salvageable").
@dezso You're suggesting it should be closed because the OP hasn't responded?
I don't think that's a good reason to close what is quite a reasonable question with two answers. Closing would prevent someone adding a better answer. It's not 100% clear cut though, so I'm willing to be persuaded otherwise. The age of the question shouldn't really affect the calculation too much:
Great question.
Here's my $0.05 (I'm giving you more than a tupence so deal with it).
If the question is old and good, then answer it if you can.
If the question is old and poor but can be edited to be good, then edit it and answer it.
If the question is old and off topic then vote for it to b...
@PaulWhite well, after carefully reading the question and the unanswered comments, it is not even clear it's about a simple query or CRUD - and the two answers address one of them each
The fast database query question on the other hand is way basic and localized. I wouldn't even migrate that one to SO. A comment about the existence of indexes might be helpful.
Another factor in play is that the question has three up votes and no down votes, so clearly even the VtC person didn't think it was worth a down vote :-D
Regardless of that, I think the question shouldn't be of the form "I want the same as that guy". (But I'd be fine with "I want A, B, C, same as that guy".)
And in this case the referencing question seems to depend on too many details from the referenced one.
Yes, we take full backups daily and only delete the full backups after 7 days according to the text of the job step but 4 is the actual value provided to the date calculation
@MarkStorey-Smith I guess it depends on how good of a restore system you have in place, but yes, the shorter the time between backups, generally the better.
1-minute backups might mean you have to restore 1439 log backups.
@MarkStorey-Smith it really depends on the RPO and RTO objectives. Hourly log backups (with a daily full) means you only ever have to restore at-most 23 log backups. If you don't have an automated restore strategy in place, that is far quicker than manually restoring 1400+ backups.
Could not locate statistics '_WA_Sys_00000008_09042A36' in the system catalogs. DBCC execution completed. If DBCC printed error messages, contact your system administrator
It was really messing with my head as well. I put a space between whatever not-y is and lowercase delta? and google translate turned it into abc dezith I couldn't figure out how a space two characters away would influence whether a letter was b or v
Yes. I had mixed feelings about it. On the one hand, the edit is ultimately pointless, and I wanted to draw his attention to that. On the other, if the OP sees the formatting edit, that might be helpful on its own. In the end, I decided the former was more useful. If the OP reposts as a question, any formatting issues will be highlighted more permanently there.
@MikeFal We covered business class travel from NZ, a nice hotel, expenses, and had ~EUR6000 left over to fun future community events. A win all around, as I say. And the weather was lovely.
The SQLSaturday in Lisbon this year was pretty cool btw. I'm not sure how many more people they drew in just because Paul White was speaking, but that was what got me (and probably Martin Smith) to come.
@JamesLupolt We did set a new record (just!) for a precon, but it's hard to know how much of that I was responsible for. Not much, I suspect. Maybe just you and Martin.
And that's not false modesty, it's my best guess.
Anyway, it was a beautiful, crazy thing to do once.
@PaulWhite Well it was also a very affordable way to get a Paul White braindump.
I thought Lisbon was quite nice too. I was really impressed with what they've built on the east side of the city, and I'd totally missed that the last time I visited.
I'm trying to create a stored procedure that creates a parent record and then multiple child records. I've kept the columns basic for this.
Table 1 has columns:
tbl1.EmployeeID
tbl1.contractID IDENTITY
tbl1.datecreated`
Table 2 has columns:
tbl2.assignmentID IDENTITY
tbl2.contractID
tbl2.ass...
Yeah I think default trace is fine. Especially since it doesn't use profiler, doesn't capture plans or other heavy things, ignores queries, etc. But a lot of the things people do when they create their own trace is the kind of thing that brings down a server, because they don't want to miss anything. And then they use Profiler. Over Wifi. On a crappy Internet connection. Through the office and a VPN tunnel to the data center.
@AndriyM yeah I deleted it, since it shows how to get the IDENTITY() value, which the OP says he already knows how to do.
CREATE PROCEDURE dbo.MyProc
(
@EmployeeID INT
)
AS
BEGIN
DECLARE @ContractID INT;
DECLARE @Table1Row TABLE
(
ContractID INT
);
BEGIN TRAN;
BEGIN TRY
INSERT INTO dbo.Table1 (EmployeeID, DateCreated)
OUTPUT INSERTED.ContractID INTO @Table1Row
VALUES (@EmployeeID, GETDATE());
SELECT @ContractID = t1.ContractID
FROM @Table1Row t1;
INSERT INTO dbo.Table2 (ContractID, EmployeeID)
VALUES (@ContractID, @EmployeeID);
COMMIT TRAN;
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0 ROLLBACK TRAN;
@AaronBertrand I don't understand why setup doesn't kick off the enablement of 3.5 automatically.
if it's a prerequisite, and you're running SQL Server setup, then it should just enable it if it isn't enabled. Or at least ask if I want to enable it, then just do it.
it'd be so nice to mod-hammer-close these types of questions/answers:
Hi, i've posted a question, which is marked [on hold] since it's opinion based. I fully agree, but wonder if there is some place for these questions on stackexchange? Since I would love some *opinions* from database-experts on the issue
As you don't know if there's any logic in the keys you can't tell if a huge or negative number will lead to a key violation.
Without knowledge of the application I'd suggest importing the previous pupils in the new software to get a regular id is the way to go.
@dietervdf I voted to close that since I don't see any reasonably succinct answer that is correct every time. You'll need to make a decision on how to handle your own requirements.
I understand the close vote, no problem there. I wonder though if this is a rare situation?
inserting all pupils in the online system and generating a new id, isn't a option, since the new system is charging for each pupil, seems like a waste of money to insert previous pupils :)
@dietervdf I don't think its that rare; its just difficult to provide a solution that applies every time in every situation.
you might want to look at the definition of the table in the online system. If the primary key is an identity, and it starts at 1, you are probably fine assigning negative numbers to your previous pupils. Note I said probably
My locale settings were not properly configured when PostgreSQL was installed. Purging and reinstalling didn't help. I followed the instructions here and that did the trick for me.
Essential parts of the linked information reproduced below:
The problem showed itself in the following manner:
...
Great question.
Here's my $0.05 (I'm giving you more than a tupence so deal with it).
If the question is old and good, then answer it if you can.
If the question is old and poor but can be edited to be good, then edit it and answer it.
If the question is old and off topic then vote for it to b...
I'm trying to create a stored procedure that creates a parent record and then multiple child records. I've kept the columns basic for this.
Table 1 has columns:
tbl1.EmployeeID
tbl1.contractID IDENTITY
tbl1.datecreated`
Table 2 has columns:
tbl2.assignmentID IDENTITY
tbl2.contractID
tbl2.ass...
Nevermind, outgoing port was blocked from my office. Had IT open it and it is working fine.
As you don't know if there's any logic in the keys you can't tell if a huge or negative number will lead to a key violation.
Without knowledge of the application I'd suggest importing the previous pupils in the new software to get a regular id is the way to go.
