SQL Server: test queries without cache
DBCC DROPCLEANBUFFERS; SELECT * FROM TABLE_X …DBCC DROPCLEANBUFFERS; SELECT * FROM TABLE_X … More info
Category: SQL Server
SQLCMD.exe
sqlcmd -d db_name -Q ‘select * from table_name’ -Wsqlcmd -d db_name -Q ‘select * from table_name’ -W
Random 4-digit number
select substring(cast(abs(CAST(CHECKSUM(NEWID()) AS bigint)) as varchar),1,4);
SQL Server: Numer portu
Wykonanie poniższego zapytania powinno zwrócić numery portów, na których nasłuchuje SQL Server. USE master GO xp_readerrorlog 0, 1, N’Server is listening on’, ‘any’, NULL, NULL, N’asc’ GOUSE master GO xp_readerrorlog 0, 1, N’Server is listening on’, ‘any’, NULL, NULL, N’asc’ GO