• Home
  • About
  • Sitemap
  • Contact
  • Forum
MENU
PrimeSQL - Simply SQL Administration and Programming
  • SQL Basics
  • Database Administration
  • SQL Programming
    • Basic Database Objects
      • Tables
      • views
      • Index
    • Complex Database objects
      • Stored Procedures
      • Triggers
      • Functions
      • Cursors
    • Development tools
      • Item 31
      • Item 32
      • Item 33
      • Item 34
    • Web design
      • Item 41
      • Item 42
      • Item 43
      • Item 44
  • HA and DR
    • Replication
    • Log Shipping
    • Mirroring
    • Clustering
  • Interview FAQ's
    • Adminitrator
      • Basic
        • Part 1
        • Part 2
        • Part 3
      • Advanced
        • Part 1
        • Part 2
        • Part 3
    • Developer
      • Basic Level
        • Part 1
        • Part 2
        • Part 3
      • Advanced
        • Part 1
        • Part 2
        • Part 3
  • Random
Archive for December 2015

Delete backups using SQL stored procedure xp_delete_file

Saketh 12:10 PM Add Comment
Saketh
Delete backups using SQL stored procedure xp_delete_file  There are several methods to delete older backups, Maintenance plan, stored ...
Read More

Backup all databases using stored procedure

Saketh 6:59 PM Add Comment
Saketh
Backup all databases using stored procedure To backup all database in an instance we create a stored procedure, and later we will create...
Read More

How to find size of all tables in a given database

Saketh 10:14 PM Add Comment
Saketh
How to find size of all tables in a given database In this we are going to return size of each table of a given database, the below sql s...
Read More
Subscribe to: Posts (Atom)

Popular

  • Backup all databases using stored procedure
    Backup all databases using stored procedure
    Backup all databases using stored procedure To backup all database in an instance we create a stored procedure, and later we will create...
  • Delete backups using SQL stored procedure xp_delete_file
    Delete backups using SQL stored procedure xp_delete_file
    Delete backups using SQL stored procedure xp_delete_file  There are several methods to delete older backups, Maintenance plan, stored ...
  • How to find size of all tables in a given database
    How to find size of all tables in a given database
    How to find size of all tables in a given database In this we are going to return size of each table of a given database, the below sql s...

Recent

Comments

Popular Posts

  • Backup all databases using stored procedure
    Backup all databases using stored procedure To backup all database in an instance we create a stored procedure, and later we will create...
  • Delete backups using SQL stored procedure xp_delete_file
    Delete backups using SQL stored procedure xp_delete_file  There are several methods to delete older backups, Maintenance plan, stored ...
  • How to find size of all tables in a given database
    How to find size of all tables in a given database In this we are going to return size of each table of a given database, the below sql s...

Labels

  • Backups
  • Backups & Restores
  • Cursors
  • Stored Procedures
  • Tables
  • Temporary tables

Blog Archive

  • ▼  2015 (3)
    • ▼  December (3)
      • Delete backups using SQL stored procedure xp_delet...
      • Backup all databases using stored procedure
      • How to find size of all tables in a given database

Like us on Facebook

Visitors

Most Trending

  • Backup all databases using stored procedure
    Backup all databases using stored procedure To backup all database in an instance we create a stored procedure, and later we will create...
  • Delete backups using SQL stored procedure xp_delete_file
    Delete backups using SQL stored procedure xp_delete_file  There are several methods to delete older backups, Maintenance plan, stored ...
  • How to find size of all tables in a given database
    How to find size of all tables in a given database In this we are going to return size of each table of a given database, the below sql s...
Powered by Blogger.

Label

  • Backups
  • Backups & Restores
  • Cursors
  • Stored Procedures
  • Tables
  • Temporary tables

Visitor Map

Copyright © 2014 PrimeSQL - Simply SQL Administration and Programming All Right Reserved
Created by Arlina Design Powered by Blogger