02:00 - 19:0019:00 - 22:00
Actually I was a bit underwhelmed with VS2010, to be honest. I think an old-school create table script and files for stored procedures are easier to work with. If you need schema management then you can get Redgate SQL Compare Pro for a few hundred dollars.
If you really need a database modell...
I have two tables.
First one is a table with prefixes
code name price
343 ek1 10
3435 nt 4
4332 ek2 2
Second is call records with phone numbers
number time
834353212 10
834321242 20
834312345 30
I need write a script which find longest prefix from prefixes for...
Dear database admin,
I would like to request some questions for my database.
In our table, 13 fields are included.
The size of one row must be 1.6 terabytes.One row include the below fields:
bytea type = 2 columns,
char type = 4 columns,
int type = 1 column,
timestamp = 2 column ,
varchar...
I've inherited a (MS SQL 2008R2) project that, amongst other things, does a table update from another table:
Table1 (with around 150,000 rows) has 3 phone number fields (Tel1,Tel2,Tel3)
Table2 (with around 20,000 rows) has 3 phone number fields (Tel1,Tel2,Tel3)
.. and when any of those number...
The Games of the Small States of Europe (GSSE) is a biennial, multi-sport event, launched by the Republic of San Marino, organized by and featuring the National Olympic Committees of eight European small states since 1985. The Games are currently held at the beginning of June, and feature competition in nine Summer Olympic sports.
The 14th edition of the Games took place in June 2011 in Liechtenstein.
Member countries
The games are organized by the members of the European Olympic Committees (EOC). From its initial forming at the 1984 Olympics through 2009 there were eight members; the g...
11
SELECT DISTINCT ON (1)
n.number, p.code
FROM num n
JOIN prefix p ON right(n.number, -1) LIKE (p.code || '%')
ORDER BY n.number, p.code DESC
Sergey Aleynikov is a former Goldman Sachs computer programmer. He emigrated from Russia to the US in 1990. In December 2010 he was wrongfully convicted of two counts of theft of trade secrets and sentenced to 97 months in prison. In February 2012 his conviction was overturned by the United States Court of Appeals for the Second Circuit that entered a judgement of acquittal, reversing the decision of the District court.
Career
Sergey Aleynikov immigrated to the United States in 1990. From December 1998 to April 2007, he served as the director of Routing R&D division of IDT Corporation.
H...
In T-SQL, how do I replace the occurrence of a substring only at the end of a character string (varchar)?
For example:
If I were to do the operation with substring violence on character string 'violence begets violence', the result would be 'violence begets '
Some other examples are
1)'the f...
Any url or whitepapers on the database server parameters that can be tuned in MS SQL 2012 ?
I have a client with close to 120,000,000 records in an Oracle database. Their engineer claims they can only give us a ms access dump of their database. The data will actually be going into an MySQL relational database instance.
What potential issues and problems can we expect moving from O...0
I'm trying to do export from SQL Server 2008 to Excel with order by (through a query) inside and I get a syntax error.
Please tell what am I missing (I know for sure it's related to ORDER BY and it's something small):
CREATE TABLE `Z_STOCK_PARTNERS_2` (
`Date` DateTime,
`Partner` LongText,
`Wei...02:00 - 19:0019:00 - 22:00
