sqldbachronicles.blogspot.com
SQL DBA Chronicles: 01/01/2012 - 02/01/2012
http://sqldbachronicles.blogspot.com/2012_01_01_archive.html
Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 11 January 2012. SQL Server 2005 - List all stored procedures in a database. Run the following script on SQL Server 2005 to retrieve all stored procedure in a database. Subscribe to: Posts (Atom). Wwwcodesnout.com - SQL Tutorial. Wwwautosnout.com - Car Performance Statistics. View my complete profile. Simple template. Powered by Blogger.
sqldbachronicles.blogspot.com
SQL DBA Chronicles: 01/01/2015 - 02/01/2015
http://sqldbachronicles.blogspot.com/2015_01_01_archive.html
Help, Hints and Tips learnt along the way as a SQL DBA. Thursday, 15 January 2015. SQL RAP - RPC server is unavailable 0x800706ba failed to create logman. Whilst taking part in a Microsoft SQL RAP using the RAP as a Service Client I stumbled upon the following error whilst trying to gather data from a remote server on our domain. RPC server is unavailable 0x800706ba failed to create logman. The 'Target' server was an MS Windows Server 2008 R2 with the data collector server residing in MS Windows 2012.
sqldbachronicles.blogspot.com
SQL DBA Chronicles: 09/01/2012 - 10/01/2012
http://sqldbachronicles.blogspot.com/2012_09_01_archive.html
Help, Hints and Tips learnt along the way as a SQL DBA. Monday, 10 September 2012. SQL Server Agent Jobs List. To get a list of SQL Server agent jobs by category execute the following query:. SELECT j.[job id], j.[name] [job name], j.[category id], c.name [category name]. FROM [msdb].[dbo].[sysjobs] j. JOIN [msdb].[dbo].[syscategories] c. ON jcategory id = c.category id. Subscribe to: Posts (Atom). Wwwcodesnout.com - SQL Tutorial. Wwwautosnout.com - Car Performance Statistics. View my complete profile.
sqldbachronicles.blogspot.com
SQL DBA Chronicles: 07/01/2011 - 08/01/2011
http://sqldbachronicles.blogspot.com/2011_07_01_archive.html
Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 27 July 2011. SQL Server 2008 - Find current sessions using DMV - sys.dm exec sessions. If you need to find out who currently has an open session on your server via T-SQL in SQL Server 2008 you can use the 'Dynamic Management View'; sys. Example code for sys. The WHERE clause ensures that system processes are either included or omitted. Dm exec sessions r. Eturns one row per authenticated session on SQL Server. Where is user process = 1.
sqldbachronicles.blogspot.com
SQL DBA Chronicles: 06/01/2011 - 07/01/2011
http://sqldbachronicles.blogspot.com/2011_06_01_archive.html
Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 29 June 2011. DBCC SHOWCONTIG - Key values indicating fragmentation. This blog shows you which key values to look for in the results of DBCC SHOWCONTIG. DBCC SHOWCONTIG : Viewing fragmentation data. Use DBCC SHOWCONTIG to view how much fragmentation an index has. Use the TABLERESULTS options to get extra columns in the output that describe statistics about the index. When looking at the results of DBCC SHOWCONTIG you should concentrate.
yorkraceway.org.uk
York Raceway - York Raceway Home Page
http://yorkraceway.org.uk/links.html
Custom polishing and chroming services. Sniff out your favourite autos of all time. Wild Bunch racer and organiser Crazy Chris's slingshot dragster. Big Pete Monster Truck. The biggest monster truck in Europe. Billadeau Speed and Automotive. North Yorkshire's guide to the modified car scene. News, reports, etc. Drag Rod and Classic Review. Drag cars, hot rods, classic cars. Engine Data Analysis (EDA). Performance engine builders, tuning and dyno testing. Roger Goring's jet-powered Funny Car. Regular race...
astore.amazon.co.uk
AutoSnout Shop - Car Books - All
http://astore.amazon.co.uk/auto036-21
Car Books - All. There are no products available for display here. Car Books - All. Car Books - Classic Cars. Car Books - Exotica. Car Books - Ferrari. Car Books - Muscle Cars. Car Books - Performance. Car DVDs - All. Car DVDs - Crashes. Car DVDs - F1. Car DVDs - Muscle Cars. Car DVDs - Rally. Car Electronics - All. Car Electronics - Audio. Car Electronics - Video. Car Books - All. Car Books - Classic Cars. Car Books - Exotica. Car Books - Ferrari. Car Books - Muscle Cars. Car Books - Performance.
sqldbachronicles.blogspot.com
SQL DBA Chronicles: 05/01/2015 - 06/01/2015
http://sqldbachronicles.blogspot.com/2015_05_01_archive.html
Help, Hints and Tips learnt along the way as a SQL DBA. Monday, 18 May 2015. WSS Logging Sharepoint Database Size Reduction. Has your Sharepoint WSS Logging database grown massive. See the links below on how to shrink the size of the WSS Logging database. Https:/ guidesharepoint.wordpress.com/2014/03/03/how-to-reduce-the-size-of-logging-database-and-how-to-purge-the-old-data-from-logging-database/. If you need to shrink the database after you have changed the Sharepoint retention settings:. Simple templa...
sqldbachronicles.blogspot.com
SQL DBA Chronicles: 06/01/2013 - 07/01/2013
http://sqldbachronicles.blogspot.com/2013_06_01_archive.html
Help, Hints and Tips learnt along the way as a SQL DBA. Wednesday, 26 June 2013. Where is 'Performance and Reliability Monitor'. Where is 'Performance and Reliability Monitor'. Have you got Windows Server 2008 R2 or Windows 7 and wondering where the 'Performance and Reliability Monitor' option has gone. Well, the tool has been upgraded and is now called 'Windows Resource Monitor.'. Where is this fabled creature called 'Windows Resource Monitor'? You'll find it here:. Windows 7 and Windows Server 2008 R2.