Tag Info

Hot answers tagged

4

Would you be OK with having a single table that has these three immutable bookmarks, and then using a view that joins this table with the user's real bookmarks? immutable_bookmarks ------------------- id name URL (or whatever this is a bookmark to) user_bookmarks -------------- id name user_id URL And then define the view as: create ...


2

(My apologies for the SQL Server syntax - I don't have MySQL. Please treat as pseudo-code.) A scheme such as the following should work create table DefaultBookmark( TabNumber int not null ,URL nvarchar(2000) not null ) go create table Users( ID int identity not null primary key ,Name nvarchar(200) not null ) go ...


2

That's called a Major Whoopsie. Assuming you didn't use transactions around the delete you are stuck with scanning the log files and redoing all the INSERT and UPDATE queries. If you don't have a query log then it's manual entry time. If it's any consolation the Government of Alaska had a similar issue a while ago, further compounded by the backup tapes ...


1

If the user has: Physical hardware access; Root / "Administrator" access to the system; or PostgreSQL superuser rights; then they effectively have total control and can do whatever they feel like. It's a little trickier when starting with superuser access, but the PostgreSQL superuser is not isolated from the underlying OS user that PostgreSQL its self ...


1

You can do this with Soft-NUMA. Here's a Perfmon screen shot from a 4-CPU VM I set up to test using your settings, 2 soft NUMA nodes, 1 CPU to Node 0, 3 CPUs to Node 1. I'm running a CPU intensive query for 20 seconds on node 0, and then the same query on node 2. You can see the CPU activity swap over: I'm running the query via sqlcmd and connecting ...


1

Is there a way to make queries from a database to use only certain core on the host? One way is to use query hint OPTION (MAXDOP 1). The problem with above apporach is that you have to hint everything that you don’t want to be limited by the server-wide setting, or use 0 (i.e. unlimited) for the server-wide setting and hint everything that you do want ...


1

I particularly like this one which works from within your (firefox) browser. If you're not a firefox user, then here is a list of alternatives.



Only top voted, non community-wiki answers of a minimum length are eligible