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)

3
votes
0answers
70 views

sql server spatial index performance

I have a table with around 2 million records in it. I created a spatial index, using the defaults other than the bounding box. I've been noticing that some queries are extremely fast, and some are ...
3
votes
3answers
187 views

Get SSMS to show the time a query completed at?

I'm using Sql Server Management Studio 2012, and I'm wondering if there is a way to have a query show me at what time it was run and/or completed at. Basically just some kind of timestamp so that I ...
0
votes
1answer
325 views

Role-Schema Permission issue (Management studio)

When designing a new database I organized the table under different schemas. I've also created a new role that should have select/insert/update/delete rights on one schema and only select on another ...
0
votes
1answer
277 views

SQL Server sp_addrolemember in stored procedure for different database

I have a stored procedure to restore the latest backup of a prod database to an acceptance database. Once it's restored I need to grant a user read access to the database. Use statements are not ...
1
vote
1answer
74 views

Can a large number of schemas be an issue?

Can a large number of schemas present a problem in some ways (performance, maintenance)? By large I mean a few thousands, and schemas will mostly contain views, fetching data from shared tables.
1
vote
1answer
63 views

How to transform this result set?

I have the result set above that I stuffing into a table variable @ApptTemp, and trying to transform it into something similar to the one below. Note that of the 4 rows that have a description of ...
-1
votes
1answer
141 views

How to repair .mdf file? [closed]

My sql databases in SQL Server 2014 has the status "suspend" as I saw in SQL Management Studio. I can't restore to serviceable condition sql databases through standard procedures. I need to restore ...
4
votes
1answer
532 views

Side effects of using updlock lock hint?

I was just exploring UPDLOCK hint in SQL-Server 2008 and I found it is very useful in avoiding certain deadlock scenarios. There are always some side effects when using these types of lock hints but I ...
2
votes
1answer
4k views

How To Execute an Integration Services (SSIS) Package from a SQL Server Stored Procedure

i am executing query like this on sql server 2008 R2 DECLARE @returncode int EXEC @returncode = xp_cmdshell 'dtexec /f "C:\certs\SSIS Disposition\SSIS Disposition\SSIS Disposition\Package1.dtsx"' ...
1
vote
1answer
116 views

Moving a SQL Cluster to Another Data Center w/No Downtime

We have a two node SQL 2008 Enterprise cluster in a data center in California, and are looking to move hosts from a leased environment to a colo environment much closer to our home office. Our ...
2
votes
1answer
1k views

Creating Users on secondary server in log shipping

I have a production Server say ServerA I have setup log shipping to ServerB which is left in read-only mode. The purpose of this log shipping is to lower the load on production server for some ...
1
vote
1answer
237 views

cons of linked server providers not running in “allow in process” [closed]

what are the cons of having linked server providers not running in "allow in process"? SQL box crashed due to oracle provider crashing and it provider was running in "Allow in process", now have been ...
3
votes
1answer
264 views

SHOWPLAN does not display a warning but “Include Execution Plan” does for the same query

