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 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 …
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 …
flatfile as datasource in ssrs - social.msdn.microsoft.com
Dec 14, 2012 · hi - Can I use flatfile as datasource for My SSRS reports. please guide me how can i achieve it.
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 …
How to insert GUID type value into uniqueidentifier field in SQL …
Oct 7, 2021 · Hi, I am workining in vb.net and sql. In DB have a uniqueidentifier field and want to insert in it, When try to send data, some thing parameter: ByVal value as GUID In the query : …
Doubt on SQL serverv 2012 installation - social.msdn.microsoft.com
Oct 12, 2021 · Reporting Services – Native, SQL Server Data Tools and Client Tools Connectivity. If you configure the SharePoint mode in SSRS Server, then you need to install …
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).
Installing SQL Server 2012 alongside existing SQL Server 2008
Mar 26, 2012 · I have an existing SQL Server 2008 machine running on Windows Server 2008 R2. Can I install SQL 2012 on that machine as well without performing an upgrade?