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

SQL query optmization [closed]

This is one thing I have been trying to read from few days. I am not getting any satisfactory explanation anywhere. Tried surfing some blogs and videos in youtube. Appreciate if anyone one can throw ...
0
votes
3answers
99 views

How to script data in deterministic order

When I script data in my database in SSMS Tasks->Generate Scripts and then select data-only it turns out that the insert statements are generated in different order each time when even a smallest ...
0
votes
1answer
95 views

Rebuild Index in system database

I use SQL Server and have multiple indexes in system database whit index fragmentation 30% or more. I don't know that SQL server manage system database index automatically or I want to manage them. ...
1
vote
2answers
79 views

Known vulnerabilities for when a guest executes a stored procedure on SQL Server

I have a production database with crucial business information. Meanwhile, my company is involved in a project with some other company and we have to exchange some information on a regular basis. How ...
4
votes
1answer
137 views

If user owns a database fixed role are they the admin of the role?

I have SQL Server 2012. When I create a user in "Owned schemas" screen one of the option is fixed database role. If I own a fixed database role: What permissions am I granted? I am the admin of ...
2
votes
2answers
703 views

Where is the list of attached databases stored?

I know database instance names are stored in the registry in subkeys of HKLM:SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL and the path to master.mdf is stored in ...
2
votes
2answers
2k views

Reduce DB size - SQL Server, SSMS

One of my databases was growing in size a few gigs every day. That was very unusual since it is still in development phase. After small research i discovered that the Even Log table was almost the ...
0
votes
1answer
45 views

Who and when were changed Database default location settings?

I need to know when and who changed SQL Server Database default location settings. How can I do that?
2
votes
1answer
49 views

Transaction Log Backups on SQL Server

Running SQL2008 R2 SP2, database is in FULL Mode Is it Possible to shrink the transaction log without putting it into SIMPLE mode? Temporarily cannot take log backus and don't want it to grow until I ...
16
votes
1answer
7k views

GO After every T-SQL statement

What is the reasoning behind using the GO statement after every SQL statement? I understand that GO signals the end of batch and/or allows the reputation of statements but what advantage does it have ...
2
votes
0answers
176 views

Significant PLE Drop

This morning at 4am we experienced a huge drop in Page Life Expectancy on a new sql server 2012 box. No jobs (backup etc) ran at this time and traffic was very light compared to say 20:00. Current ...
0
votes
2answers
60 views

Which one is better way to insert data? [closed]

I have two cases case create proc createEmployee @firstName varchar(255), @lastName varchar(255) = null as insert into Employee_Tbl values (@firstName, @lastName) case create proc ...
2
votes
0answers
127 views

logon trigger to send an email

I want to create a simple login trigger. basically if user = test , then send an email to me. CREATE TRIGGER ServerLogon ON ALL SERVER WITH EXECUTE AS 'test' FOR LOGON AS BEGIN IF ...
3
votes
1answer
694 views

How to pinpoint root cause of excessive log file growth

The log file stays pretty small (~500MB) until about 11PM, and at that point it begins growing until no disk space is available. The log file reached it's maximum size at 12:39AM, so the growth took ...
4
votes
1answer
155 views

How can a connection for one DB block a connection to another DB in SQL Server?

We have an interesting scenario. For weeks, we have been experiencing 'outages' on SQL Server 2008 -- where our websites have slowed to a crawl and mass timeouts for all customers who have DB's ...
0
votes
4answers
1k views

What can cause Reads to slow down on SQL Server 2008R2?

Our primary DB is 15GB in size. The server has 16GB of RAM. We are using the simple recovery model. Lately we've noticed that our custom apps lookups - just basic reads with adhoc SQL statements - ...
4
votes
3answers
419 views

SQL Server- Table partitions on SSD

I have a table in my database that has about 250m rows. I'm new with databases but I have read up about partitioning the table to increase performance. One of the important points that I seem to ...
2
votes
2answers
127 views