I was running the following query in SSMS and it showed me a warning in the "Include Execution Plan" window select CLIENT_GUID, PMT_AMOUNT, DATE_COMPLETED from ( select payment.CLIENT_GUID, ...
2
votes
0answers
119 views

Frequent, “random” SQL Server connection timeouts

For the last few days our clients have been suffering intermittent connection timeouts to our database server. Multiple Ajax calls on the same page which connect to the server multiple times are ...
3
votes
3answers
208 views

Very high I/O on database during a backup maintenance plan

I've recently been having some hellacious problems with a specific maintenance plan. I found that part of the problem was that I had Shrink and Rebuild Index in my nightly plans, those have since ...
3
votes
1answer
139 views

Can't update trigger because of activity

Trying to add a line to a trigger that is attached to a table that is constantly in use ALTER TRIGGER [dbo].[name_of_trigger] ON [dbo].[name_of_table] AFTER UPDATE BEGIN IF ORIGINAL_LOGIN() in ...
3
votes
1answer
784 views

AlwaysOn Availability Group Forced Failover

May I request your input. I setup SQL 2012 with always on availability group for my databases in sync and secondary readable mode. I completed failover tests with sync mode and it is functioning as ...
3
votes
2answers
266 views

Running MongoDB and SQL Server on the same host- memory pressure

We have a new application that is making use of both traditional MS SQL and MongoDB for data storage. We're running both instances on the same Windows 2008R2 x64 machine, with 64GB RAM. There have ...
1
vote
1answer
222 views

Deadlock occurring on database, SQL Server 2008R2

Last few days I had major problems with my production site, turns out deadlock occurred, every half an hour maybe 50-60 of them. To do a quick fix in order to keep the site running I set : ...
3
votes
1answer
78 views

Secure database access from particular applications

I have an C#.NET application and a SQL Server database (SQL Server 2008 R2) and would like to restrict the access to some of the Tables when it has been accessed from some other application rather ...
1
vote
0answers
29 views

remove the instance while uninstall msi package

I have uninstalled the XYZ.msi package from Control Panel.It is completely uninstalled,but it's instance is still available in SQL server 2005.Why the instance didn't remove after uninstall of the ...
4
votes
1answer
2k views

Can not start SQL Server, model db in RESTORING state

Quick run down: First problem started when sysadmin received error that model is recovering. Sometime later vendor tried to do some upgrades to the database. When they restarted SQL Server it failed ...
0
votes
1answer
29 views

Is reconfiguration required when switching sql server machine to use a FQDN?

I'm going to be changing the Primary DNS Suffix (not the NETBIOS name) of a Windows 2008R2 Server that does not belong to a windows domain (eg. a WORKGROUP computer) in order to give it a FQDN. Is it ...
1
vote
0answers
90 views

How to take advantage of multiple spatial indices?

All, I'm building a view which uses a spatial intersect (STIntersect in MSSQL 2012) between points (student addresses with address information) and polygons (school boundary polygons with school ...
2
votes
3answers
83 views

Query databases on different servers

How can I create a query that will find all the databases on different servers? I have four servers, PRDSVR, UATSVR, DEVSVR, TRNSVR; with either copies of the same database on each server or ...
3
votes
1answer
64 views

SQL Server backups strategy with limited storage available

I've a SQL 2012 Server setup on a VM, with 3 disks: Disk 1: 150GB --> System Disk 2: 750GB --> SQL mdf Disk 3: 750GB --> SQL ldf DBs are in full recovery mode. Let's say we'll have 350GB of data ...
0
votes
1answer
108 views

DB collation is used for comparison instead of column collation

I am moving data from one SQL Server to another. lets call them source and destination SQL server. The source SQL Server has collation SQL_Latin1_General_CP1_CI_AS and the destination has collation ...
2
votes
1answer
46 views

Accidental Turn On of Replication

We had a log file that wouldn't stop growing even though we do backups. Turns out that replication had been turned on for that database. None of us DBAs did that (at least as far as we know). So, ...
0
votes
2answers
209 views

Memory Allocation in Shared DB & IIS Environment

In my use case, we have production servers that host both IIS & SQL on the same machine, not ideal but no flexibility to change that. Basically a single machine is both a DB and an Application ...
1
vote
0answers
29 views

What does this icon in SQL Server mean? [duplicate]

Can someone tell me what the icon of a server and a blue database symbol means. It is attached to database engine instance in my object explore view. (I apologize, I am unable to add a image of the ...
3
votes
2answers
589 views

What does this SQL Server icon mean?

What does the icon of a server with a blue database symbol mean?
1
vote
1answer
446 views

The provided statistics stream is corrupt, when running UPDATE Statistics

When running UPDATE STATISTICS mytable I'm getting following error: The provided statistics stream is corrupt. When our application is inserting rows to mytable we are getting the same error. ...
1
vote
1answer
120 views

Is it dangerous to use Linked Server? (SQL Server 2008)

I wonder what are the security risks in using Linked Server.
4
votes
1answer
176 views

Putting a condition related to a table in JOIN is better?

I have seen this a lot that people are putting table related condition on JOIN clause. See this example, SELECT i.Name FROM sys.TABLES AS tbl INNER JOIN sys.indexes AS i ON (i.index_id > 0 ...
0
votes
1answer
40 views

remove the instance while uninstall a database

I have uninstalled the database but it's instance is still available in SQL server 2005.I want to remove that instance.Is any possibilities to remove the instance while uninstall a database?
0
votes
0answers
57 views

Oracle Database Gateway for SQL Server - Output changes to multibyte view

I have a really strange problem querying a Microsoft SQL Server through a Oracle Database Gateway for SQL Server. Some query outputs look like this SELECT NAME, RawToHex(NAME1) FROM XY; Output: J ...
1
vote
1answer
603 views

SQL Server Agent cannot log on to “MyServer”

I'm struggling to get our SQL Server Agent to run a maintenance plan, which used to work in the past. (This is on SQL Server 2008 R2.) The original problem was that the SQL Server Agent would not ...
2
votes
0answers
252 views

Can I recover a single table from a SQL Server 2012 database backup [duplicate]

I have accidentally dropped a specific table and I don’t want to restore whole database (it is huge) but instead I want to recover only that table from a backup? What would be most simplest ...
2
votes
1answer
39 views

How can I model and enforce constraints on a categorical item contained in a collection?

Scenario: There is a collection of items where each item belongs to 1 category. There is a collection of buckets which may contain at most 1 item from each category. Oh, and an item may belong to at ...
4
votes
1answer
289 views

A clarification of MERGE best practices

I just wanted to ask a clarification about something on the MSDN from the "Optimizing MERGE Statement Performance" page. I am working with a data warehouse that takes in records from many different ...
2
votes
2answers
183 views

SQL Server 2008 R2 Missing Index

I am performing index maintenance on a database. I have run SQL script that uses DMVs to provides a list of indexes SQL Server believes should be created. I am not creating indexes just because the ...
4
votes
1answer
91 views

Understanding Backup Types

I have recently started a role as a junior DBA... Yesterday I created a new database for a co-worker and my boss asked me to make sure we get a backup plan on it asap. I didn't think much about it, ...
2
votes
1answer
60 views

How can I automatically have a node become primary in an Availability Group?

In my environment, I have Db01 and Db02 setup with SQL 2012 AlwaysOn. Db01 is the preferred master as that is where all of the backup jobs reside. Typically, the only time that Db01 is unavailable is ...
2
votes
0answers
90 views

SQL Server 2012 High availability Groups for OLTP and Reporting environments

I would like to seek your advice in designing a high availability architecture at my current work place. We are moving to SQL Server 2012 platform and we currently have a set of OLTP databases ...
0
votes
2answers
290 views

SSMS connection string

In SSMS we are giving hostname\instance name to connect to SQL Instance, can someone please explain me how it is getting connected, is it using any files or protocols or what exactly is happening in ...
0
votes
1answer
441 views

Reporting Services TempDB lock blocking report generation

Two days ago one of our reports in Reporting Services started to take much longer to generate. Its generation time had increased from 4 seconds to 2 minutes. Investigation found: The Stored ...
1
vote
0answers
76 views

Efficient way to Add NON-CLUSTERED Index?

I have the following table, CREATE TABLE [dbo].[Products]( [ID] [int] IDENTITY(1,1) NOT NULL, [RetailerID] [int] NOT NULL, [Name] [nvarchar](255) NOT NULL, [Price] [float] NULL, ...
1
vote
1answer
83 views

Automatically keep synchronized copy of database

I want to create a working copy of my main database to hold it on a separate server to run queries and report generation on to take the load of the main server. I'm looking into SQL Server ...
0
votes
0answers
139 views

SQL Server and Entity Framework

We are currently experiencing a problem with Entity Framework which generates a sp_executesql statement. This statement is below. The statement runs fine in SQL Server however through the front end ...
0
votes
4answers
276 views

SQL Server 2005 - 2 sets of backups - 2 maintenance plans?

I did my best to search for an answer to this question and couldn't find a scenario quite like this. I'm a fairly new DBA in the sense that I haven't had a ton of training, I basically took the job ...