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 edition that he/she …
Saving a wav file in sqlsever - social.msdn.microsoft.com
Nov 19, 2005 · Could you please help or guide me to the right direction on my project below? The application I am working on is a database program where I use SQL Server and multiple Windows …
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 Answer button …
How to take backUp in SQL Server when windows in running only in …
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 Windows and …
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 copy that a …
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 tasks, …
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 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).