SQL Server - Recursive “find all FK connections for ID through the entire DB” query

I'm dealing with a DB with hundreds of tables, with interconnecting FK references producing potentially thousands of different permutations for how for example table A and table K can join together. ...
1
vote
1answer
134 views

What is the purpose of a user's default database?

As I understand it the default database is specified so that in case you don't specify one in the connection string, it will know where to start. Is this correct? I've never seen a connection string ...
0
votes
1answer
7k views

How to convert sql server table data into MS Access(.mdb) file

I have SQL Database table with 6664055 rows, I want to convert this SQL Server table data to MS Access format(.MDB), How Can I do this?
-2
votes
1answer
64 views

What objects can be affected in SQL Server 2012 by a DDL statement [closed]

Are they any objects that could be CREATEd, ALTERed, or DROPped in SQL Server 2012 other than the following list: Tables Stored procedures Views Functions Triggers Indexes P.S. I'm only interested ...
0
votes
0answers
47 views

Table Field to Reference Field in Other Tables

Suppose I want to map a set of input values to database table fields E.g. employeeFirstName --> emp.fName employeeLastName --> emp.lName ... --> ... In theory I can create a ...
5
votes
2answers
687 views

SQL Server 2000 - 'Performance: Deadlock'

We had to restart our SQL Server today, we had made no changes to it. When it came back up we immediately started getting this error from the server DATE/TIME: 2/27/2014 3:09:31 PM ...
4
votes
2answers
167 views

Spatial index not used

I have a table with a geometry column. For one record, there is only one Point stored. A spatial index has been created but queries searching for the nearest location do not use this index resulting ...
3
votes
4answers
2k views

indexing on multiple nvarchar(max) columns

I have multiple nvarchar(max) columns in my DB named ShipperName,ConsigneeName, ProdDesc,BillOFLading. What I need to do is to have UNIQUE INDEX for the combination of these columns. As I am failed ...
0
votes
2answers
74 views

Having DB Mirroring and Replication together

Can anybody help me understand why do one go combination of Database Mirroring + Replication. Why can't I just have Database mirroring for high availability of my database. What is the need of ...
-4
votes
2answers
178 views

Performance with IN clause

Does indexed data affect query performance? means If I passed value as 1,2,3,4... in ordered form in any IN clause, can it improve query performance? and what happen in case I pass value randomly ...
1
vote
1answer
62 views

Backups in Availability Groups

In case of async commit setup and the backup preference set to secondary replica. I have observed, in case of high unsent log size, log backup on secondary replica starts failing for that database ...
1
vote
0answers
247 views

What's is the best way to get incremental changes from production to incrementally changed development database?

I came to a new dev team where all development is on the same (instance) of an SQL Server (2005) database once in 1-2 days restored from a current full backup of production database replacing a dev ...
2
votes
2answers
188 views

Aliased Column name in SQL Server

Sometimes, when developing in a hurry, devs make poor choices on column names. Changing them can be a challenge, having to stage code, and time migration perfectly. I'm told that Oracle has a way ...
8
votes
1answer
269 views

Estimating IO Requirements for Bursty Usage

We have an application that queries a SQL database periodically throughout the day. There are periods of zero or only light activity, interspersed with individual requests for relatively large ...
2
votes
1answer
827 views

SQL server 2012 restore wizard freezes

I have a development laptop with SSMS Express 2012 with a 2012 db instance and a 2008 db instance. Have been using this configuration for over a year. Suddenly I am unable to use the restore ...
12
votes
1answer
590 views

SQL Server 2008 R2 index rebuild fails with severity 17

Occasionally during our index maintenance, the job will fail with a SEV 17 error where enough space can not be allocated for the object it is rebuilding. The database is laid out as such: Data_file1 ...
2
votes
1answer
127 views

Avoiding Deadlocks

We currently have a trigger-based system in place that does the following: When records in certain tables are modified, a trigger fires that makes a field NULL in a varying number of records in ...
2
votes
2answers
88 views

