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)

1
vote
2answers
76 views

Three databases : one instance or three?

I am a new DBA working for a charity and I have project to consolidate the multiple databases scattered across the organization. I have identified the main databases that are mission critical to the ...
1
vote
2answers
37 views

Maintenance Plan Job running at additional unscheduled times?

I have a situation that has left me really scratching my head. This is a SQL Server 2008r2 instance, used as the database server for a substantial corporate SharePoint service. As my company is ...
2
votes
2answers
87 views

SQL service does *not* start, port 1433 in use

Sorry to raise if this has been asked before. The SQL Server service is defined as manual, whenever I start it I get (event viewer): > Server TCP provider failed to listen on [ 'any' 1433]. Tcp ...
2
votes
1answer
40 views

Do SQL Server Views update their data types automatically based on what tables feed them?

Someone mistakenly created a bunch of nchar fields in database tables. I noticed this, and after examining the issue, we're moving these fields to nvarchar types and trimming the values inside. In my ...
3
votes
1answer
82 views

Inserting a 30 million row table from a linked server

I have a large table that needs to be updated on a nightly basis from a linked server. Initially I had simply truncated the table and inserted all of the records but this was taking too long. I'm ...
3
votes
1answer
166 views

Three Node Cluster that Allows For Two Failures

We are creating a three-node three-instance cluster with SQL 2008 R2 (not cutting edge, but that is what the application supports) and think it should be able to maintain quorum with two physical ...
2
votes
2answers
63 views

How to Log Debug Information About a Stored Procedure

We have a group of fairly complex stored procedures that process a transaction queue on a pretty much round the clock schedule. Currently these scripts use a number of print statements to document ...
2
votes
1answer
28 views

Database Backup from 2008 R2, Restore on 2012 Failover Cluster Instance

I have a production database server having sql server 2008r2. This is an old server and considering our load, we are moving to a better hardware configuration, Now the new environment is a cluster ...
1
vote
1answer
62 views

GETDATE() uniqueness when used on INSERT

Recently I was reading this blog post: http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx which contains this section: Picking a Clustered Index There are a couple of ...
4
votes
3answers
432 views

Displaying the list of all tables in all database

How can I display a list containing all the tables of all the database in a SQL Server 2008 R2 server?
-1
votes
0answers
42 views

Concurrent queries hang - update using with nolock

We have a complex "person-status" view (with unions, left joins, many tables) and we're caching its values into the main "person" table. Here is a vast simplification of it: update person set status ...
1
vote
1answer
51 views

Find the SQL query that caused an event in the past

I have a database in which I noticed that one of my tables is missing. I haven't used this database for over three months and now I want to find out who caused this, when this happened, how it ...
0
votes
0answers
64 views

Comparing CLR Functions in Visual Studio SSDT

I'm comparing the CLR functions from a pair of SSDT projects to a database. The only difference shown in the comparison is on two properties: IsDeterministic and DataAccess The compare shows that the ...
13
votes
3answers
247 views

When to use CDC to track history?

SQL Server Change Data Capture is a feature that reads historical data from the SQL Server transaction logs and stores them in a special table. Through the use of special table value functions (TVF) ...
1
vote
1answer
72 views

How to aggregate pairs of id values into groups

I have a table with two id columns id1 and id2. Each row shows that 2 id values have been linked together. My actual data has both id columns as varchar(20) but I have used integers in the example ...
1
vote
3answers
51 views

What are the risks of copying MDF/LDF files without detaching the DB first?

Where DB backups are not available, our support team has been trained to restore using the following steps: Get a copy of the MDF/LDF from a file system backup. Stop the instance. Overwrite the ...
1
vote
1answer
15 views

Delayed availability of historical data when using CDC

