I think you are making a fairly common mistake here by selecting NoSQL technologies in order to be "future-proof" without understandng the tradeoffs. If in doubt start with PostgreSQL and figure you can always set up a graph db or other NoSQL db on the side as you need it. Also you can do graph...
I tried the following query but it still accepts numbers outside the range of 1 - 9999
CREATE TABLE test(id INT PRIMARY KEY, CHECK (id BETWEEN 1 and 9999) );
What am I missing?
I have a web application that runs off PHP and a postgres backend (9.1).
Most of the heavy DB lifting work is done via postgres stored procedures.
One of the processes in the app is an import data routine. The stored procedure is quite intensive on import but whilst developing it can import my ...
We want to create remote incremental backups after a full backup. This will allow us to restore in the event of a failure and bring up another machine with as close to real time backups as possible with SQL Anywhere network servers.
We are doing a full backup as follows:
dbbackup -y -c "eng=Se...
I'm working on a project on postgresql 8.4 server side. I'm adding some functionality in order to store some query informations.
I need to call two functions (start_create_profile() and check()) inside of exec_simple_query in postgres.c
These functions are written by me in a file called test.c i...
I previously had Database Mail configured to send out e-mails and it was working without any issues. I now need to be able to send attachments and I am getting an error. This is what I've done:
SQL Server Agent is now being run from an domain administrator account
The job that executes the st...
I use the Delphi Programming language.
Some where I use the speed button.
If Operation System Dectop in Classic mode, then speed button normal clicked.
But not classic mode, then not clicked the speed button.
Also other mode`s monimize, maximize buttons not seen.
Which property reason that?
I've put an index on almost every aspect of it.
In the execution plan it's showing the "STARTDATE" index is a 9% / 7% cost depending on where it's at.
Any tips?
SELECT
A.ActivityID,
A.StartDate,
A.parentActivityId,
DATEADD(n, 1439, A.EndDate) As EndDate,
isNull((CASE isNull(A.SessionTy...
I have problem with this T-SQL code:
SELECT
DQ.Code as DQ_Code, II.OrdNumber AS Cislo, II.Id As ID,
convert(varchar(10), cast(II.DocDate$DATE as datetime), 104) as DatumPlneni,
convert(varchar(10), cast(II.DueDate$DATE as datetime), 104) as DatumSplatnosti,
F.Name as Firma, F.ID as FIRM...
Trying to match some records to users by user ID (an int). But it will be done dynamically and I need to be able to match all records at the same time (I pass a '%' char for a LIKE wildcard). I have done this before and came across this problem accidentally.
Declare
@uid varchar = 300
SEL...
Try this:
DECLARE @test AS <whatever you want>
SET @test = dbo.ReservationByClient (602)
SELECT @test
Yes, you should test the whole chain of events as a unit. So, in your example with a procedure that inserts into a table and causes several triggers to fire, you should write unit tests that evaluate the procedure for various inputs. Each unit test should pass or fail depending on whether it re...
I have an SSRS 2008 report where the default parameters values are this:
<ReportParameter Name="BegDate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=DateAdd("D",-13,DateAdd("D",6-(Weekday(Today)),Today))</Val...
