Questions tagged as 'sql-server-2008'

Tagged questions
1
answer

PHP SQLServer Stored Procedure Does Not Run Correctly

Hello, I'm developing an application using Laravel Framework Handler from my Backend and found the following error. My SqlServer Express 2008 R2 database has a stored procedure that performs a series of routines and inserts data already forma...
asked by 19.12.2016 / 16:34
2
answers

Return values smaller than 10 of a column with DateDiff

I need to return values less than 10 in a column with DATEDIFF and others between 10 and 20 in the same column. Can anyone help me? SELECT CONVERT(VARCHAR(10), (MAX(REMESSA.DT_USO_FIM)),105) AS DATA_DEVOLUÇÃO ,DATEDIFF ( DAY, MA...
asked by 10.04.2017 / 20:48
1
answer

How to join the return of 8 query's into one?

I have 8 query's all have 5 unusual columns and some distinct columns,  Based on the common columns, can I display a single result of 8? Common Fields: F.CHAPA AS CHAPA, F.NOME AS NOME, F.FILIAL AS FILIAL, F.SECAO AS SEC...
asked by 25.10.2016 / 20:19
5
answers

Reduce log file size

I'm in a saga with my database, today I have an 11GB mdf file and a 77GB log. I already researched several forums, I applied some reduction procedures via Management (shrink) and via command like SHRINKFILE, the database is already as simple. bu...
asked by 17.02.2016 / 13:06
1
answer

Starting SQL Server 2008 Express r2

Well, I have a problem: I formatted my computer and I can not start SQL Server 2008 Express R2. When I click on the icon to boot the following message appears:   Microsoft SQL Server Management Studio - An error occurred while trying to acces...
asked by 29.07.2015 / 18:47
1
answer

How to do this SELECT (SQL Server 2008)?

To be honest, I do not even know how to start my question. So I'll first put the information I have. I have the following structure in my database. I need to do a SELECT that returns me the following: How can I achieve this?   ...
asked by 08.01.2015 / 21:09
0
answers

Make a Shrink on a 2.6 TB bank [closed]

Hello, I have a SQLServer 2008 Standard R2 on a 32GB of RAM server, 5 HD 2TB making RAID5, whose database is 2.6 TBytes in size and a table uses 96% of every MDF file, as can see in the image below: Thetable" ClientType" consists of two c...
asked by 27.12.2017 / 20:12
1
answer

java error in connection with SQL Server

I am trying to connect to a sql server database, but I am not succeeding. Here is the connection class and test method: public class ConexaoBanco { public static final String user = "sa"; public static final String pswd = "**********"...
asked by 03.11.2017 / 18:36
1
answer

Remove "." "/" and "-" from varchar in select

I am conducting a query for a client where he / she requested that the CNPJ / CPF of the companies / clients be displayed without the dots, bars and dashes. For example, the CNPJ 08.595.551/0001-57 should be displayed 08595551000157...
asked by 14.03.2018 / 13:55
1
answer

SQL SERVER 2008 r2 - TEMPDB ERROR

Good morning, does anyone know a solution to this error: Msg 8921, Level 16, State 1, Line 1 Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors...
asked by 08.09.2017 / 13:17