Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).

learn more… | top users | synonyms (2)

0
votes
0answers
86 views

I cannot restore a SQL Server database in a new location

Made backup of the database on server c, SQL Server 2012, moved on to the local computer with SQL Server 2012, restore database does not work. When checking the validity of the file on the server ...
0
votes
0answers
90 views

Why do the databases go into the “recovery pending” state when the share permissions are changed from “everyone”?

Yesterday we had a power failure and after the power was back our financial databases on the SQL did fall into "Recovery Pending" state. After struggling a while I've remembered that a few days ago we ...
0
votes
0answers
110 views

The Local Security Authority cannot be contacted

I am not very expert with SQL Server but I have to use to for one of my application development. Issue is that when I open the PC in morning to start my work, my application couldn’t make connection ...
0
votes
0answers
89 views

SQL Server Timesheet Query Performance

I am working on a webapp for timesheet administration. I write a query to group all the time entry of an employee by week. And I also have to use paging. The query is already slow with something like ...
0
votes
0answers
46 views

SQLSTATE:HY000, SQLCODE: -385

I am getting the following error when I try to deploy my tabular model to a local instance localhost\tabular The model processes on my local PC with no errors but when I try to deploy it fails with ...
0
votes
0answers
33 views

Fill Factor - Displaying Old values

