Contents tagged with sql server
-
Show Query Plan of a Running Query in SQL Server
SELECT QP.query_plan as [Query Plan], ST.text AS [Query Text]FROM sys.dm_exec_requests AS R CROSS APPLY sys.dm_exec_query_plan(R.plan_handle) AS QP CROSS APPLY sys.dm_exec_sql_text(R.plan_ … more
-
Putting a SQL Server Database into Maintenance Mode (Single User)
https://docs.microsoft.com/en-us/sql/relational-databases/databases/set-a-database-to-single-user-mode
http://www.sqlusa.com/bestpractices/singleuser/
-
SQL Server Projects on GitHub
https://desktop.github.com/https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kithttps://github.com/olahallengren/sql-server-maintenance-solutionhttps://github.com/Microsoft/ … more
-
SQL Server SELECT ... INTO Statement Limitations
https://www.red-gate.com/hub/product-learning/sql-prompt/use-selectinto-statement more
-
Remove the IDENTITY property from an existing column
https://www.linkedin.com/pulse/remove-identity-property-from-existing-column-eitan-blumin/ more
-
Five Reasons Why Log Shipping Should Be Used
https://www.procuresql.com/blog/2017/07/18/five-reasons-why-log-shipping-should-be-used/
-
Install OTRS on Windows and SQL Server
http://wiki.otterhub.org/index.php?title=Installation_on_Win2012R2_with_Microsoft_SQL_Server_2014,_IIS_8.5_and_OTRS_4(0.5) more
-
How to create an autonomous transaction in SQL Server 2008
https://blogs.msdn.microsoft.com/sqlprogrammability/2008/08/22/how-to-create-an-autonomous-transaction-in-sql-server-2008/
http://www.sqlines.com/oracle/pragma_autonomous_transaction
http://www.c- … more
-
Workaround: SQL Server 2012 – OPENROWSET on sp_help_job throws "The metadata could not be determined"
https://blogs.msdn.microsoft.com/sqlagent/2012/07/12/workaround-sql-server-2012-openrowset-on-sp_help_job-throws-the-metadata-could-not-be-determined/
https://dba.stackexchange.com/questions/177861/ … more
-
Autonomous Transactions in SQL Server
https://www.dbbest.com/blog/autonomous-transactions-sql-server/
https://stackoverflow.com/questions/45731207/commit-transaction-outside-the-current-transaction-like-autonomous-transaction
-
The target principal name is incorrect. Cannot generate SSPI context
https://blogs.msdn.microsoft.com/meer_alam/2015/05/10/the-target-principal-name-is-incorrect-cannot-generate-sspi-context/ more
-
Importing XML into SQL Server
https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/
https://docs.microsoft.com/en-us/sql/relational-databases/import-export/examples-of- … more
-
The server network address “TCP://SQLServer:5023” can not be reached or does not exist.
The server network address “TCP://SQLServer:5023” can not be reached or does not exist. more
-
How to use REPLACE() within NTEXT columns in SQL Server
select cast(replace(cast(myntext as nvarchar(max)),'find','replace') as ntext)from myntexttable more
-
SQL Server Error: The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON.
/* The solution is: */
USE Master GO ALTER LOGIN MyLogin WITH PASSWORD = 'mypassword' GO ALTER LOGIN MyLogin WITH CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF; more