Replication between SQL Server 2005 - 2005

I'm hoping to get some help with a SQL Server 2005 replication issue. In short, in replication monitor, (On the Publisher), on the 'Distributor to Subscriber History' tab, I see two lines under ...
0
votes
1answer
294 views

SQL Server 2008R2 - Stored Procedure with 2 updates causing deadlocks

I have a web api web service that calls an authentication stored procedure. This stored procedure calls a different stored procedure that does 1 update: UPDATE ...
1
vote
1answer
65 views

how determine the best path that satisfies a condition

declare @flat table ( id int not null, percentage int not null, value float not null ) insert into @flat (id, percentage, value) select 1,10,0.333 union all select 1,20,0.4 union all ...
1
vote
0answers
29 views

The @article parameter value must be 'all' for immediate_sync publications

I have a publication of 4 tables and many subscribers (transactional push replication), most of them being interested by one of those 4 tables. Everything is working fine as long as I create the ...
4
votes
1answer
150 views

Drastic performance difference in View Dependencies between SQL Server 2005 and 2008 R2

Background I am a fledgling DBA who was hired in the middle of a migration from SQL Server 2005 x64 to 2008 R2 x64. We also migrated from a local server to a colo virtual server, and moved some of ...
8
votes
1answer
476 views

Re-run a specific actual query plan

I have captured an actual query plan for a specific query. After this I've changed a few things around (including updating the statistics) and re-ran that specific query. Now the actual query plan ...
0
votes
0answers
157 views

How to configure log shipping in SQL Server 2008 R2 Standard Edition

Could you please guide me on how to configure log shipping in SQL Server 2008 R2 Standard Edition for same hostname with two different IP's. (Primary and Secondary server) example: Primary machine ...
2
votes
1answer
48 views

Generate Backup list

I have the query below that returns all databases and full backup history with the last backup date and device name. I am trying to modify the query to only return all the databases and just the last ...
0
votes
0answers
26 views

SQL Server query used new index until this morning [closed]

I created an index yesterday to fix a slow query where it was spilling into TempDB, this worked great and we had the best performance we have seen in a while, till this morning, now the query is using ...
1
vote
4answers
3k views

Check the data latency between two Always On Availability Group servers in ASYNC mode

I have implemented Always on Availability Group in asynchronous mode between two servers primary and secondary. When i tried to check the data latency between the servers in performance monitor ...
2
votes
1answer
918 views

How do you restore a DB to Multi-User mode when deadlocked by a sys process

I have a database that is stuck in Single User mode after a failed restore process. I have checked the sysprocesses table and none of the processes have spid > 50. They are all sa processes. Using the ...
1
vote
1answer
77 views

Partitioning a table state

So far I always used date ranges to partition my tables, however now I like to do it by state or a selected list of cities where all others that are not explicitly listed in an "other" partition, is ...
0
votes
0answers
44 views

Merge data using Integration Service

Please Consider this scenario: I have a table in my database. I want move this data in my OLAP database using SSIS.I can move all record from my table to OLAP database.The problem is I don't know how ...
-3
votes
2answers
1k views

How to calculate the hours worked by all employees in a day? [closed]

vinay_hours id cico 1 2014-02-20 10:31:00.503 1 2014-02-20 13:00:00.503 1 2014-02-20 15:31:02.503 1 2014-02-20 19:00:02.503 2 2014-02-20 10:00:02.503 2 2014-02-20 18:31:02.503 expected ...
0
votes
2answers
3k views

how to store multiple value in column in sql server [closed]

I am creating job post application. In my first table the columns are This is my master table ID Position jobDescription minExp maxExp LastDate InterviewDate Project HiringManager interviewer ...
0
votes
2answers
348 views

How to change the path of data during database restore + SQL Server 2008

I am trying to restore a big database in SQL Server 2008 R2. The database is about 700GB in size. My SQL Server is installed in C drive which has only 100GB of space left in it. I have the .bak file ...