Questions tagged [sql-server-2008]

SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.

Filter by
Sorted by
Tagged with
0
votes
1answer
36 views

DB autogrowth issue

I have a database that will growth in 1 month time the autogrowth was set to 500MB but as I monitored it, the consumption is 1GB+ per day. Should I wait for it to auto grow or is it better to set the ...
-3
votes
0answers
19 views

Runtime error for VB6 with SQL server 2008 [migrated]

We are facing some run time errors, We re using vb 6 and sqlserver 2008, can any one helping me with the error, I have tried to find out the solution, But not getting the solution.
0
votes
1answer
23 views

Minimal logging for bulk inserts?

I have many scripts running that truncate entire tables and rewrite data daily, however this fills my transaction logs very quickly. All these scripts use INSERT INTO .. SELECT. So recently I've ...
0
votes
1answer
43 views

The transaction log for the database fills up overnight everyday

Lately my server is overloaded because of daily running SQL jobs, my transaction log grows very large throughout the night and I run out of disc space. The short term solution was to shrink the log ...
1
vote
1answer
38 views

Store Decimal values without Trailing Zeros

I am using SQL Server 2008 R2 version. Is there any method to store decimal value in SQL without extra trailing zeros(like Float data type format). I have created a column with decimal data type with ...
0
votes
1answer
49 views

SQL 2008 permissions - cumulative or not?

I have a SQL 2008 production database which gets replicated using log shipping to a second, completely different SQL 2008 server. There is also another copy which is restored at irregular intervals to ...
0
votes
3answers
71 views

How to remove sysadmin from sa login in sql server

I have a requirement wherein I need to remove sysadmin server role from sa login. I created 1 more user and gave the sysadmin role to the user. When I uncheck sysadmin from sa login it throws an error....
0
votes
1answer
22 views

Log File Size and dbcc sqlperf (logspace)

Consider the following log file setting for a database named XYZ: Initial size = 250MB, Autogrowth by 500MB, Limited to 1GB I have created a SQL Job to monitor the size of XYZ database ldf using the ...
0
votes
1answer
14 views

Extracting string after and before a character '-' or '<' using Sql Query

I have table with one column 'UDF_WorkLocation_6' which contain string.Please Review following table. UDF_WorkLocation_6 MUMBAI - Maharastra<6> AHMEDABAD - Gujarat<1> MUMBAI - Maharastra&...
0
votes
1answer
29 views

Delete records from table A where col 1 and col2 are in table B

I am wanting to delete records from a table if multiple columns in this table are in another table. Currently, I usually just concatenate the columns and use the WHERE IN method: DELETE FROM TableA ...
2
votes
1answer
53 views

Does SQL Server Support Parallel Bulk Inserts From Multiple Connections?

Does SQL Server support parallel bulk inserts into the same database table? Some clarifications for my particular use case: The table has a clustered index composed of two distinct index keys, and ...
0
votes
2answers
63 views

T-SQL query must include and exclude child rows

