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

DBA vs DB Engineer vs DB Programmer

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
0answers
12 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 ...
0
votes
0answers
7 views

can we create indexes on views in SQL server

Can we create Indexes on a view in sql server 2008. I have heard about indexed view, which can give me a performance improvement but the problem is the data refresh on those views, can it be auto ...
1
vote
1answer
62 views

Slow Performance caused by Correlated Sub-queries & Clustered Index Seek

I'm running a query in which one of the tables (FIELDDATA) has nearly 400,000 records which is taking more than 2 minutes to execute. I ran the execution plan, and noticed that the clustered seek ...
0
votes
0answers
17 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 ...
2
votes
0answers
26 views

Merge row size overflow in SQL Server

The target table to which I'm trying to merge the data has ~900 columns. The code for the merge: MERGE TBL_BM_HSD_SUBJECT_AN_1 AS targetTable USING ( SELECT * FROM ...
0
votes
0answers
10 views

Excel connecting to SQL Server Database and editing tables

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
2answers
222 views

Primary Key choice on table with unique identifier

I'm reconsidering my choice of Primary Key on a table, and would like some input. Some context: We are building a REST API, where clients access "Assets" identified by a GUID. So, the table for ...
1
vote
1answer
24 views

why does MS SQL Server return a result for empty string check when unicode string is not empty but has trailing space

select * from (select N'ግዜ ' as t) as t2 where t= '' the string 'ግዜ ' matches the above check, why is this?
1
vote
4answers
520 views

SQL Server Table Backup

A friend of mine has run into this problem on SQL Server 2008, please suggest a solution: He came to know that auto backup scheduled on server were not taking place since last couple of days, when he ...
3
votes
2answers
71 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 ...
0
votes
1answer
46 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 ...
0
votes
0answers
17 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 ...
5
votes
1answer
3k views

How do I transfer logins from 2008R2 to 2014 with passwords?

I've tried Tasks>Generate Scripts... and set 'Script Logins' in the Advanced Scripting Options, but I get this in the output: /* For security reasons the login is created disabled and with a random ...
-1
votes
0answers
46 views

What is the implication of restoring Multiple Diff backups on SQL Server

As I know now, if I do a differential backup with SQL Server I am supposed to restore the full backup with NO RECOVERY and just the last diff with RECOVERY. I had a full backup, and 4 diffs, each from ...
2
votes
1answer
32 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 ...
0
votes
1answer
341 views

SQL Server 2008R2 - how to install replication components

I am trying to install the Replication components for SQL Server 2008R2, on technet website it says: On the computer that is running IIS, insert the SQL Server 2008 R2, SQL Server 2008, or SQL ...
3
votes
2answers
456 views

Security for Oracle linked server from SQL Server

I'm trying to make the linked server from SQL Server 2005 to Oracle more secure by not having user/pass on "Be made using this security context:" fields so only a specific user can access the data ...
2
votes
1answer
280 views

Database design for a table with both bulk insert and single row insert

I have to design a table where records will be inserted in two ways. Bulk insert from a batch process from a delimited text file between 2 - 3 million rows in a short burst. Later the same records ...
1
vote
0answers
22 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. ...
0
votes
1answer
2k views

SQL Server - linked Oracle server: EXECUTE permission denied on 'xp_prop_oledb_provider'

Inside of our SQL Server, we have created a linked server to an Oracle server. We ave mapped several users to the Oracle server and specified the credentials. On the Linked Server 'Security' ...
0
votes
1answer
105 views

copying data from a SQL server-table to a SQLCE-table

I want to copy some data from a MSSQL table to a SQLCE table in database.net. I used the following query, connected to the MSSQL db; update [SQLCE-table] ([column]) SET (column) FROM [MSSQL] I keep ...
2
votes
3answers
995 views

Twice job results in sql server, last one is left in progress

