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
33 views

Run sp_blitz stored procedure on linked server [closed]

I am trying to run the scripts provided here https://www.brentozar.com/first-aid/first-responder-kit-power-bi-dashboard/ on linked server. I can see that the @OutputServerName is not functional yet. ...
0
votes
2answers
56 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
20 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
55 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
25 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
78 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
54 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
51 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
0answers
26 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
14 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
67 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
63 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
45 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
59 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 ...
0
votes
0answers
30 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
26 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
59 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
68 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
20 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
27 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
35 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
36 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
33 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
37 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
49 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
45 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
40 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
283 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
53 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 ...
0
votes
0answers
85 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
65 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
38 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
41 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
73 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
vote
1answer
64 views

Is it better to add a data file or better to increase the existing files (MAXSIZE)

I'm quite familiar with SQL-Server as a developer but not so much in the DBA role. Currently I'm working on a rather large DB (~7TB, living in 7 files, all equal in size and all within one single ...
1
vote
1answer
46 views

Update statistics

For the data retention purpose I am deleting records from some 60 tables. Some of the tables have less number of records while some have more. I don't want to update the stats for all the tables. Is ...
-1
votes
1answer
67 views

Improve performance in Deletion Operation

I Am doing Import Process of half a million records. Initially i will move the .csv file data to a sql table,then i will parse the records (Split the records to different tables and then parse) and ...
0
votes
0answers
34 views

Strange SQL 2008 R2 Sp3 Ent behavior - redistribute data across multiple files

I’ve got a 5TB database (Database_PROD) in one data file (1,5 TB of empty space in it). Installed some time ago by someone on SQL Server 2008 R2 SP3 Enterprise. Database contains 2726 tables and 5399 ...
2
votes
1answer
44 views

Error while creating Extended Events on 2008 SQL Server

I am trying to create an extended event to capture the login information of my server. While creating an extended event on SQL 2008 using the below query CREATE EVENT SESSION [SA_Monitor] ON SERVER ...
0
votes
0answers
83 views

SQL Server 2008: The target name, “package0.event_file”, is invalid, or the object could not be found

What can cause the following error? Msg 25623, Level 15, State 2, Line 1 The target name, "package0.event_file", is invalid, or the object could not be found Given the following TSQL: CREATE EVENT ...
0
votes
3answers
113 views

MS SQL 2008 R2 - How to use a production database through dev/test environments or how to copy a SQL schema and all its data to another

We currently have 3 Windows Server 2008 R2 VM identically build for Sage x3 v6.5, one for production/formation/budget database, a second one for QA (qualification) and a third one for dev & tests. ...
0
votes
0answers
119 views

Unable to create linked server from SQL Server 2008R2 to Azure SQL

I have created a couple of databases in Azure and added them to an Elastic Pool. I am able to create a linked server on SQL Server 2017. The issue I am faced with is when creating the linked server ...
1
vote
2answers
244 views

Oracle to T-SQL OPENQUERY special character conversion issues

I'm struggling to figure out where the character encoding issue on my Linked server may be coming from here. The ZPDT_PAT_ALPHA column should have a degrees symbol at the end, as shown by the DUMP. ...
0
votes
2answers
25 views

Merging or transposing data

Data structure as follows: ID Oper DateTime 3849 Login 2019-12-17 06:30:57.500 3849 Logout 2019-12-17 15:46:37.880 3849 Lunch 2019-12-17 12:16:11.373 3849 LunEnd 2019-12-17 12:46:26....

1
2 3 4 5
78