I am using the SQL Change Data Capture feature to retrieve historical data from my tables. During testing, I noticed that when I insert/update a row and query the change data right afterwards (see my ...
-2
votes
0answers
31 views

log shipping backup job getting failed frequently

Even i am facing similar issue some of the log backups are getting failed for the same reason stated above the first possibility that came to my mind was the same it could have been a network issue or ...
0
votes
0answers
30 views

SQL Server consistency I/O base error

I have received this error while performing queries on a database (SQL Server 2012) msg 824, level 24, state 2, line 1 sql server detected a logical consistency-based i/o error. Incorrect page ID ...
0
votes
1answer
26 views

How to retrieve the Capture Instance for a given table?

Working with SQL Server 2012, I have a hierarchical table layout (TPT). All tables "inherit" from the same base table (dbo.DataObjects). All tables have history tracking via CDC enabled. I am trying ...
0
votes
0answers
36 views

SSIS and Script Component - WebReference problem

Within my SSIS package-dataflow I have a script component and within this component whenever I add a Web reference and close editor, script component gives me "Validation error. Data Flow Task ...
-1
votes
2answers
59 views

Create Table Script in SQL Server 2008 R2

When I created a table script, SQL Server generates this line in every script. What is the purpose of that line in SQL Server 2008 R2? Thanks. PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ...
1
vote
0answers
33 views

How to do partition on a non clustered index column?

I have table ORDERS .Where there are Million rows in it .I need to add Pationed Index on Order to store data in one of two files based on the new IsLocked field.But when i checked table there is a Non ...
2
votes
3answers
34 views

Steps after restoring to a different server

We have a 30 GB Database on SQL Server 2008 R2 Standard Edition. Yesterday we backed up the database and restored it to a different Virtual Machine which has exactly the same specs as the previous ...
0
votes
3answers
45 views

Can we restrict the number of connections to a database in SQL Server?

I have a database on SQL Server. My web application contacts this database. Is there a way in which I can restrict the number of connections to this database through some settings on the SQL Server?
0
votes
0answers
44 views

Help with SQL Server Error “ad Hoc access to OLE DB Provider 'Microsoft.ACE.OLEDB.12.0'”

So we have an interesting issue where users are receiving the following error when attempting to query a view in SQL Server 2008 R2: Msg 7415, Level 16, State 1, Line 1 Ad hoc access to OLE DB ...
1
vote
1answer
76 views

Purpose of Nonclustered indexes in SQL Server 2012

(New to SQL Server) I am struggling to understand purpose of Nonclustered indexes in SQL Server. Read though MS documentation (both for v2012 and v2008 that has pretty pictures) and some online ...
0
votes
1answer
26 views

Cannot access Properties page of a database

I'm in the process of decommissioning a database server and migrating the databases from one server to another. I was attempting to get the the properties of the database and received a SQL Error ...
0
votes
0answers
21 views

Database migrated to SQL Server 2005 with 80 compatibiltiy from SQL Server 2000 experiencing locks

I am supporting an application whose code my company did not write, and was originally developed back in 2000-2002, by a company that no longer exists. The code, while not great to maintain, ...
0
votes
4answers
87 views

SQL Where Clause Efficiency

Say I have a SQL statement: SELECT * FROM MyTable WHERE KeyColumn1 = 1 OR KeyColumn1 = 2 OR KeyColumn1 =3 OR ... KeyColumn1 = 10 And another: SELECT * FROM MyTable ...
1
vote
1answer
67 views

SQL Server - Service User Accounts and Licensing?

Maybe this is the wrong place to post, since its not necessarily sql server related, but here goes. If I want to setup some service user accounts in the domain to use to run sql services like the sql ...
3
votes
2answers
139 views

Find which session is holding which temporary table

We have a SQL Server 2005 database the temp database has become full. By going into SQL Server Management Studio I can see all the temporary tables in the tempdb. Is it possible to tell which session ...
0
votes
1answer
36 views

Nightly reload of tables from a linked server

I have a number of tables that need to be reloaded nightly from a linked server. My current method of doing this is to create a nightly job to pull the data using something like the following: ...
1
vote
1answer
92 views

Is there anyway to make this stored procedure thread safe?

I have a stored procedure that deletes X rows. This procedure is called by a Job Scheduler (Not SQL Server Agent) from one of three Azure Instances. The deletion task is run every 30 minutes from each ...
1
vote
1answer
47 views

sqlsrvr.exe is not using all memory

I have no clue what to set up more. I tried a lot. My Problem is that on my test Server everything is runing perfectly see but on my production Server its not! see I found this on my ...
2
votes
1answer
55 views

Clustered index additional storage

Reading some books I found that clustered index not require additional disk space for storing index data, because leaf level of clustered index are data itself. But, as clustered index is organized ...
1
vote
3answers
159 views

How can I change the names of all tables to uppercase?

User created one database, for example TestDb. Within this database the user created 30 tables, with the table name in lower case letters (Eg:Employee). Is it possible to change the tables names to ...
0
votes
1answer
33 views

How to store chains of information?

I am currently trying to design a table structure that can capture report data (from various sources) in an ordered fashion. Let me give you an example: Each day I receive three separate reports ...
0
votes
0answers
68 views

Why has the backup time significantly increased?

I'm using Sql Server 2012. The problem is that the backup takes about twenty minutes now, whereas only a few days ago it took a matter of seconds. The database has increased by about a sixth since ...
1
vote
1answer
61 views

Move SQL Server XML column to a new table - slow performance

I have a table with a XML Column, each XML document size is 15kb and I have like 2 million rows. I need to move this XML column into a new table. I tried: insert into newtable select xmlcolumn ...
3
votes
2answers
111 views

Enhance performance of update query

I have a query that is running against a table with 50 million rows. The phone number is stored as a CHAR(10) and an ETL process is changing the phone number if it has certain values. We are seeing ...
0
votes
1answer
25 views

SQL Server - creating a historical data backup

I've run out of space on my SQL Server 2008 Express DB. i'm creating a "duplicate" SQL Server 2008 Express DB so i can backup my data before i purge my DB so i can start over. Is there a way in SQL ...
1
vote
1answer
64 views

Create USER and LOGIN permissions

What permission should I give to a user or role so that it can Create Login or Create User in database.
1
vote
1answer
167 views

Delete log to increase DB space?

I'm running SQL Server 2008 Express and hitting the 4GB size wall. I'd like to make some space to give me time before i migrate to a larger DB. I don't need my transaction log. So, can i delete ...
1
vote
1answer
73 views

Take database backup of a SQL server 2012 from local SQL Server 2008 R2

I have a SQL Server 2012 installation that has some issues with SQL Server Agent because of which I cannot schedule a job or a maintenance plan to take backup. What I am trying to do is to create a ...
1
vote
2answers
74 views

Assign maximum memory limit for a particular database in sql server

In my SQL-Server instance, there are many databases. I want to restrict the memory size of each database (for example 8 GB). When I tried using Resource Governor, there are options like ...
0
votes
2answers
93 views

SQL server 2008 Express x64 in windows 8.1 fail [duplicate]

I've been download sql server express x64 version in this I just install new windows 8.1 x64 vl version and install trial KIS for anti-virus. After i install sql server but it's not working and ...
0
votes
1answer
34 views

SSRS ReportServer_XXX.log is giving incorrect CPU count

I am currently investigating an issue wherein sometimes the SSRS just suddenly stops accepting requests until we do an IISRESET command. This happens after we added an additional processor on the ...
3
votes
2answers
48 views

SQL Server Master Data Services database history by snapshots

I'm involved in a project where there is SQL Server 2012 Master Data Services used. There's a requirement to save a version of the database contents in certain point of time, say, every month or a ...
1
vote
0answers
44 views

Need advice to improve current RDS

Currently I am running a m3.medium SQL Server RDS(20GB storage without IOPS). CPU utilization is under 50% for most of the time(~90%). However, during peak hours(~10%) CPU utilization will hit 100% ...