I have the job MP - Create CSV which execute a package SSIS in sql server 2008, when I check for the job history I see the result at step 0, I expand and I have 2 results for the step 1. Fist result ...
1
vote
1answer
22 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 ...
3
votes
2answers
42 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 ...
1
vote
2answers
114 views

Check entry based on entry in another column

Still fairly new to databases and SQL, so bear with me. I'm trying to check whether or not data can be inserted depending on data in another column, create table Table1 (PaymentType varchar(5) ...
0
votes
0answers
22 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 ...
-1
votes
0answers
19 views

TCP Provider: The semaphore timeout period has expired

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
33 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
1answer
512 views

mssql restore dabase is terminating abnormally

when i'm trying to restore databse.i'm getting this error in mssql : Msg 3287, Level 16, State 1, Line 16 The file ID 1 on device ...
3
votes
1answer
526 views

SQL Script to Drop old AD logins, Inactive SQL Logins and all related Users

Related Question: SQL Server script to delete accounts no longer in Active Directory Whilst the above question points out the rather handy sp_validatelogins procedure, i'd like to extend this ...
0
votes
0answers
13 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 ...
5
votes
2answers
411 views

Symmetric difference operation in Transact-SQL?

I have always known about the UNION operator in SQL, but only recently discovered that there were other set operators, INTERSECT and EXCEPT. I haven't been able to find an operator that does the ...
2
votes
1answer
44 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 ...
2
votes
2answers
34 views

Do valid to/from columns on a fact table make sense?

I recently came across "valid from" and "valid to" columns on a fact table. Obviously this is common for dimensions but I've not seen them on fact tables before and can't find any info suggesting ...
2
votes
2answers
464 views

Why is it truncate table, and not simply truncate?

Upon reviewing some of our code a colleague posited that he was annoyed at always having to write TRUNCATE TABLE when there is no real other usage for TRUNCATE. Googling this, I indeed can not find a ...
0
votes
1answer
12 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 ...
4
votes
2answers
54 views

Shared connection pool in SQL Server and prevention of cross-database queries

Microsoft recommends that a shared connection pool should be used when running e.g. a SaaS software with one database per customer but with a shared codebase to prevent pool fragmentation: ...
7
votes
1answer
103 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 ...
0
votes
0answers
14 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
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 ...
3
votes
1answer
108 views

Is it possible to create a database called C that is a view into all tables in database A + B?

Using SQL 2005 or 2008, is it possible to create a database called C that is a view into all tables in database A + B ? Databases A, B, and C are on the same local server. I am wanting to be able ...
0
votes
2answers
327 views

SQL Server 2005 to 2012 Replication, cannot access replicated data

I have created publication (snapshot, small table with 10 rows) on MS SQL Server 2005. Then, I created push subscription on MS SQL Server 2012. When I try to select data form table, process takes ...
1
vote
1answer
41 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 ( ...
1
vote
0answers
21 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 ...
0
votes
1answer
13 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 ...
3
votes
1answer
111 views

Transaction log backup file larger than expected?

I've recently taken over a SQL Server database that didn't have any transaction log backup routine running for at least 2 years. The first log backup was very large (3.8 gb on a 1.14 gb database) as ...
6
votes
2answers
2k views

How to extract a SQL database design into Visio in a manageable format?

I have a database diagram that I would like to extract from SQL and manipulate it to create a user-friendly and easier-on-the-eye ERD. The database contains over 200 tables and I would like to map ...
12
votes
2answers
539 views

SQL Server 2008 Performance issue with very strange resolution

I'm a long time DBA (12 years in SQL). I'm running SQL Server 2008 Enterprise in a Win 2008 clustered environment. 128gb memory and 32cpu in each cluster node. Not wimpy. I've got the weirdest ...
0
votes
1answer
634 views

How to generate replication snapshot without locking tables

When I reinitialize subscription and generate new snapshot it locks all tables and makes the database unusable for a very long time (never waited it out). Is there anyway to do this without locking?