Uncategorized

How to find unsaved file location for SQL query in management studio

This is important if we not saved files on disk and SQL management studio close. Un save file location C:\Documents and Settings\<user name>\My Documents\SQL Server Management Studio\Backup Files\Windows Vista/7/10 %USERPROFILE%\Documents\SQL Server Management Studio\Backup Files OR %USERPROFILE%\AppData\Local\Temp Sql Query find using statics Query Recovery Settings There is a setting in Management Studio that allows the Autorecover …

How to find unsaved file location for SQL query in management studio Read More »

T-SQL function

What are function available in SQL Server SQL Server supports these analytic functions: CUME_DIST (Transact-SQL) LEAD (Transact-SQL) FIRST_VALUE (Transact-SQL) PERCENTILE_CONT (Transact-SQL) LAG (Transact-SQL) PERCENTILE_DISC (Transact-SQL) LAST_VALUE (Transact-SQL) PERCENT_RANK (Transact-SQL) Analytic functions calculate an aggregate value based on a group of rows. Unlike aggregate functions, however, analytic functions can return multiple rows for each group. Use …

T-SQL function Read More »

How to work with Registered Servers in SQL Server Management Studio

In SQL Server management studio their is powerful option to easily connect your server or execute query on that server To open register server window Menu -> view -> register servers Or Ctl + Alt + G We can run same query on all server using this feature Ref Link https://docs.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-2017 Please follow and like …

How to work with Registered Servers in SQL Server Management Studio Read More »

error

Enjoy this blog? Please spread the word :)