Search Results

Looks like a bug in SQL Server Management Objects (SMO). You can track the issue here.

What is best practice for changing the compatibility level - before or after the SP2 and cumulative updates are installed? SQL Server 2016 SP1 is out-of-support so you should upgrade to supported se …

Any idea how can I change LicenseType of SQL Server? Since licenses are assigned to servers externally, you can switch which licenses are assigned to which servers any time you want, subject to t …

From looking at a Profiler trace of the SSMS dialog opening the queries are essentially: Size: SELECT sum(df.size) * 8 / 1024.0 Size_MB FROM sys.database_files df; and Space Available: with q as …

Using three-part names in queries that reference objects in the current database is a terrible practice and you should create a rule against it. The most frequent problem with it is that it prevents …

I am a newbie to SQL and I came across a situation where I have to use save transaction Savepoints are rarely used (or useful) and it's unusual that "a newbie" would "have to use save transaction …

What is more efficient, using one scalar variable as in the previous example or using IF sentences and create specific queries as in the example below? In SQL Server a query plan may not vary bas …

The trigger is not being recreated. sql_text in sys.db_exec_requests is at the batch level, not the query level. See eg https://blogs.msdn.microsoft.com/dbrowne/2013/01/18/my-favorite-query-for-inv …

A database backup contains the allocated extents plus the parts of the log required to replay any activity that occurred during the backup, and restore the database to the point-in-time at which the b …

Seems like I need to do this to both tables at the same time Correct. If you try to recreate the FK after migrating one table you will get: Msg 10778, Level 16, State 0, Line 20 Foreign key re …

Another common design here it to make the ordering column a float. Then you can always insert new rows before, after, or between the existing rows.

This is the essence of what it means to be a system_versioning temporal table. You cannot control the row start and row end values. If you want the rows to be deleted after 5 days, you'll have to ha …

SQLSRV32.DLL is the old SQL Server ODBC driver that's part of Windows. In October 2020, Windows finally dusted off the source code for the built-in ODBC and OleDb SQL Server drivers and updated them t …

How can exactly know the expiration date? You've found it. It is expired, and out-of compliance. It will stop working soon. There should be no need to wipe and reinstall SQL Server. Y …

If you can run a SELECT query against a table that another session has X locks on in Read Committed isolation, you must be in a database with READ_COMMITTED_SNAPSHOT set. With READ_COMMITTED_SNAPSH …