Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.
2018-05-24
3,084 reads
This script will give you a thorough report about sql server jobs based on historical data.
2017-07-26 (first published: 2013-09-25)
2,138 reads
2005-04-06
You need to put everything inside a string, including the cursor stuff and execute this. See http://www.sommarskog.se/dynamic_sql.html May I add that dynamic sql + a cursor + a UDF are very likely to kill performance. Also, master.dbo.spt_values isn't fully documented. You'd better use your own number table.
2005-02-07
I hope this helps you CREATE PROCEDURE GetFacilities @userID NVARCHAR(100), @language NVARCHAR(100) AS DECLARE @sql_str VARCHAR(1000) SET @sql_str = 'SELECT Name, (SELECT ' + @language + ' FROM lkpfacilitytype WHERE ID = Type) AS Type, Address1, Address2, City, State, ZIP, Country, Phone, Fax, WebSite FROM tblFacilities WHERE userID = ''' + @userID + '''' EXEC (@sql_str) GO […]
2004-02-28
2004-02-25
By Steve Jones
A customer was having some trouble getting started with Azure DevOps (AzDO) and building...
By Rob Sewell
In this post, we share the strategies and techniques we've implemented to ensure our...
By Steve Jones
I had a customer that was concerned about the fragmentation alert for indexes and...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers