Questions tagged as 'sql-server'

Tagged questions
2
answers

What is the connection string "connectionString"?

What is the connection string anyway? In a connection string which represents data-source ? And the provider name ?     
asked by 22.04.2016 / 20:02
1
answer

Select fields from another table with multiple foreign keys

I have 4 tables: Lojas(nomeLoja, *IDloja*, morada, telefone, email) Bancos(nomeBanco, *IDbanco*, morada) PlanoContas(*conta*, descricao) Gestao(NIB, nConta, conta1, conta2, IDloja, IDbanco, *IDgestao*) conta1 and conta2 are...
asked by 13.05.2014 / 18:16
1
answer

Why does the SQL language vary from DBMS to DBMS?

I was used to using SQL for web projects, always using MySQL. One day I had to write a C ++ program that used databases. At first I chose SQLite but needed other computers on the network to connect to the database. So I opted for PostgreSQ...
asked by 29.08.2018 / 20:37
2
answers

Is a View faster than a regular Query?

When I use a query of type SELECT * FROM myView is faster than SELECT * FROM (query para gerar a view acima) I have a query and I would like to cache it or make it faster, but I am in doubt if I create with View or Query !     
asked by 17.10.2017 / 04:51
3
answers

How to know which DATETIME format used in a particular SQL Server column?

I have a table in SQL Server and one of the fields was created as DATETIME . As I can tell, via query or SQL Server Studio , what is the default format used of this DATETIME in my SQL Server ?     
asked by 15.04.2015 / 14:11
1
answer

Limit and Offset for web paging in SQL Server

I'm working with PHP and I have about 8000 records currently in DB. As it is for a web page, I need to make a pagination to be viable reading the data. As I understand it, I have to do something similar to limit and offset to...
asked by 28.11.2016 / 13:35
2
answers

Is it redundant to use LIMIT in a QUERY whose ID is a primary key?

My question is if using LIMIT will there be some performance gain in QUERY . Example: SELECT descricao FROM produto WHERE id = 9999 LIMIT 1 Has better performance than? SELECT descricao FROM produto WHERE id = 9999...
asked by 17.05.2015 / 01:57
1
answer

Maximum number of simultaneous connections to database

I'm using a systems monitoring solution and I notice that at peak times the system has about 1500 simultaneous connections. From this data, I searched and could not find where I can check the limit of simultaneous connections to the database....
asked by 09.02.2015 / 17:55
3
answers

How do I get the last date of a weekday in a given month in SQL Server?

Using the SQL Server T-SQL language, how to get, for example, the last Wednesday of the month of May in a given year?     
asked by 13.12.2013 / 17:45
1
answer

What is the best type in SQL to use with CryptoCurrency?

I am developing a system where I will store transactions of CryptoCurrencies, type Bitcoin, I can not in any way have problems of conversion and rounding, in C # I checked and the best is decimal , right? The values will be in this forma...
asked by 08.12.2017 / 19:31