Questions tagged as 'sql-server'

Tagged questions
1
answer

How to simulate load in a database?

I have a SQL Server database that recently had performance problems in production by the large number of concurrent users added to some implementation and architecture issues. After taking some measures to minimize the problems, I need to t...
asked by 10.10.2017 / 01:41
1
answer

User who has permission to create another SQL Server user

I'm trying to use a user other than SA to create new users on a SQL Server 2014 base, I've tried the db_accessadmin and db_securityadmin roles yet, but they do not permissions to change other roles. For example, when I create a user, I wa...
asked by 24.01.2017 / 11:46
1
answer

Phonetic search on SQL server

I need to implement phonetic search for Portuguese (br). Does anyone have any solution for phonetic searching in SQL Server with C #? Should the search fetch within a string using the SOUNDEX function or some similar function that works in pt...
asked by 25.06.2016 / 15:00
1
answer

Monitor space in sqlserver datafile

Generally, I do not let databases automatically grow to the edge of the disk. So I would like to know if colleagues have any procedure so I can monitor and be alerted of when the space in a Datafile is running out. Be it log or data. Example:...
asked by 28.10.2014 / 12:55
1
answer

SQL Server Data Dictionary

Hello, I come from the Oracle culture and I want to learn a little bit of SQL Server, I'm having trouble finding the SQL Server data dictionary, I've already looked at other forums and found nothing. In Oracle we have a data dictionary that s...
asked by 20.05.2018 / 01:58
2
answers

I can not put a subquery inside the IN in PIVOT

Below is the code for creating the table and inserting some data for testing. CREATE TABLE [dbo].[tb_empresas]( [data] [date] NULL, [nome] [varchar](100) NULL, [valor] [decimal](18, 2) NULL ) ON [PRIMARY] INSERT INTO tb_empresas (data, nome,...
asked by 10.03.2014 / 15:29
2
answers

Why use Bytes instead of using Image? What is the best practice?

I'd like to know why to use the data type Bytes instead of using Image itself. If the SQL Server database has the Image data type, then it should be easier and more convenient to insert it in Image right mode? I would lik...
asked by 10.02.2014 / 19:25
1
answer

Connection pool with ADO.NET and Dispose of SqlConnection, what is correct to do?

Yesterday I asked a question yesterday about What is the difference between implementations of IDisposable? I was implementing a class to help get instances of SqlConnection , SqlCommand , SqlDataReader methods Execute...
asked by 24.06.2015 / 16:26
1
answer

Is it possible to create a trigger that invokes a web service?

I'm working on the integration of two databases. It is a system that needs the status of employees in HR. For performance issues, I can not point all the employee-dependent queries to the HR base, what I did was create a functionality to i...
asked by 20.01.2014 / 13:05
1
answer

Installing SQL Server on the client

I developed a C # application that uses SQL Server Express 2012. In development everything went well with database access because everything is on the same machine (I use localhost ). Now I have to install the application on other compu...
asked by 09.06.2014 / 12:33