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

Single Virtual Drive Vs Multiple Virtual Drives for SQL Server files

Hi guys I have question about how two different Hard disk setups can possibly affect performance of my database. I have two Options. Option 1: One Physical Harddisk and then Multiple Virtual hard ...
0
votes
0answers
3 views

Sql Server, a single threaded query spawns multiple threads (or internal parellelizaion during execution)

In Sql Server, when I run a procedure or a query that takes multiple minutes, sometimes spawns multiple threads. Even though there is no MAXDOP hint or necessity in the query, I see multiple instances ...
3
votes
2answers
113 views

migrate all databases from one SQL server 2005 to another SQL SERVER 2005

We have a production SQL Server 2005 server on which we are hosting 200 databases. We want to host these databases on our new server. On new server SQL Server 2005 is installed and is ready. I want ...
1
vote
0answers
16 views

Integrity checks on large dbs (700GB)

What's the best strategy for integrity checks on large dbs? DBCC CHECKDB (DB Name) would probably take over 24 hours, the largest table (532GB) would probably take over 17 hours...
0
votes
0answers
14 views

Copy SQL Logins and Permissions From One Server to Another

I need to duplicate all Logins and their associated database-level permissions from one server to another. I am using SQL Server 2008 R2 for Server A and SQL Server 2012 for Server B I am able to find ...
1
vote
0answers
16 views

Alternatives to log shipping / Replicate a local SQL Server database on a remote DB accesible only by IP

I'm trying to replicate a local SQL Server 2008R2 DB to a remote DB instance accessible only by IP (specifically, a RackSpace cloud site DB). I believe log shipping is ideal, since the remote only ...
3
votes
1answer
52 views

Possible reasons for really long database recovery

This is cross-posted at SSC, but restore is now going on 6 hours. Hello, Overnight I ran restores with NORECOVERY for a 5tb database, along with several other 250GB - 1.3tb databases. I did that ...
2
votes
1answer
59 views

Inserting variables into another variable

I've been working on the code below. I'm trying to insert results of a declared variable into a sql statement. I've highlighted the section below that I'm talking about. What am I doing wrong here? ...
0
votes
0answers
19 views

Attempting to Pivot a column of grades and coming up with NULL values

I have Data in a table that i'm attempting to pivot from rows to columns, and the script im using is working, but the pivot is coming up with NULL for everything. Here's the source data: ...
-4
votes
0answers
26 views

Stored Procedure for Phone number format to e.164 standard [on hold]

I'm trying to create a stored procedure with a parameter to check if a numbers column is in e.164 standard. How can I verify if is a e.164 standard of phone numbers? The standard :[+][country ...
0
votes
0answers
94 views

How to convert Excel into Star-schema Model?

My end user gave an Excel spreadsheet with 15 columns and 50K rows out of which 5 columns are calculated and 10 are not. My data modeler has converted Excel into a single TABLE on Microsoft SQL ...
0
votes
0answers
11 views

not able to create SSISDB catlog in Sql server 2014 [duplicate]

getting below error while trying to create catlog in slq server 2014 integration services. any idea what i missed in installation or anywhere else? The catalog backup file 'C:\Program Files\Microsoft ...
4
votes
2answers
799 views

How can I find databases with a large number of virtual log files?

I have several databases on a production server that are in the hundreds of gigabytes, and have many thousands of transactions running through them on a daily basis. Almost all these databases are ...
1
vote
1answer
21 views

Not able to create SSISDB catalog

getting below error while trying to create catlog in slq server 2014 integration services. any idea what i missed in installation or anywhere else? The catalog backup file 'C:\Program ...
3
votes
3answers
467 views

What are the pros and cons of using my customer codes as a primary key?

I am designing a database for one of my sales teams. Right now, the goal is to get a master list of customers and their mailing addresses, but the DB will eventually expand to track some other ...
1
vote
1answer
14 views

Windows Managed account to report subscription file share

Is it possible to used a Windows Managed account to access a file share in a Report subscription? When creating a Windows file share report subscription, on Step 4 - Create a data-driven ...
1
vote
2answers
86 views

