Top "Sql-server-2012" questions

Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.

Date time conversion from timezone to timezone in sql server

I having an column of UNIX time stamp in my database table, which comes from a system that is in …

timezone sql-server-2012 unix-timestamp
Sequence vs identity

SQL Server 2012 introduced Sequence as a new feature, same as in Oracle and Postgres. Where sequences are preferred over identities? …

sql sql-server tsql sql-server-2012
what is logical reads in sql server? how to reduce no of logical?

After doing my research, on how to speed up queries executed in SQL server, the majority of resources suggesting to …

sql sql-server-2012 logical-reads
Getting total row count from OFFSET / FETCH NEXT

So, I've got a function that returns a number of records that I want to implement paging for on my …

performance paging sql-server-2012
Identity column value suddenly jumps to 1001 in sql server

I am using Sql server 2012(Denali). I wonder why all identity column values start from 1001 and so on. At the …

sql sql-server sql-server-2012
SQL Server Management Studio 2012 hangs

When I click on the "Databases" node in "Object Explorer" it just keeps on "Loading items" until at some point …

sql ssms sql-server-2012
How do I create a new user in SQL Server 2012 that I can use in a connection string?

I wasn't sure if this was a SO or SU question. I have freshly installed SQL Server 2012. I have created …

sql-server-2012
Restore a SQL Server 2000 backup on SQL Server 2012

I have got following error message while restoring a backup from SQL Server 2000 to the latest version. I do not …

sql-server sql-server-2000 sql-server-2012
Project consistency check failed. has a different ProtectionLevel than the project

I have this annoying problem where it says that the project and package have different protectionlevels. Which is not true, …

ssis sql-server-2012
How do I find running Traces in SQL Server?

Is there an easy way to determine what traces have been set up by sp_trace_create on SQL Server 2000? …

sql-server sql-server-2008 sql-server-2005 sql-server-2012 sql-server-2017