ZealUps
Menu Close
  • Home

Microsoft SQL

0

Include Metadata in DB Objects

Posted on February 23, 2017 by shiljo

In case if you want to include extended properties to the database objects you can use sp_addextendedproperty of SQL Server. Which comes handy incase if you want to include Description for a column/table/any db objects. Suppose if I have table… Continue Reading →

Programming Microsoft SQL, SQL
0

How to get recently created & modified DB Objects

Posted on July 4, 2016 by shiljo

If you are software tester or a software developer and if you want to know which objects are recently created or modified then here is the query You can add filters/where conditions if you want specifics example you can include… Continue Reading →

Programming Microsoft SQL, SQL
0

Query to know Process, Connection & Session of a DB

Posted on January 23, 2016 by shiljo
SQL Connections & Sessions

Every supportĀ team may come across once in their career to know about how many connections/sessions are in use. I have compiled the list queries which are specific a database. Microsoft SQL In this sysprocesses is a system table The following… Continue Reading →

Programming Microsoft SQL, Oracle, SQL

Categories

  • Language (2)
  • Mathematics (5)
  • Nutrition (6)
  • Programming (34)
  • Software (2)
  • Travel (1)

Archives

© 2021 ZealUps. All rights reserved.
Hiero by aThemes