Nerd Techies

Learn & Share knowledge with nerds

Skip to content
Menu
  • ASP.NET
    • ASP.NET MVC
    • WEB API
  • Testing
    • Selenium
    • Coded UI
    • Load Testing
  • Database
    • SQL Server
    • MongoDB
    • OrientDB
    • Neo4jDB
    • PostgeSQL
    • DocumentDB
  • Azure
  • JavaScript
    • Angular JS
    • Node.JS
    • Knockout.js
    • Meteor.js
  • BI
    • SSIS
    • SSAS
    • SSRS
  • Events
  • NEWS

Category: Single User

Contained Database–A new feature in SQL SERVER 2012 TIP #81

by Rajat JaiswalPosted onJanuary 3, 2015

While working on a project sometimes it happened that we need to shift the database from one server to another due to various reason (sometimes…

Read More

How to find what is currently running on your SQL SERVER? TIP # 12

by Rajat JaiswalPosted onJune 2, 2014

When we are keen to know that what is currently running on SQL SERVER for analysis purpose then with the help of below SQL statement…

Read More

How to set database as multi user TIP #11

by Rajat JaiswalPosted onJune 1, 2014

  As we mention in  TIP 10  to set database user as Single user now to make this available again for all the user or…

Read More

How to set database as Single User TIP #10

by Rajat JaiswalPosted onJune 1, 2014

Sometimes it is require to  set database as single user for maintenance or other recovery purpose. We need to write following statement GO ALTER DATABASE…

Read More
© Copyright 2019 – Nerd Techies
Cambium Theme by BestBlogThemes ⋅ Powered by WordPress