Tag Info

Hot answers tagged

1

Your sql query is wrong: - Assume there is a student s1 who has passed one exam after '2000-01-01' and none before. Your query results in {s1} - {} = {s1}. This will be a false positive. - Assume there is a student s1 that passed three exams after '2000-01-01' and one exam before. Your query results in {s1} - {s1} = {}. This will be a false ...


1

At this time, only superusers can see others' activity details in pg_stat_activity. PostgreSQL could use a finer-grained rights model, where you can GRANT the MONITOR_QUERIES right to a user, for example. But right now it doesn't have one, and quite a few things are superuser-only. This is one of them.


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.


1

Forfiles doesn't work with UNC. The trick is to map the shared UNC using pushd. This maps and entered a temporarily drive. Popd will pushd \RemoteHostName\sharedFolderName forfiles /P "\RemoteHostName\sharedFolderName" /s /m *.bak /D -7 /C "cmd /c del @path" popd


1

As u told it possible to create another database(with different name) with in the server. try once in local db then you can go into production.


1

I found an utility that does exactly what I need : SQLYog (Database Synchronization Wizard)


1

"On what parameters can we monitor data warehouse?". Exactly the same ones that you use for monitoring an OLTP database. You might want to pay more attention to things like slow query log (MySQL) for a DW, but that should be on the radar for an OLTP system also. The common "gotchas" may change, but databases all sit on machines with disk, RAM, CPU and ...


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 ...



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