Display SQL services information
This Script is used to display the SQL and windows services information
by using the Windows Management Instrumentation Command-line (WMIC),
2008-11-11 (first published: 2008-09-20)
1,360 reads
Ganesh Pittala
2008-09-03
209 reads
Find the port no Get Port SQL Server 2000
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
2008-08-09
945 reads
Blogs
Truncating very large transaction log in full recovery mode
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
Autonomous Driving Around London
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
Best way to monitor high worker thread on SQL Server
It is common to see high worker count issue on the production server and...
Forums
Is TemporalTable SysStartTime available before performing an insert/Update?
I want to align a Date column (datetime2(7)) with the same full resolution date...
multiple PAGELATCH_UP waits on data file
Hi Experts, What is meant by PAGELATCH_UP waittype ? what does it trying to...
dynamic update to SP
Looking for suggestions\examples of how to update a SP that the table used changes...
Ask SSC