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
1answer
11 views

How to store a version sequence per product

I need to create a table like the following one: +----+---------+---------+ | Id | Product | Version | +----+---------+---------+ | 1 | 1 | 1 | | 2 | 1 | 2 | | 3 | 2 ...
2
votes
1answer
22 views

Understanding & Resolving Deadlock in SQL server 2008R2

I am trying hard to figure out what may be going wrong for below shown deadlock graph: I am receiving alerts for deadlocks similar to above for almost every 10 minutes , its just the query changes, ...
1
vote
1answer
29 views

Permissions required to alter a database file

Totally at the beginning in administering a database. Using EMS SQL Manager ... latest version. How do I over come below ALTER DATABASE joneslocker2 MODIFY FILE ( NAME = joneslocker2, ...
1
vote
3answers
178 views

Improve delete speed for SQL Server

We have huge production database, its size is around 300GB. Is there any approach to improve performance of a delete query? Right now deletion speed is between 1-10k per minute, it is very slow for ...
1
vote
0answers
20 views

sp_send_dbmail causes session to hang

We had an issue in production (2008R2 SP3) yesterday, where a developer was running a piece of code in SSMS that was executing sp_send_dbmail inside a transaction, and including an attachment from a ...
1
vote
1answer
21 views

Incremental (not differential) backup of SQL Server 2008 R2

Is it possible (out of the box or free software) to make an INCREMENTAL backup of SQL Server 2008. My problem is, the full backup and differential backup, backs up my 30gig database to 1 file. So ...
3
votes
3answers
106 views

Is Primary Key Non Clustered recommended?

I am designing a database table. Columns are RouteId ,Origin , Destination. RouteId is a string, it is always unique but length will be more than 60 characters. Since RouteId is unique, I am ...
0
votes
1answer
13 views

Difference between “Table-Incremental” and “Table-Update” for “Population Type” when scheduling Full Text Index Population

I want to schedule a Full Text Index's population to keep it more up to date rather than leaving it to Automatic and not knowing the next population time as the users are complaining about the data ...
0
votes
1answer
16 views

Database with FILESTREAM enabled gives Error 3056 during backup

I have a SQL 2014 database enabled for FILESTREAM and I am getting errors 3056 during backup. The message is DESCRIPTION: The backup operation has detected an unexpected file in a FILESTREAM ...
0
votes
1answer
52 views

Estimation of creating index in SQL Server

We create new index on our production database, with a few fields, our database size is around 300GB and it works for one hour and do not finished yet. How can you estimate this operation? If we ...
1
vote
2answers
16 views

Error 3201 Operating system error 5(Access is denied.) Creating backup on network drive

Msg 3201, Level 16, State 1, Line 1 Cannot open backup device '\\nst-shantanug\c$\Dummy Db Backup\dummydb.bak'. Operating system error 5(Access is denied.). Msg 3013, Level 16, State 1, Line 1 ...
1
vote
1answer
33 views

What is the different between resource pools and workload groups in sql server?

In SQL server one can use resource pools and workload groups, what is the difference between them? Why should I use one over the other?
2
votes
1answer
28 views

sql server 2014 unable to connect with Microsoft account or sa

I am running sql standard 2008 r2 on my box. and its been working great. I just installed sql server 2014 on my machine as a second instance. The service is running fine, but when I try to log into ...
2
votes
1answer
25 views

Trigger Logic (from SQL 6.5 )

I have a database that was originally implemented in SQL 6.5 and has been migrated to SQL2000, SQL2005 and now SQL2008R2 (Compatibility Mode = 10). Through the migration many new tables, functions, ...
0
votes
0answers
27 views

SQL server running on a virtual machine times out on one physical server but not another [on hold]

I am running a Microsoft SQL server batch processing job on a virtual machine that is running on a physical server. We run these jobs often, however, one day the batches we run started timing out. We ...
3
votes
2answers
469 views

Is there a way to calculate yesterday / today of last month / year in SQL?

Is there a way to calculate today (and yesterday) of last month (and last year) in SQL? Assuming today is 26-May-2015 then how to find? Today of last year i.e. 26-May-2014? Today of last month i.e. ...
1
vote
0answers
33 views

Should I delete disabled windows Active Directory accounts from SQL 2008?

Is there a risk of not deleting unused Windows logins that have been disabled in AD or is it simply a housekeeping issue? e.g. Windows authentication is used to provide database access. A user leaves ...
5
votes
2answers
147 views

How to monitor history of logins to database if login auditing is not enabled?

I have a number of databases on multiple servers that don't seem to be used any longer. Can't find their owners, there are no processes linked to them, nothing got written to the tables for a few ...
0
votes
0answers
28 views

SQL 2012 Standard Edition (on Azure VM) + Bitlocker. Good or Bad idea?

I will start this question with a few statements to negate any "Why" questions that are going to be asked. The Head of IT wants the data encrypted. Our profession is such that encrypted data is ...
0
votes
0answers
43 views

SQL server 2008 [on hold]

I am having a problem that I can't figure out. I have one live server and one test server. The (Live) and (Test) are very similar, but there are a lot of differences because of testing reasons. But ...
4
votes
1answer
66 views

Prevent Inserts without Column List

We have a database running on SQL 2008 R2, in 2000 Compatibility mode. Is there a way to configure the database so that implicit insert statements (i.e. those without a column list) are invalid? I ...
2
votes
1answer
42 views

Index fragementation ? is it unavoidable

This is follow up question to @martin smith excellent answer http://stackoverflow.com/questions/1251636/what-do-clustered-and-non-clustered-index-actually-mean After that i have watched MCM video of ...
1
vote
1answer
147 views

Do I need a database license for my application? [on hold]

I am developing an application for cemetery management. It is my first "big" project, so I'm not familiar with the "corporative" side of this. First, some info about the app: Has 3 local database ...
0
votes
0answers
36 views

sys.sp_reset_connection. Why theres a lot of them ?

Theres a lot of questions here on DBA EXCHANGE. But none of them can help me. I have 2 problems: 1) Using sp_whoisactive, I found lots of sys.sp_reset_connection;1( I know they are ...
0
votes
0answers
39 views

DBA vs DB Engineer vs DB Programmer [on hold]

What are the specific differences between a Database Administrator, Database Engineer, and a Database Programmer. I'm trying to determine which title is truly most fitting for my day to day duties, ...
1
vote
1answer
60 views

Can we create indexes on views in SQL Server? [on hold]

Can we create Indexes on a view in SQL Server 2008? I have heard about indexed view, which can give performance improvement, but the problem is data refresh on those views: Can it be auto updated, ...
0
votes
1answer
17 views

SQL Server Mirroring (with Witness) and Client Timeouts

Can you explain what happens in this situation. Imagine I have a Sql Server Mirroring set-up with 2 databases and 1 witness. Database clients have in their ConnectionStrings the Principal= and ...
0
votes
0answers
27 views

Data Mock up for my table

I want to mock up data for a table. So I need to generate a million sample records for the table? Table structure is like this: CREATE TABLE Employees( EmployeeID int NOT NULL, FirstName ...
0
votes
0answers
16 views

Excel connecting to SQL Server Database and editing tables [on hold]

I would need to connect from within Excel to a SQl Server table and to be able to edit and update the table rows using that excel. Is there a simple way of doing this without having to write ...
1
vote
0answers
19 views

Certification Test 70-461 [on hold]

I am a student at University of Houston-Downtown and looking to take the Database Administrator certification test sometime in October. I am hoping that someone has been recently been certified or ...
1
vote
1answer
49 views

Why does MS SQL Server return a result for empty string check when Unicode string is not empty

select * from (select N'ግዜ ' as t) as t2 where t= '' the string 'ግዜ ' matches the above check, why is this?
0
votes
1answer
20 views

JDBC local MSSQL Server connection string

I have installed open source database management tool "dbeaver" and want to use it instead of Sql Server Management Studio. But there is a problem. I searched from the internet but somehow I could not ...
2
votes
1answer
44 views

How to archive a whole database?

I have a database that is not going to be used anymore but that needs to be kept around for a long time. I'd like to remove it from the production system. My goal is to save storage space when ...
1
vote
1answer
57 views

When Should You Shrink Your Database

I have read conflicting articles about shrinking a databases. Basically, our database grew 100% overnight from 150 gigs to 300 gigs b/c I believe it was with staging tables I put in. However, all the ...
1
vote
0answers
23 views

Uninstalling MS sql server 2012 issues

I'm trying to uninstall ms sql server 2012. But when I click Microsoft SQL Server 2012(64 bit) and choose remove option it shows like this. Then how can I remove the MS SQL Server 2012? Please help. ...
1
vote
1answer
28 views

Creating a global temp table in a SQL Agent job

I want to create a global temp table in a SQL Server Agent Job. Here is the code: CREATE TABLE ##TestEmployee(Id int, EmployeeName nvarchar(50)) When I execute in SSMS, all is well. I then put ...
0
votes
0answers
29 views

Performance impact of IF @@TRANCOUNT > 0 COMMIT TRAN

I'm dealing with some performance issues on SQL Server 2012. The client application indicates that the SQL time to load a page is over 2.5 seconds with a total loading time of more than 3 seconds. For ...
-2
votes
0answers
24 views

TCP Provider: The semaphore timeout period has expired [on hold]

In Sql Server2008 R2 and Windows Server 2008R2, when I start Replication I have this error: TCP Provider: The semaphore timeout period has expired Please help me to solve it... Thanks!
1
vote
0answers
37 views

SQL Server 2008R2 to SQL Server 2012 Install

I'm trying to upgrade one of my SQL servers from 2008R2 to 2012 and I'm getting an error popup within a couple of seconds from starting the setup The Error is TITLE: SQL Server Setup failure. ...
0
votes
0answers
14 views

SQL Server: Importing snapshot of tables from linked server

I need to import 2 tables from a linked SQL server. So far, the following code has been successful: SELECT * INTO MyTable1 FROM MyLinkedServer.MyDb.dbo.MyTable1; SELECT * INTO MyTable2 FROM ...
2
votes
1answer
45 views

Several Foreign Key and Cascade Delete SQL Server

In SQL Server 2014, I'm trying to add CASCADE DELETING (I want to set field to null actually, but is the same ) on 3 FK. If I add a Cascade Delete in one relationship, it works fine. If I add more ...
3
votes
2answers
75 views

Split database to fit on SSDs

I have a database that's about 3TB in size and want to upgrade to SSDs. The SSDs I found that are reasonably priced are only 512GB so I'll need to purchase multiple drives. What are some ways to ...
8
votes
1answer
128 views

Trace Flag 4199 - Enable globally?

This may fall under the category of opinion, but I'm curious if people are using trace flag 4199 as a startup parameter for SQL Server. For those that have used it, under what circumstances did you ...
3
votes
2answers
44 views

Which Log should I start backups with?

We have log backups running every 15 minutes and nightly fulls/diffs (fulls are once a week per DB, but they are spread across the whole week for load balancing). Lets say for a particular DB I have a ...
0
votes
0answers
18 views

Data Sources are not visible through browser or through SSMS when connect to reporting server but are visible in SSMS

As above I have a reporting server and currently when I browse to bizvm01/reports Data Sources are not visible through the browser. Reports are visible and they work. When I connect to bizvm01 using ...
1
vote
1answer
42 views

Find all tables that are related to a view recursively sql server

I have a view-A that is comprised of other views (View-B View-C) and I would like to list all the tables that used by View-A (which would include the tables used in View-B and View-C). When I use ...
1
vote
1answer
44 views

How does RANK() work in this query? [on hold]

I want to delete duplicate rows from a table. I have searched for the query online, and found the following sample: DELETE FROM dbo.LeadsContacts WHERE Sr_No IN ( SELECT Sr_No FROM ( ...
0
votes
1answer
13 views

Where to look for Agent history in Replication?

In SQL server 2008R2 replication configuration, "agent history cleanup distribution" job by default runs every 10 minutes and deletes any historical data older the 48hrs. If I increase the retention ...
0
votes
1answer
18 views

Periodically update a table with new records from another server

I have databases on two different servers. I need to regularly retrieve new records from a table on server A, and process them in order to use them to update a table on server B (with a different ...
-1
votes
2answers
27 views

database Compatibility 90 to 100 changing causes any problem

We are planning to change Compatibility level of databases from 90 to 100. Would this cause any impact on application side? If yes then please guide me, what steps or measures we need to look upon ...