Single T-SQL query to suspend data movement on all alwayson …
Feb 12, 2016 · Hi, In my sql server i have 80 databases. It is very difficult to suspend data movement and resume data movement at everytime. Please give me a single sql query to …
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 …
Query to pull SSRS parameter properties (Hidden, Visible, Internal)
Aug 14, 2019 · Within the Report Server database, the table dbo.Catalog stores all reports along with their properties and parameters. The content within the Parameter column are XML, so …
T-SQL query to find database information on all servers
Nov 9, 2017 · Or whatever client language you prefer. You will need to query database per database, server per server, since the information is stored per database. It's also better to …
Log_reuse_wait_desc = ACTIVE_TRANSACTION
Jan 27, 2020 · I've a database log that keeps filling up (log is 250GB), select log_reuse_wait_desc from sys.databases says that the log can't be reused because of "active_transacion".
enable service broker in operations manager
Nov 26, 2010 · If the result returns 0, doing the following steps to enable SQL broker: 1> Run the query: ALTER DATABASE OperationsManager SET SINGLE_USER WITH ROLLBACK …
Query refactoring in SQL server - social.msdn.microsoft.com
Jun 13, 2013 · Just as others post above, in SQL Server, the SQL Server Database Engine query optimizer complie the Transact-SQL query into a query plan. Then the plan is executed to …
How do I use LINQ to sort items using a variable "sort-ordering ...
Mar 5, 2014 · I had to write a dynamic query to query a database table based on selections made by the UI user on the criteria given. I chose to use Entity SQL to dynamically do it. You can do …
Normally fast EF LINQ query suddenly starts timing out - works …
Feb 4, 2016 · Here is an odd one. We have a website application using EntityFramework to connect to an MS SQL Server database (SQL2010). We recently ran into a case where a …
how to query individual database startup time
Nov 20, 2012 · When SQL Server "opens" a database, resources are assigned to maintaining that state. Memory for locks, buffers, security tokens and so on is assigned, and there is …