Tagged Questions

Microsoft SQL Server is a relational database management system. Use this tag for all SQL Server editions including Compact, Express, Azure, Fast-track and PDW. Do not use this tag for other types of DBMS (MySQL, PostgreSQL, etc.).

I wrote a small application with entity Framework 6 model first Approach and SQL Server Express 2012
It worked well the last 6 month. Today, I deployed an update of the application with new Features, ...

I have database projects in Visual Studio 2013 from which I deploying databases to SQL Server. Also I am using Transparent Data Encryption for these databases and it is in state 3 which means TDE is ...

Often we come across some small insignificant (debatable) tables left out as stand alone. Although they are used in joins (sparingly) but still developers don't bother to relate them.
May be too many ...

I have a table that is 13 TB big (due to historical reasons).
I want to reload the data because I have corrupt and duplicate data in that table.
The question is what is the fastest way to load data ...

I was using a temp table variable in my stored procedure and was doing some insertion into temp table from another temp table with order by clause. It was working in SQL Server 2008. Order by clause ...

I will describe a problem using a specific scenario:
Imagine that you create a website towhich users can register,
and after they register, then can send Private Messages to each other.
This website ...

I have a table that effectively implements a cache - we put stuff in, we take stuff out. It has a last_accessed field that indicates when it was inserted or read, and it has a max_age field indicating ...

I have a simple query that is generated från Entity Framework that takes about 55 seconds to complete in an .NET application. When I run the query in SSMS with the same parameters it runs in about 4 ...

Today I had to "upgrade" my project from the Default inProc to a SQLServer session state. As i completed the transition one of the methods in my code stopped working properly. Its a method that calls ...

I'm improving a software where it is possible to create a database, whereby you can define the entities and the properties of the entities, and is translated to SQL queries in order to create/update ...

In SQL Server 2008-2012, objects (including tables) are first put in a mixed extent. An extent can accommodate up to 8 pages and accommodates more than one type of page (meaning: pages from more than ...

I am trying to implement a two phase commit on heterogeneous environments. AS400 (DB2) and windows (SQL Server) to be precise. I am looking to find someone who has already implemented such a thing (a ...

I'm trying to group the results by time intervals (hourly) I cannot for the life of me figure this out. I need the experts to help me, can anyone see where I'm going wrong?
DECLARE @IntervalMinutes ...

I should start by saying that I am fairly new to SQL and databases. I read a lot and I have narrowed down my db design and questions. I will now try to explain.
So I am trying to build the 'typical' ...

Has anyone managed to get a linked server working between SQL 2008R2 and Sybase ASE 15.7 using the SAP/Sybase OLE DB driver and not using an ODBC DSN?
I've tried what seems like every combination of ...

I have a database and a set of stored procedures. I want to use only stored procedures to access database. In model browser's function import I can create new complex type based on stored procedure ...