6
Sep, 2022
T-SQL Query to check Sybase IQ Collation
Sybase IQ Collation, Sybase IQBelow queries can be used to check Sybase IQ Collation.
Query#1:
1select * from sa_db_properties() where PropName='Collation'
2go
Result:
Query#2:
1select db_property('Collation')
2go
5
Sep, 2022
How to Become a Database Administrator(DBA): A Complete Guide
Uncategorized database administrator job, database administrator salary in India, DB2, DBA Job for Freshers, DBA Jobs, DBA Jobs in India, DBA salary in India, MySQL, Oracle, PostgreSQL, SQL serverHave you ever heard this DBA terminology before ? Perhaps YES or NO. Yes for those who are already into IT industry for sometime now. NO for those who are not part of IT industry. They are either FRESHERS or … Read the rest
4
Sep, 2022
Sybase Replication: T-SQL Query to check table level replication flow details
Sybase Replication MSA, Sybase Replication, table level replication, warmstandbyBelow query needs to be run on RSSD database to check complete table level replication flow details against specific Replication server.
Login to Replication server and get RSSD details.
1admin rssd_name
2go
Login to SYB_DS database server … Read the rest
2
Sep, 2022
T-SQL Query to check Drive Space in SQL Server
MSSQL, T-SQL Scripts Disk Space, Drive Space, SQL serverBelow query can be used to check Drive space details in SQL server on Windows platform.
Sample Output: