Tag Info

New answers tagged

0

You should probably create a .sql script that can run and return the value for multiple commands. A script can be easily created using the following format: set nocount on select "sp_helpdb " + name + char(10) + "exec " + name + "..sp_spaceused" + char(10) + "go" go This will print out a list of commands that looks like this: sp_helpdb DATABASE_01 exec ...


0

OK thought I'd attempt to do some benchmarks that didn't rely on any "warm cacheing" so that hopefully they'd be a more realistic test (also using Postgres, to see if it matches the same characteristics of other posted answers): My benchmarks using postgres 9.3.4 with a large-ish database, (hopefully large enough to not fit in RAM cache): Using this test ...


1

It appears that this can be done with subqueries inside publications. From documentation: CREATE PUBLICATION SalesRepData ( TABLE SalesReps TABLE Customers SUBSCRIBE BY rep_key TABLE Contacts SUBSCRIBE BY (SELECT rep_key FROM Customers WHERE Contacts.cust_key = Customers.cust_key ) ); This would catch all customer contacts for sales rep's ...


1

The answer below was taken from Sybase official technical documentation available at http://www.sybase.com/detail?id=1048699 Sybase Servers support the use of date and time data through the datetime and smalldatetime datatypes (and, with newer server, the date and time datatypes), as well as the getdate(), dateadd(), datediff(), and datepart() functions. ...



Top 50 recent answers are included