I updated my fill factor value from 0 to 75 and I rebuild all the indexes on the database When I ran select * from sys.indexes some indexes are 0 and some are 75 The Indexes that are 0 (I am not ...
0
votes
0answers
39 views

TDE state is changed after DB deployment

I have database projects in Visual Studio 2013 from which I deploying databases to SQL Server. Also I am using Transparent Data Encryption for these databases and it is in state 3 which means TDE is ...
0
votes
0answers
151 views

SSRS Consuming a Single Core

I have production SQL Server machine with 10 separate instances on it: The last instance that was added included an install of SSRS. Since that time I've seen high CPU usage on a random single core ...
0
votes
0answers
174 views

View Job Properties Fails for Job Owner

Domain user MyDomain\UserA has a login with a server role of public and is a user of the msdb database with membership in the SQLAgentUserRole. The user owns a job, Daily Job. When logged in as the ...
0
votes
0answers
36 views

SQL Server - How to set multiple variables from excel spreadsheet?

I have a spreadsheet of 4 columns as shown. What I want to achieve is this: update apodetail set status = 'O', cur_amount = 'VAR1', rev_price = 'VAR1' where order_id = 'VAR2' AND line_no = 'VAR3' ...
0
votes
0answers
49 views

Kerberos and Linked Server

I have been reading through past posts but I am still getting issues with 2 SQL servers connecting using a linked server when querying from a 3rd SQL server. I constantly get the error "Login failed ...
0
votes
0answers
58 views

lock request time out period exceeded. When revoking db_owner access

I am trying to revoke db_owner access of an user and I am getting this below error! I have no active transactions User (whom I want to revoke access) is not connected to any db DataBase owner is ...
0
votes
0answers
69 views

How can I get a list all Databases in a Database Instance

I am getting an error with SQL Copy Database Wizard. It is finding a database that was dropped over a year ago and fails because it cannot be found. I cannot find any reference to the database and ...
0
votes
0answers
30 views

SQL Server to Oracle migration

Converted model resulted into incomplete script generation as all stored procedures, triggers and views were missing, only table structures were generated and i did not get any error messages for it. ...
0
votes
0answers
20 views

Using previous (.mdf) datatabase with VS 2012

I have a previously created web site with aspx pages, a database and login page that was originally created in Microsoft VS Developer 2010 Express. The database has several hundred records and is ...
0
votes
0answers
113 views

Timeout occurred while waiting for latch: class 'ACCESS_METHODS_HOBT_COUNT'

We have a big reporting database on production server, and we have several SSIS jobs running against it. Yesterday almost all this-database-related SSIS jobs stuck and running forever. Also the ...
0
votes
0answers
21 views

Replicated databases across locations; delay in application

I have a replicated instance of database on different locations different SANs which is utilized for running a vendor supported application. However, I notice that there is a significant delay between ...
0
votes
0answers
12 views

Azure Security for SQL Server Data

We are considering moving some of our database services to Azure but due to the kind of agreements we have with our customers having strict control over who can access the data is required. Based ...
0
votes
0answers
51 views

Grant permissions on stored procedure

I created a user in SQL Server 2012 database and revoked all permissions given by the public role. Then i granted exec permission on a stored procedure. The user can execute the procedure but cannot ...
0
votes
0answers
20 views

Load data into central database

We have 150 databases at different locations. These databases need to be move into central database. currently, i am using transactional replication, but facing lot of issues. are there any other ...
0
votes
0answers
101 views

Efficient way to transpose large categorical column to one-hot table row

I have a varchar column containing ~ 8000 unique values and 500k rows. I need the column transposed so that the column headers are the unique values and the values in the rows are 1 where the row has ...
0
votes
0answers
21 views

Moving Replicated & Partitioned SQL2005 Enterprise to SQL 2008R2 Enterprise

Our SQL2005 Enterprise has 4 databases which are all partitioned, each have 5 files and a handful of tables replicated, compatibility mode is 90. They are on an old Windows Server 2003 32bit machine ...
0
votes
0answers
19 views

Control locking behavior for Snapshot Replication

I want to have snapshot replication of several databases into single one for reporting purposes. I choose replication because i need to publish just certain columns. I don't need transnational ...
0
votes
0answers
17 views

A transaction has been utilizing the version store for X minutes

For one of our servers we are getting below critical alert from Idera Diagnostic manager saying: A transaction has been utilizing the version store for 93 minutes on ABCKP1. The current version ...
0
votes
0answers
46 views

Public Role Access For All Users in SQL Server

If I'm not mistaken this comes configured like this by default. Our new DBA stripped this permission and broke ownership chaining. In my mind "public" means "everyone" and hence the permission and ...
0
votes
0answers
39 views

SSAS, Last Non empty broken

I have a straight-forward account fact table containing dimensions for Date, AccountOwner In SQL my fact table has column bookings (that can be negative for outgoing money and positive for incoming ...
0
votes
0answers
42 views

Postgres equivalent of SQL Server recovery model Simple

I am migrating an SQL Server database to PostgreSQL. The original database recovery model is Simple, mainly because the log size and performance are issues. What are the recovery models of Postgres ...
0
votes
0answers
51 views

Purging Data that has Foreign Keys

I have a transaction database that we recently went live with. The number of rows in the tables are starting to climb into the millions. So I am looking at how to purge the older data. I have written ...
0
votes
0answers
51 views

Eager Spool 100%

I have a query like below, when I execute it, the parallel query always takes very long time to finish, I found there is index spool(Eager Spool) which costs 100% in execution plan... How can I ...
0
votes
0answers
45 views

Why does this plan cost even though there are no rows?

I execute a Batch-Operation. The whole execution needs about 60s. The following statement needs 75.6% of the whole Batch-Operation: update WW_Pos set LieferantID=null where LieferantID in (select ...
0
votes
0answers
56 views

Backup File Size Almost 50% of Database File Size with TDE Enabled

I'm really hoping someone can help shed some light on this for me. I receive a full backup of a very large database once per week from a vendor. It contains transactional data which we then load into ...
0
votes
0answers
136 views

MSDASQL returned message “ Key column information is insufficient or incorrect. Too many rows were affected by update”

Here we had two database one is SQLServer(retrieve and store attendance info) and MySQL(query from SQLServer and store as backend of PHP codes) Could you help to check and define what's the exact ...
0
votes
0answers
69 views

Log shipping Readonly/Standby executes Queries slow for some users

I have a SQL Server database that is doing log shipping to another SQL Server instance, both servers have identical hardware. We have a reporting service that then runs reports against the readonly ...
0
votes
0answers
70 views

SQL server Wait Type

What wait type is: FILESTREAM_WORKITEM_QUEUE? I'm troubleshooting SQL server for slowness but this wait typ has the most wait_time_me and over 55% total wait. How can I troubleshoot this ? I ...
0
votes
0answers
59 views

Auto update stats turned off for a user database on SQL Server

While trying to improve the performance of few queries, we found via execution plan that there were lot of index / clustered index seeks. Therefore: First thing we did, was to check our Re-indexing ...
0
votes
0answers
92 views

How can I perform reads and writes in the same transaction?

I'm trying to implement transactions in my application. I'm just trying to implement it like the example shown in the BeginTransaction() documentation. Public Shared Sub Process(wwid As String, ...
0
votes
0answers
58 views

Are these One-to-Zero-or-One relationship correct?

I'm working with SQL Server 2012 and I have these three tables: CREATE TABLE [dbo].[CODES] ( [CODE] [nvarchar](20) NOT NULL, [ ... ] , CONSTRAINT [PK_CODES] PRIMARY KEY CLUSTERED ( ...
0
votes
0answers
45 views

SQL Server Transactional replication - virtual box being the subscriber

I would like to ask if it is good practice to have the SQL Server transactional replication taking place from a physical box (publisher) to a virtual SQL Server (subscriber)? Regarding the ...
0
votes
0answers
251 views

Supplied parameter sid is in use when creating a Login in Sql server

I am trying to transfer the logins from the production instance to the test instance after a refresh activity for restoring the DB's regarding the same. From the output of sp_help_revlogin on prod ...
0
votes
0answers
16 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...
0
votes
0answers
70 views

Why am I unable to use a temporary table more than once on my Stored Procedure?

I am using SQL Server 2008 to build a stored procedure. On it, I create a temporary table (#results) using recursion for getting all the ancestors given a specific record. My specific problem is, ...
0
votes
0answers
190 views

Query to match exact column or partial data of the column: SQL Server / Azure

Bit confused on how to get it work better than what has been done now. I am new, apologies if I'm asking for too much. I have trip details which have from and to locations stored in database from ...
0
votes
0answers
16 views

How to Handle Jobs/Security/Stored Procs and Functions Across an Availability Group in System Databases

I'm fairly new to AG. We have the syncing up and running fine but I'm trying to account for failures and handling of stored procedures/functions/etc in the system databases (master, msdb). Are there ...
0
votes
0answers
12 views

Upgrading SSIS with Two SSIS Services Installed

I inherited a server with two SSIS services, one 2012 and one 2014. It looks like due to some type of incompatability with a 3rd party application, someone deactivated the 2014 SSIS and so the server ...
0
votes
0answers
48 views

Fastest way to compare polygon geometry types

We have two tables which has polygon geometry stored in them. I would like to fetch the polygons present in one table and not present in another table.. As of now I am doing a left outer join and ...
0
votes
0answers
6 views

Denormilization when using SSDT Analysis Services to Build Mining Structures

I'm interested in building a mining structure from a normalized table. This mining structure is intended to be used for modeling of several datasets within the normalized table. I'm finding that I'm ...
0
votes
0answers
34 views

Database still reports 600GB after removing 500GB File

I have a database with three files Log Primary Data File Blob Data file the database was becoming too big to manage (600GB) so we removed the blob data (500GB) into FileStorage outside the DB. ...
0
votes
0answers
28 views

Is it possible to target a specific instance in a clustered environment with group policy?

Not sure where to ask this, but here goes: I'm in a clustered environment, not the primary DBA (and he's not very AD/GP savvy either) and I'm being asked to set security permissions for an AD Service ...
0
votes
0answers
34 views

Integrating Postgres/GIS data in a SQL Server environment without generating 'data islands'

Currently I'm facing a scenario in which a GIS expert is planning on starting to integrate mapping services for several departments within the organization I work for. I handle around 40 mid-sized ...
0
votes
0answers
60 views

Mirroring via dedicated NIC between two multi-instance clusters

Scenario: Two node SQL Server 2012 cluster in Primary Site. Two node SQL Server 2012 cluster in DR site. Both sites connected via general MPLS network. Replication line available between the two. ...