I have simple parent -> child (one to many) relationship. Need to return children that have all given attributes, in this case red hair and brown eyes. Table: CREATE TABLE [dbo].[children]( [...
0
votes
1answer
25 views

Where to find the whole log of a maintenance plan package job that failed with error?

I have a maintenance plan that runs on SQL Server agent as a the job and finishes with error. However the error is not visible in job history in SSMS, the text of Message is seemingly truncated. How ...
-3
votes
1answer
152 views

RESTORE HEADERONLY is terminating abnormally [closed]

I am unable to restore my database. I am getting this error message: RESTORE HEADERONLY is terminating abnormally(Microsoft SQL Server, Error: 3242 Please help with a solution. Version is 2008. Am ...
0
votes
1answer
28 views

Table size increasing drastically in sql server

When I ran: SP_Spaceused TEST. I got this output which is very strange for 20918 rows. Output: name rows reserved data index_size unused TEST 20918 6240816 KB 6235480 KB 2304 ...
3
votes
1answer
81 views

How can I go about building a relationship with variable but ordered number of columns in a table?

First, I'm not a DBA or even much of an SQL person, so I apologize if this is too much of an entry-level question! I have been tasked with redoing an old csv file and turning it into a relational ...
0
votes
1answer
60 views

Restore Database without taking RDP [closed]

I have a DB server 192.168.X.X, Now due to some Issue with the domain user we are unable to get the RDP of that server. but we can get the DB connected from other server which is there on the network. ...
-1
votes
1answer
59 views

MYSQL Error: Incorrect usage of UNION and ORDER BY?

Am trying to randomize my first query but ran into an error "Incorrect usage of UNION and ORDER BY" Kindly find below my queries: SELECT * FROM( SELECT deal_page.id, ...
0
votes
1answer
31 views

SQL Merge Replication Issue - problem where backup and maintenance job which is running till morning and most of the server jobs are stuck

We have a merge replication environment which includes Publisher: Server1 where only one database of 125 GB in replication and also Distributor is also configured on same server hosted in a HyperV ...
0
votes
0answers
16 views

Is the Change Data Capture __$update_mask value still valid after removing and adding columns to table?

Let's say I have table I enabled cdc for. Now, if I want to add some columns to the table and also remove some columns and preserve the CDC data for the old columns, is it going to mess up the update ...
0
votes
3answers
319 views

How to remove database from explorer after deleting .MDF and .ldf files

I wanted to know if I can delete or remove the database shown in the object explorer after someone has manually deleted the MDF and ldf files from the database folders.
1
vote
2answers
80 views

How to remove dbcreator server role?

I was able to add the dbcreator server role to a user of a SQL Server DB, thanks to this nice question/answer: create-database-permission How can I REMOVE that permission? Is there a stored procedure ...
-2
votes
3answers
166 views

sql query for select first word of data from column

I have a table with this data: shyam banarjee rahul khanna priya kumari rohit srivastava I just want first names, like this: shyam rahul priya rohit
-2
votes
1answer
56 views

Shrink of a big databases ? SQL Server [duplicate]

In this moment I have a very big database (almost 4 TB) and wanna shrink data files for a future migration Unused space : almost 3000 GB I have in mind shrink data files day per day with low amount of ...
0
votes
3answers
166 views

I want SQL query for select multiple columns into one

I have one single table and in that table there are three columns company1, company2, company3. Below is my table data : Company1 Company2 Company3 ABC Test1 Test3 Test5 Test2 ...
1
vote
0answers
41 views

Missing tables in AdevntureWorksDB

Recently I found some old questions that involve querying data from AdevntureWorksDB across several operations(DML,DDL). One such question was : Create and execute a query that computes the total ...
0
votes
1answer
29 views

SQL Server 2008 - Replacing csv substrings in view-row using data from other table

Using SQL server 2008, is there a way to perform SELECT query in a view replaces a row containing comma-separated values with their corresponding text value from another table? STRING_SPLIT and ...
0
votes
1answer
75 views

SQL server row count

I had an activity for restoring a full database in SQL server 2008. I had to restore the database will norecovery since I had to restore the differential backups as well which will be shared everyday. ...
-1
votes
3answers
71 views

how to count second col if first col value is null and avoid duplicate count

I'm making sales statistic report to calculate scanned documents station wise using below Query: SELECT RIGHT(CONVERT(varchar(11),DATEADD(MONTH,DATEDIFF(MONTH,0,InvoiceDate),0),13),LEN (CONVERT(...
0
votes
1answer
28 views

Max Price Using Multiple Tables and Columns

The below code is working for me to pull out the max Avg Price, but I need to add another couple of fields from the dbo.TreatmentEvent table, when I add another column it stops giving me the max and ...
0
votes
0answers
22 views

MSSQL Mirai Botnet, cleaned but connects again using ANOYNMOUS LOGON

well this problem is making me go nuts my server was hacked with the Mirai Botnet, we cleaned the system, Disabled the Server Agent completely and the system is stable and clean BUT... if i re-open ...
0
votes
1answer
140 views

SQL EXECUTE TASK IN SSIS WITH ORACLE CONNECTION

following my previous question: Oracle source with SSIS 2008 on how to connect to an Oracle instance, which ended up working for me. However, I am currently stuck trying to run a merge statement on ...
0
votes
1answer
38 views

odd OS memory consumption by two nearly-identical SQL 2008 R2 instances

Instances are legacy, something we have to carry for the next 3 years, 2008 R2 64-bit, both SQL Server and Windows Server OS. Two copies on two nodes. Both servers are set to consume "Maximum server ...
0
votes
1answer
68 views

Add Leading Zeros in CASE, CHARINDEX and SUBSTRING Query

I am splitting a column based on the colon using this code which works. ,CASE WHEN CHARINDEX (':', ref) > 0 THEN SUBSTRING(ref, 1, CHARINDEX(':', ref) -1) ELSE NULL END AS EndVal The '...
0
votes
0answers
46 views

Sql server bulk loading optimization

We've got a process that's importing a 7gig / 334 million row data file. The data file is sorted on the first column The process is built on the "import first, index later" methodology. It uses BCP. ...
1
vote
1answer
38 views

Fetch data if exist in distinct of another column

I am trying to generate the query to fetch the data on the basis of company which have tax paid record in each year of : Select * From ( Select CompanyName , TaxPaidOn , ...
0
votes
2answers
27 views

I have to create tables where both have each as the foreign key . Which one should be created first

DDL QUERY FOR CREATING MAINTENANCE_PROBLEM CREATE TABLE MAINTENANCE_PROBLEM ( MP_ID int primary key, MP_Description varchar2(250), Standard_Min_Labor_Cost number(4,2), Standard_Min_Labor_Hours int,...
1
vote
2answers
53 views

SQL Server 2008 - Two FULL backups in one day

There is a database backed up by NetBackup once a day (Full backup 6PM to tape + 3/4x log backup per day). Database is in FULL recovery mode. Vendor of application has remote access and he scheduled ...
1
vote
1answer
47 views

Truncation error creating clustered index on schema-bound view

I was just creating a schema-bound view that I wanted to put an index on (to try out some computed column variations). I created the view WITH SCHEMABINDING, then I had to create a clustered index ...
-2
votes
2answers
42 views

query tuning help [closed]

All, Would need some tips / tricks to tune this query please: WITH Candidates(ActivityId) AS( SELECT ActivityId FROM EmailHashBase WITH (NOLOCK) WHERE ActivityId IN ( ...
0
votes
1answer
434 views

calculate running balance of debit credit using union all

i'm making account statement for which i need that account balance before today and with each transaction row of debit or credit plus and minus from initial opening balance on the basis debit/credit ...
0
votes
2answers
99 views

The Filegroup PRIMARY for the database CRM running out of space

I have a db for which I am getting error as shown below. The Filegroup «PRIMARY» for the database "CRM" in SQL instance "MSSQLSERVER" on computer "prod" is running out of space. sqace details in MB ...
0
votes
1answer
47 views

Is ORDER BY on two indexed columns will be slow?

I have multiple-field index on columns a,b,c,d and another unique index on column id. Is my query like below after adding id to ORDER BY slows large or i don't need to worry ? Query plan shows that ...
0
votes
1answer
41 views

In sql-server according to syntax, who has to go first: DECLARE or SET NOCOUNT ON?

In sql-server according to syntax, who has to go first: DECLARE or SET NOCOUNT ON?
0
votes
0answers
31 views

Cannot Connect to New Server

Disclaimer, I'm not a dba. I have been handed the job and have to do it. For day to day operations, I can handle the job, but now they want to upgrade the server and I'm stuck on this one issue. I ...
1
vote
0answers
214 views

Is it possible to use OAUTH2 in MS SQL Server

I am using msdb.sp_senddbmail procedure to send emails from MS SQL Server but now I need to move to OAUTH2. I tried to implement separate application and call it from procedures using xp_cmdshell but ...
0
votes
1answer
171 views

XQuery in SQL Server to convert XML column data to relational data table

I previously asked a question about an error I was recieving. You don't really need it to understand this question but it's here for reference: XML/SQL Server 2008 Error: XQuery...Cannot implicitly ...
1
vote
2answers
91 views

Produce fixed length output to file regardless of the length of data in each column/row

Not sure about this as I'm kind new to this. I need to output rows to fixed length files format. The table's columns are ID, Name & Desc. The output should be the same length for each row ...
-1
votes
2answers
56 views

How to get First in and Last out in multiple records with night shift:

We have Date, Time, EmpId, InOut, Shift_Start_Time and Shift_End_Time of an employee. Need your help to write a sql for these conditions: 1.Consider the records which Time is falling between ...
0
votes
1answer
90 views

The invoice number is characters and numbers combined but I want to change these to numerical only in SQL

The invoice number is characters and numbers combined but I want to change these to numerical only in SQL. I want like this CC/DDD/1, CC/DDD/2 .... n

1
2 3 4 5
78