Questions tagged [sql-server-2008-r2]

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

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

why a convert from varchar do date fails on a different row everytime it runs?

I have a database with a field like this (Dont know why it's varchar): 19950105 i'm trying to convert it to DATE as DDMMYYYY. I could do this with: convert(varchar(10), cast(The_ugly_field as ...
0
votes
2answers
32 views

Installation and shell to move physical and logical SQL Server in azure IaaS VM

Firts of all excuse my english is not my primary language. We are creating an azure template to deploy an IaaS machine with disks C and D with windows server, and the idea is also deploy an ...
0
votes
1answer
271 views

UPDATE STATEMENT GETTING STUCK

I am facing a performance issue with an update statement. It takes too long to update, but when I perform a select on that updating table it completes very fast. UPDATE mo SET mo.RNCNEID = ts....
0
votes
1answer
24 views

Was SSRS installed in SharePoint Integrated Mode?

I've inherited an old QA database server with SQL Server 2008R2 (yes, yes, I know it's beyond EOL; there's nothing I can do about it!) and SSRS installed. It's the back end of a SP server on a ...
6
votes
1answer
1k views

SQL Server - Files timestamps unchanged so what is it that's being backed up?

Please see the below snapshot, showing the timestamps of all the data files as well as transaction log files for one of the SQL Server instances under my management. This is a production instance. ...
2
votes
0answers
123 views

SQL Server: Read Only replica of production server

I have a production database which is being used by my primary application. Another department has created a new application for which I need to provide subset of my data from my database. The new ...
1
vote
3answers
131 views

How to Add A User To A Database In Standby / Read-Only Mode In Sql Server

I have a database which is in standby / read-only mode in my reporting server. But, I can not add a new user to this database. How can i add a new user to this database?
0
votes
1answer
30 views

Can I modify the fill factor value while a database is in use?

I'm using SQL server 2008 R2. I asked a similar question before on this forum, now I'm asking: First, can I change the fill factor while the database is in use? Second, how can I determine the most ...
0
votes
0answers
35 views

Unfinished A Killed/Rollback Transaction [duplicate]

I have killed a transaction 2 days ago but it hasn't finished yet. You can see the situation in the pic. What can i do?
0
votes
1answer
45 views

Sql Server view with very limited access

I have a requirement to limit a view in Sql Server 2008 R2 that user: user has access to select from view. user has not access to copy the result from select statement. user has not access to join ...
1
vote
2answers
67 views

Error while running sp_blitz in 2008 SQL Server and lower versions

I have created an SSIS package to run sp_blitz in my production servers. The stored procedure runs fine for servers having a version higher than 2012 but fails for 2008 and 2005. Please find the ...
-1
votes
1answer
37 views

How to Find All Sql Server Users Privileges Rights

I want to list all user's privileges which is in Active Directory accout or using Sql Server account to connect to my database server. I want to see that which users have ddl right or which users can ...
0
votes
2answers
77 views

Database Log File Size Growth So Huge Unexpectedly [duplicate]

My database has two log files. Their sizes are growing very fast. My backup sizes are becoming massive. I know that when I take full backup of my database, the log files are emptied but it is not. I ...
1
vote
1answer
64 views

How to Get Backups & Restores Start and Finish Times?

I backup my databases from prod environment to file server. After taking my backups, i restore them to my report server. And i want to know that if i can get information about when backup and restore ...
1
vote
1answer
60 views

Can I change Fill Factor option for our database server?

I have a production database for ERP which has clustered and non clustered indexes. Some other tables have index type as heap and i don't understand what does heap means. Every month i have a job run ...
1
vote
1answer
70 views

Do I need to add more memory to my SQL Server 2008 R2 instance?

I've been asked if one of our SQL Server instances has sufficient memory. This is a SQL Server 2008 R2 Standard Edition running on a x64 machine with 40 CPUs and 64 GB of RAM. The total size of all ...
0
votes
1answer
31 views

Capturing Column Names in Dynamic SQL Statement

I'm in the process of updating some procs made for SQL 2008R2 to 2016 that are using a dynamic result set. Assuming there is a procedure that always has exactly one result set, but the result set has ...
0
votes
4answers
385 views

Can I change tempdb size to a specific value and can I shrink it during our daily working hours on our production database

Can I change tempdb size to a specific value and can I shrink it during our daily working hours on our production database ?. Please tell me if it has bad effect on a production database. My database ...
0
votes
1answer
48 views

Survey Database Structure

I am building a database to feed into a PowerBI dashboard. The data is extracted as CSV (SurveyResults) from Survey Monkey which will be loading into the MSSQL database. The outcome i am after is the ...
3
votes
1answer
67 views

Log error restoring old database to SQL Server 2017

I am trying to migrate a database from an old SQL Server 2008 R2 to SQL Server 2017. The database was originally 2000 and thus has a compatibility level of 80. Initially I took a full database backup ...
0
votes
0answers
25 views

How to create difference value in last group row

I want to create a query for a find difference value between Quo QTY and INV QTY and display in the last group row. For example, in this picture, I want to query a display like this. but now it ...
0
votes
1answer
113 views

Moving Partitioning Files To Another Disk Drive In SQL Server

There is a production table which was partitioned by someone in our company. Some partitioning files was wrongly located to different disk drive. I have to move those files to the disk where they ...
3
votes
1answer
57 views

Inconsistency between object explorer and available database dropdown

I am working with SQL Server 2008R2. I am able to see a database in the "available database" drop down, but not in the object explorer. I am able to query it, for example select * from ...
2
votes
2answers
72 views

How can I backup my large SQL Server table?

Environment: SQL Server 2008 R2 Standard Edition on Windows Server 2008 R2 (yeah - I know). VMWare, Commvault. We have a 1.4 TB DB with one table. Here is the schema: CREATE TABLE [dbo].[...
0
votes
1answer
55 views

What is the best way to check for matching sets of rows?

I was watching this video yesterday on how unlikely it is to shuffle a deck of cards the same way twice: https://youtu.be/czSdEhtXwm4?t=300 And I thought to myself "My SAN adminsitrator still has ...
0
votes
1answer
79 views

Without rewriting this query, is there a way to force the query optimizer to better estimate the amount of resources required, e.g. with query hints?

I know there's a couple of alternate ways to write this query, but I'm more curious if there's another approach that I could use to improve the performance by helping guide the optimizer in the right ...
0
votes
0answers
21 views

How Can I Evaluate a SQL Server Policy using T-SQL?

I have created a policy in SQL Server 2008 R2 and need it to be evaluated on demand - whenever a new database is created. In order to achieve that, I created a DDL trigger at server level, which ...
0
votes
1answer
91 views

Define Database Size

I want to create a database with Size limitation. I am using sql server 2008r2 edition. Maximum size should be only 20GB. That means it should allow only 20GB space for particular database. How can ...
3
votes
3answers
83 views

I need help with a SQL Query. SQL beginner here! [closed]

I'm totally new to SQL and I've inherited a customer's server (the company that managed it no longer exists). They need me to run a SQL Query that shows their inventory sold for pots. Specifically, ...
0
votes
1answer
41 views

Is it safe to add more than primary data file to Temp DB in SQL server 2008 R2 as we have database server with 4 Core processor?

Is it safe to add more than primary data file to Temp DB in SQL server 2008 R2 as we have database server with 4 Core processor and please tell me the steps to do it .And does it will tune ...
1
vote
2answers
78 views

Replace function removing Ones / 1 when removing char(185) (superscript 1)

Ok as the title suggests this is occuring. When using the REPLACE function on char(185) for data in a temporary table, ones ("1") are being removed as well. SQL SERVER 2008R2 UNICODE Data DB ...
0
votes
2answers
48 views

How to find Sum of dynamically generated time attribute in sql server 2012

I have a table with two columns (TASKID and Dateadded). I am trying to find difference between timings and would like to calculate the sum of the diff (time) attribute. select taskid,dateAdded,CAST((...
3
votes
1answer
196 views

How do I grant a SELECT permission to an individual user who's part of a large group that is explicitly denied?

I have a table SuperSecretData which is currently setup to deny SELECT to everyone in the company by the standard Active Directory account "Domain Users". But a couple of specific individual users do ...
8
votes
2answers
2k views

Is It normal to keep log file larger than data file? [duplicate]

Is It normal to keep log file larger than data file? I know why my log file is large, it is because I have a huge modification and locking occurred on a specific time, and caused my log file to be ...
2
votes
2answers
392 views

How to bulk convert ISO8859 text in Text columns to UTF8 in nvarchar(max) columns?

I've been struggling for days with a problem on a MS SQL database. Here is the situation: I have an old Open Source PHP application (Limesurvey version 1.92) running on a Windows 2008R2 server, with ...
1
vote
1answer
38 views

SQL Server Setup: Report Server and RAM Considerations

DISCLAIMER I am a software developer by trade, but sometimes have to put on my 'dba' hat in the absence of a true dba. SETUP I am working on a project where: SQL Version is SQL Server 2008 R2 (...
6
votes
3answers
2k views

Is it possible to take a database offline when doing a backup using an SQL job?

I have the scenario where I have to generate a backup of the database (SQL Server 2008) and restore into the new server (SQL Server 2016). While taking backup data should not be changed in any case. ...
8
votes
1answer
497 views

Slow query when having 'contains' and '=' together in where clause

The following query takes about 10 seconds to finish on a table with 12k records select top (5) * from "Physician" where "id" = 1 or contains("lastName", '"a*"') But if I change the where clause to ...
-1
votes
1answer
76 views

Is there any possible way to modify the database state from within the scope of a CTE? [closed]

For example: -- Directly with a DML Statement WITH CTE_DML AS ( UPDATE Table1 SET Column1 = 'Value1' FROM Table1 ) -- Indirectly by executing a procedure WITH CTE_SP AS ( EXEC ...
0
votes
1answer
82 views

Set up read-only privileges on the dbo schema, but allow creation of entities in another schema?

Is it possible to create a custom schema in a database such that users that have read-only access in that database for the dbo schema can be set up with the ability to create and modify entities for ...
0
votes
1answer
26 views

Will an AD Account inherit all the User Mappings to databases that it's parent AD Group is mapped to?

If a Windows AD Group and an AD Account that belongs to that AD Group are both setup as Logins on a SQL server, will the AD Account Login inherit all the User Mappings that it's parent AD Group Login ...
3
votes
1answer
404 views

What is the purpose of “Schema Owner”?

If I create a new schema and set the schema owner to another schema, for example dbo, what is the meaning of that in regards to my new schema? Does my new schema inherit the same permissions from it'...
2
votes
1answer
128 views

SQL Server Agent Job is Delayed?

I have an SQL Server Agent job set up to run every minute on the minute. Usually it runs exactly at :00 on the clock but occasionally it waits several seconds. See below, one of the jobs was ...
1
vote
0answers
43 views

Has my repair fixed incomplete patching?

I am patching a SQL2008R2 Express Edition instance. On the first failed attempt, all seemed to be fine - SQL loaded, dbs online, @@VERSION returned the expected results, but errors were found during ...
2
votes
1answer
93 views

Connect to SQL Server 2008 R2 from Windows 98

Is it possible to connect to SQL Server 2008 R2 from a Windows 98 machine? If it is possible, what would I use? I have an old testing machine that currently writes to an access database. This ...
5
votes
1answer
65 views

Performance Metrics After Enabling Auto-Stats

Short Version After enabling AUTO_CREATE_STATISTICS & AUTO_UPDATE_STATISTICS_ASYNC on a database, what performance metric will best display the changes? Long Version We just realized that the ...
1
vote
1answer
37 views

Is there a way to group the output of a query based on two rows

I'm not sure my question is asking the right question, so i will be as specific as possible in here. I have the following data which i have changed the values of. Below is the code I am using to ...
3
votes
3answers
2k views

What is the latest version of SQL Server native client that is compatible with Sql Server 2008 r2

Title says it all, what is the most recent version of Sql Server native client that is compatible with Sql Server 2008 R2
0
votes
1answer
63 views

Application/MS SQL Server Express Installer

We're developing a small(ish) application that collects and stores data. It's low-throughput, low-volume, but needs to be able to archive and retrieve data from (almost) arbitrarily earlier times, ...
1
vote
1answer
359 views

Why am i getting a truncation error when running a SSIS package on the sql server agent, but not when i manually run it

I created a SSIS package that drops then creates a table, to transfer data from Sql Server 2008 r2 to an access file. When I run it in BIDS 2008r2 it runs just fine, no truncation issues at all. When ...

1
2
3 4 5
76