Update on view over partitioned tables updating all indexes

We have a table, which is partitioned through a date field into separate years. There is a view over all of these tables (Call) Schema is as follows: CREATE TABLE [dbo].[Call_2015]( [calID] ...
1
vote
0answers
24 views

700 million row mixed text/numeric data - read-only in a single table [on hold]

Our data has some small character fields, and a few floating point and integer columns. About 36 columns in all. It is about 700 million rows. Is it feasible to use MS SQL Server to host this data? It ...
1
vote
0answers
19 views

Is there any way to set stored procedure options like ANSI NULLs to true or false outside of creation?

I'd like to set ANSI NULLs and quoted identifier properties on a stored procedure after it has been created. Is this possible? For some context, I'm using Visual Studio Database Projects / SSDT, and ...
0
votes
0answers
51 views

SQL Joins returning all records from two tables [on hold]

I have two separate tables. I need to return all their records in one go for reporting purposes. I need to make this a stored procedure and all records need to be shown in a single output when run. I ...
0
votes
0answers
16 views

SQL Server EE Licensing Question [on hold]

If I licensed SQL Server EE for production work on one server, SA allows me a free failover replica on another server if not used even R/O during normal operation. MSDN allows me to run SQL Server EE ...
0
votes
1answer
31 views

how drivers work in sql server

We have different drivers like ODBC, OLE DB, JDBC. I understood when we want to work with Excel in SQL Server, we need to load different driver. But my question is why we need different drivers, what ...
0
votes
1answer
35 views

How to transfer Right-to-Left text from Excel to SQL Server?

I have a collection of data in my Excel which the language is right-to-Left. My data collection is very large. I want to transfer this to my SQL Server database and insert the values into a table. ...
0
votes
0answers
27 views

SqlServer: can one table's PK be the FK of two table's?

I have three tables project, users and proj_user. The PK of proj_user table is the FK of project and users table's pk e.g.(project_id,user_id) My question is, is it possible if the project_id and ...
0
votes
0answers
16 views

Install JDBC driver 4.0 for SQL Server

How can I confirm that JDBC is running and properly configured/registered in the system? I followed the installation instructions but I believe there has to be more to it than what the instructions ...
1
vote
1answer
69 views

DBCC Results: page ID contains an incorrect page ID in its page header

DBCC results for 'tablename' Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 1637580872, index ID 1, partition ID 72057596516040704, alloc unit ID 72057594048020480 (type LOB data), page ...
1
vote
1answer
47 views

Changing SQL Server service account

My team foundation server is running its databases locally and the person who originally installed the system decided to just use LocalSystem as the service account for SQL Server instead of actually ...
1
vote
2answers
100 views

Extracting an an integer value from an xml column

I'm just wondering how I can extract an integer out of an XML column. Currently all the digits are 4 which the below query is able to do. But the number is going to grow to 10,000's soon which will ...
3
votes
1answer
61 views

Total Fragments 99% and I cant get it to stay down

I have a SQL Server 2008 R2 database it is of size 13000.31 MB and my largest table has around half a million records. It is a database that I have bought. It already has indexes but when I run the ...
0
votes
2answers
84 views

Alternatives for a LEFT OUTER JOIN query

Problem I have a SQL statement with an LEFT OUTER JOIN which works fine on our Microsoft SQL Server. My problem is that i have to be compatible with H2 Database and this one got a bug with OUTER ...
3
votes
1answer
36 views

SQL Server Replication w/o network connection

Is there a way to use SQL Server Replication without a network connection? My would-be publisher is an SQL Server 2005. It is on the "outside" as it is connected to my company's primary LAN, which is ...
0
votes
0answers
18 views

Exporting data using SBIDS

I have created lots of SQL reports using Microsoft Visual studio (from BIDS as part of the SQL package). I am running 2008R. When I export the data I would like to export to Access instead of the ...
0
votes
2answers
271 views

Best way to Design Key,value pairs in relational database?

I have a table which has a list of all attributes that any object can have: attr_id attr_name attr_data_type ------ ----- -------------- I have a table [object_key] in which each ...
4
votes
1answer
82 views

Why is an additional filtered statistic being ignored (EAV schema)?

I'm trying to improve a row estimate for this sub-query (of a larger query). The estimate is showing 1266 rows. The actual is 117k rows. This particular property (EAV schema) only has two values ...
1
vote
1answer
32 views

why doesn't this parameterized sql return anything while the non parameterized one does?

I have tried to use sql parameter on one of my queries and noticed when ever i do so, it just doesn't return anything! while the none parametrized one works just fine. Why is it ? None parametrized ...
1
vote
0answers
22 views

Backups failing for all databases

Here is the error message in its entirety: Failed:(-1073548784) Executing the query "BACKUP DATABASE [MCM] TO DISK = N'F:\Backup\MCM\M..." failed with the following error: "BACKUP DATABASE is ...
0
votes
0answers
26 views

Measure fragmentation of a single index?

We are measuring the impact of different defrag approaches that we do one index at a time. How do we query to see fragmentation of a single index, by index name (or table + index). This is on SQL ...
0
votes
0answers
15 views

Merge Replication — Reinitialize Without Recreation

I have a publication with ~10 subscriptions configured as clients. They all have a partition of that data using row filters. Earlier this week I received this error on two of the subscriptions: ...
2
votes
1answer
39 views

Sum Actual in different period

I have the following table test : test is a table that contains the number of week , start and end day of each week for a month WeekOfMonth StartDate EndDate 1 2014-05-01 ...
4
votes
0answers
52 views

SQL Server Database File Groups on a SAN: Relevant or Not?

I am about to build out a new SQL Server and I was planning to make extensive use of file groups. I expect heavy growth, and heavy read/write to 5 different databases on this server. I was planning on ...
0
votes
0answers
14 views

OEM SQL Server plugin - Discovering targets

I am trying to configure OEM to work with SQL Server using the plugin. I have the agent installed on the Windows Server, and the system is being monitored just fine. But when it comes to adding ...
0
votes
1answer
61 views

How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously

I have two servers, Oracle and SQL-Server. I have same database on both the servers. I want to perform DML (insert,update,delete). How can I perform same DML statements on both the servers ...
1
vote
0answers
30 views

Query slower than the sum of its parts

I have a query with the following pseudo outline 1. CREATE TABLE #Temp 2. INSERT INTO #Temp 3. INSERT INTO A --90% of time spent here 4. INSERT INTO B --10% of time spent here 5. INSERT ...
2
votes
1answer
23 views

How do you generate large OLTP and reporting workloads?

My current skillset lies towards plain vanilla data warehousing, with < 20k users, our setups are rather simple.. I am looking for ways to enhance my technical skills, however, as much theory as I ...
0
votes
1answer
47 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' ...
4
votes
2answers
88 views

SQL Server cluster resource won't come online unless its on port 1433

The 2-node SQL Server 2008 R2 cluster works fine until one of the resources got removed. I successfully added it back. However, the cluster is not able to online the SQL Service unless it is on 1433 ...
0
votes
2answers
38 views

Sql Server Management Studio can't remember passwords

When I connect to a database using ssms, I also have a checkbox labelled "Remember password". However, ssms will not remember the password. The next time I connect to the same server, I have to write ...
0
votes
3answers
32 views

Instead of Trigger Continue with operation after custom logic?

I do not think what I am trying to do is possible, but I could not find any documentation on this. I have an INSTEAD OF UPDATE, INSERT, DELETE that always inserts data into a history table before ...
0
votes
0answers
19 views

SQL Server partitioning of many-to-many tables - triggers

Many to many tables usually have only foreign keys to related tables, like EmployeeId PositionId Is it good idea to add column only for partitioning and set its value with INSTEAD OF INSERT/UPDATE ...
0
votes
1answer
54 views

How To Recover Data From A Corrupt Mdf File?

By mistake I deleted a database from sql server. Due to which the the mdf and ldf file of the database are removed from my system. Then I used file recover utility and retrieved my mdf and ldf files. ...