See the Introducing SQL Server Express Local DB Runtime presentation – gives a great overview. The huge benefit of LocalDB is that it’s real SQL Server – it’s a special version of SQL Server Express, but it basically supports everything that “real” SQL Server has – spatial data types, stored procedures – you name it. … Read more
Will OPTION(OPTIMIZE FOR UNKNOWN) reuse cache instead of recompiling each time? Yes, it will. There are two main differences between OPTION(OPTIMIZE FOR UNKNOWN) and OPTION(RECOMPILE) as can be seen from this quote from MSDN: OPTIMIZE FOR UNKNOWN Instructs the query optimizer to use statistical data instead of the initial values for all local variables when … Read more
If we’re allowed to change the contract, you can have: SELECT CSTNO, CSTABBR,COUNT(*) OVER () as TotalCount FROM DBATABC WHERE CSTABBR LIKE ‘A%’ ORDER BY CSTNO OFFSET ( @OffSetRowNo-1 ) * @FetchRowNo ROWS FETCH NEXT @FetchRowNo ROWS ONLY And now the total will be available as a separate column in the result set. Unfortunately, there’s … Read more
SQL Server is following the ANSI/ISO standard for string comparison. The article How SQL Server Compares Strings with Trailing Spaces explains this in detail. SQL Server follows the ANSI/ISO SQL-92 specification… on how to compare strings with spaces. The ANSI standard requires padding for the character strings used in comparisons so that their lengths match … Read more
You can (should) use CROSS JOIN. Following query will be equivalent to yours: SELECT table1.columnA , table2.columnA FROM table1 CROSS JOIN table2 WHERE table1.columnA = ‘Some value’ or you can even use INNER JOIN with some always true conditon: FROM table1 INNER JOIN table2 ON 1=1
if you are trying to Clone your database on the same server try this: Create a backup of the database you want to copy right-click on Databases and select Restore Database Select the database you want to copy from the From Database drop-down list in the Source for restore section Enter the name of the … Read more
A bit later response but may help. In SQL 2016 MS introduced function DATEDIFF_BIG which will (according to type size) overflow in difference bigger than something like 290k years. But technet article have same time difference as basic DATEDIFF – https://msdn.microsoft.com/en-us/library/mt628058.aspx
OK, from an application developer’s point of view, here’s what these settings do: QUOTED_IDENTIFIER This setting controls how quotation marks “..” are interpreted by the SQL compiler. When QUOTED_IDENTIFIER is ON then quotes are treated like brackets ([…]) and can be used to quote SQL object names like table names, column names, etc. When it … Read more
This is what you need: Select e.EmpName, e.Address, s.Name, S.Address, s.Project From tbEmployees e JOIN tbSupervisor s on e.id = SupervisorID You can read about this on W3Schools for more info.
You can use sp_lock (and sp_lock2), but in SQL Server 2005 onwards this is being deprecated in favour of querying sys.dm_tran_locks: select object_name(p.object_id) as TableName, resource_type, resource_description from sys.dm_tran_locks l join sys.partitions p on l.resource_associated_entity_id = p.hobt_id