Sql Server Materials

 USE master GO SET NOCOUNT ON DECLARE @crdate DATETIME, @hr VARCHAR(50), @min VARCHAR(5) DECLARE @uptime NVARCHAR(500) DECLARE @service_status NVARCHAR(500) SELECT @crdate=crdate FROM sysdatabases WHERE NAME='tempdb' SELECT @hr=(DATEDIFF ( mi, @crdate,GETDATE()))/60 IF ((DATEDIFF ( mi, @crdate,GETDATE()))/60)=0 SELECT @min=(DATEDIFF ( mi, @crdate,GETDATE())) ELSE SELECT @min=(DATEDIFF ( mi, @crdate,GETDATE()))-((DATEDIFF( mi, @crdate,GETDATE()))/60)*60 SELECT @uptime = 'SQL Server "' + CONVERT(VARCHAR(20),SERVERPROPERTY('SERVERNAME'))+'" is Online for the past '+@hr+' hours & '+@min+' minutes' +CHAR(10) IF NOT EXISTS (SELECT 1 FROM master.dbo.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher') BEGIN SELECT @service_status = 'SQL Server is running but SQL Server Agent <<NOT>> running' +CHAR(10) END ELSE BEGIN SELECT @service_status = 'SQL Server and SQL Server Agent both are runn...

  Managing a PostgreSQL database effectively requires a solid understanding of the key queries that help you monitor and maintain its performance and integrity. Whether you're a database administrator or a developer, having a set of reliable SQL commands at your fingertips can make troubleshooting, optimization, and general oversight much easier. In this post, I’ll share a curated list of essential PostgreSQL queries that cover various aspects of database management. These queries will serve as a handy reference to help you understand what's happening inside your database and ensure it runs smoothly. PostgreSQL Monitoring Query: Check Postgres version: One of the most basic command SELECT pg_catalog.version(); Postgres query to generate Create table statements: There are some time you need to generate create table statement and run on some other environment to create the identical table structure , same like “show create table in mysql” select table_name,'CREATE TABLE '...