Top new questions this week:

Why is a "non-single-group group function" allowed in a subselect but not on it's own?

Why does the first query not fail with the same error as the second: with w as (select 1 product_id, 10 units from dual union all select 2, 5 from dual) select sum(units) from (select product_id, …

oracle oracle-11g-r2

asked by Jack Douglas 9 votes answered by Vincent Malgrat 2 votes

Why are constraint applied in database rather than code?

Why are constraint applied in Database? Will it not be more flexible to be in code? I'm reading a beginners book on implementing databases, So this is a beginner's question! Let's say I design a …

database-design

asked by loolooyyyy 8 votes answered by FrustratedWithFormsDesigner 15 votes

Individual queries run on 10ms, with UNION ALL they are taking 290ms+ (7.7M records MySQL DB). How to optimise?

I have a table that stores available appointments for teachers, allowing two kinds of insertions: Hourly based: with total freedom to add unlimited slots per day per teacher (as long as slots don't …

mysql sql

asked by AlfredBaudisch 7 votes answered by Robert Rozas 2 votes

Main Considerations When Moving From MS Access Programming to SQL Server

First post, be gentle... I am a 100% self taught MS Access programmer (main part of my job is programming), I am now building larger databases; still using MS Access as the UI but SQL Server to store …

sql-server-2005 ms-access

asked by Simon1979 6 votes answered by Gord Thompson 4 votes

How do I optimize large table so queries that target only recent data perform optimaly?

So I have this table that is ever growing. Most queries are targeting just recent data, say one month old. I suppose this is common problem but I have no idea how it can be solved. I am open to …

sql-server sql-server-2008 sql

asked by IvanP 5 votes answered by Remus Rusanu 5 votes

How is SQL Server host identity ensured?

When I connect to some e-commerce website with my browser I use HTTPS that uses a certificate that (more or less) guarantees that example.com is indeed example.com. Now I connect to a SQL Server …

sql-server security identity cryptography

asked by sharptooth 5 votes answered by Henry Lee 4 votes

Increasing the decimal precision abruptly increased the size of table

I have a table like: CREATE TABLE grid_rows( [grid_row_id] [int] NOT NULL, [grid_column_id] [smallint] NOT NULL, [decimal_val] [decimal](18, 6) NULL, [datetime_val] [datetime] NULL, …

sql-server sql-server-2008

asked by user2264748 4 votes answered by Remus Rusanu 3 votes

Greatest hits from previous weeks:

Restore SQL Server 2012 backup to a SQL Server 2008 database?

Is there a way to restore a SQL Server 2012 database backup to a SQL Server 2008? I tried to attach file, it does not work.

sql-server sql-server-2008

asked by urlreader 6 votes answered by Aaron Bertrand 11 votes

MySQL error: Access denied for user 'a'@'localhost' (using password: YES)

I use the root account created the account 'a'@'%'. But I can't use the it to connect to MySQL server when I specify the host parameter. I can successfully connect without the -h parameter. Please see …

mysql authentication

asked by Yousui 6 votes answered by RolandoMySQLDBA 5 votes

Can you answer these?

Enabling/disabling/changing Oracle auditing without a shutdown?

I have a large database that needs auditing on a very detailed level (every select, update, insert, and delete, along with the actual text of the statement) for about half the users. I know how to do …

oracle audit

asked by Lawtonfogle 2 votes

PGPool Frequent Queries

We recently setup a PostgreSQL Cluster with PGPool in front of it. This is our first go at such a thing. We setup our QA environment to use the new PGPool, and we cranked up the logging on the …

postgresql pgpool

asked by Bubba 1 vote

Database Timeout Error from VB Application

Recently we are receiving so many database timeout error from different servers we are using vb application -- which will use ODBC connection to connect database - here no problem when we run the …

sql-server sql database-administration query-timeout

asked by sairam 1 vote