Skip to content

SQL Padawan

"The force is strong with this one"

  • About
  • MSSQLTips
  • Repository

Tag: tsql

November 16, 2019 database / How to / monitoring / script / sql server / tsql

Find out when/who dropped an object without auditing

If your environment doesn’t have any kind of auditing and you need to find since when an object was dropped.

Continue reading

November 26, 2018 migration / sql server / tools / tsql

T-SQL script to get detailed login permissions

This script is very helpful when you need to know all the permissions a user have in detail.  

September 23, 2018 best practices / database / How to / sets / sql server / transaction log / tsql

Method to update LOB data with minimal log

Use the .WRITE (expression, @Offset,@Length) clause to perform a partial or full update of varchar(max), nvarchar(max), and varbinary(max) data types. For example, a partial update of

Continue reading

August 4, 2018 database / linux / SQL Operations Studio / sql server / tools

Using SQL Operations Studio Agent

SQL Operations Studio Agent is visual way to see, edit and create SQL Server jobs and everybody was asking this

Continue reading

  • LinkedIn
  • Twitter
  • Skype
  • Email
  • GitHub
  • YouTube
  • Facebook
My Tweets
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Nov    

Translate

azure b-tree backup best practices checkpoint configuration database DMV How to index job linux locks migration monitoring powershell replication script sets SQL Operations Studio sql server statistics storage tempdb tools transaction log tsql undocumented wait
Blog at WordPress.com.