How to configure tempdb alert in SQL server
May 5, 2018 · I need scrpit to configure tempdb database log and data alert reached 50% of restricted size and i want automate. e:g If tempdb log/data file is reached 50 % and i want get …
Union of multiple CTE'S - social.msdn.microsoft.com
Jan 28, 2015 · I need a way to union these 2 result sets. I can't write all 4 concurrently and then select as I would need to uniquely identify elements in each SET A and SET B. One approach …
How to check how many times the plan guide has been …
Oct 27, 2009 · Use SQL Server 2008 profiler trace events Plan Guide Successful and Plan Guide Unsuccessful located under the "Performance" category.
sql server 2008 permissions - social.msdn.microsoft.com
Oct 24, 2012 · I have a question about setting up permissions on a sql server 2008 r2 datbase. I basically wrote and enhanced some C# 2008 and C# 2010 console applications that …
Concatenate nvarchar (max) with nvarchar (max) yields null
Aug 2, 2010 · I tried to concatenate two nvarchar (max) fields but the column came out being null. What is the recommended solution?
Sql query to update Category, Sub Category, Products in a single …
Oct 7, 2021 · Because the query which you have written is the same i wrote. The issue comes while updating product Table. Tuesday, September 17, 2013 5:57 AM 0 Sign in to vote User …
Linq query, comparing execution time in SQL Profiler, same final …
Oct 7, 2021 · The main point is why I´m getting different duration time on SQL Server to run same query. I´m considering data collected by SQL Profiler are pure SQL requests/response, and it …
sql query to see all received message BizTalk 2006 R2
Oct 18, 2010 · You can pretty much copy-paste those queries into a SQL Management Studio and run them agianst the BisTalkDTADb database. Theere is a message facts view and a …
Azure Data Factory to copy Azure Log Analytics query result into …
Feb 18, 2020 · It can be done with the help of Log Analytics REST APIs. You can set up a copy activity with the REST API for your query as the source and with your output as the SQL table.
stored procedure for rebuild indexes - social.msdn.microsoft.com
Oct 11, 2012 · USE [databasename] GO StoredProcedure [dbo]. [sp_RebuildIndexes] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo]. …