ASHISH SRIVASTAVA
(Move to ...)
▼
Tuesday 31 December 2019
SQL Query Table Name with Rows Counts
›
SELECT TableName = t.NAME, TableSchema = s.Name, RowCounts = p.rows FROM sys.tables t INNER JOIN sys.schemas s ...
1 comment:
Monday 16 December 2019
SQL Performance Report Queries
›
--Query 1: logical reads SELECT TOP 10 SUBSTRING ( qt . TEXT , ( qs . statement_start_offset / 2 )+ 1 , (( CASE qs . statement_e...
Friday 19 July 2019
Bulk SMS Sender ID Codes
›
Bulk SMS Sender ID Codes Following table is of Telecom Operator Code. Provider Code Airtel A BSNL B Datacom Solu...
1 comment:
Tuesday 18 June 2019
Excel read, Two days different in Python
›
Program: import pandas as pd df = pd.read_excel('CompleteData2.xlsx', sheet_name='Test') df.DOA = pd.to_datetime(df[...
Saturday 1 June 2019
View a List of Databases on an Instance of SQL Server
›
Query 1: SELECT name, database_id, create_date FROM sys.databases ; If u need only the User-defined databases; Query 1: select ...
Thursday 16 May 2019
Top 10 Web Application Security Risks
›
Injection Injection flaws, such as SQL injection, LDAP injection, and CRLF injection, occur when an attacker sends untrusted data to an ...
1 comment:
Sunday 6 January 2019
Getting Available Server Disk Space (Total Size / Free Space) SQL Query
›
SELECT distinct(volume_mount_point), total_bytes/1048576 as Size_in_MB, total_bytes/1048576/1024 as Size_in_GB, available_bytes/1048576 ...
1 comment:
‹
›
Home
View web version