Get dbid from sys.dm_exec_sql_text for ad hoc sql?
Jun 3, 2012 · I am passing a sql_handle from sys.dm_exec_query_stats to sys.dm_exec_sql_text, to get the dbid, objectid and statement text.
SQL Server 2014 Developer licensing - social.msdn.microsoft.com
Feb 11, 2016 · If I google for 'SQL Server Developer edition' I can find it is selling for $50-60. What am I getting? Is it license for 1 user? If I want to give developer SQL Server Developer …
SQL Server slow after rebooting windows server
May 27, 2020 · The software connecting to the SQL server gets very slow and every transaction has a delay for like 0.5 sec which is bad. Now, when I log onto Windows Server 2019 and …
SQL 2008 R2 SP1 : Crashing On Linked Server Query
Nov 11, 2011 · Author of Troubleshooting SQL Server: A Guide for Accidental DBAs Feel free to contact me through My Blog or Twitter. Become a SQLskills Insider! Please click the Mark as …
Managed Identity for SQL Server / Synapse
Apr 17, 2020 · I missed the step to register the SQL Server in the AD, but with your documentation I got it working. I wrote a little blogpost with all steps in detail: https://microsoft …
how sql server scheduler works, can it use all assigned cores smartly?
Wednesday, November 1, 2017 10:32 PM 0 Sign in to vote further investigation: select * from sys.dm_os_schedulers where status = 'VISIBLE ONLINE', I can see only first 4 cores runnable …
How to take backUp in SQL Server when windows in running only …
Oct 13, 2021 · Since the Windows can only run in safe mode, I think we can copy the database files (“.mdf” & ".ldf”) to another partition or removable disk directly. Then we reinstall the …
SQL Data Sync require GUID/UUID for primary key field?
Feb 5, 2018 · I want to use SQL Data Sync to perform bi-directional syncing of data between an Azure SQL database and an SQL database hosted elsewhere. For this to work, do the primary …
How to implement EF in business layer
Oct 15, 2021 · tell me how to implement EF in business layer and we just call business layer from UI main layer and business layer will access EF to interact with data.
Logic Apps - SQL connector - deadlocks
Sep 5, 2019 · I'm using the SQL connector in my logic apps and I often get deadlocks (1 of 5 logicapps execution fails).