Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: identifier

Why can’t object names start with a number?

By adminPosted on July 22, 2022

Question : For example, if I’m creating view with a name ‘4aii’, why does SQL Server care that it starts […]

Test if a string is a valid, unquoted identifier?

By adminPosted on November 6, 2021

Question : I’m just wondering if there is an established method for testing if a string can be used as […]

Identifier that starts with is too long. Max length is 128

By adminPosted on October 11, 2021

Question : I referenced a few other blogs and I can’t isolate the issue to this logic. Code is below. […]

Relation does not exist while scanning schema

By adminPosted on October 8, 2021

Question : My Postgres database is getting slow while executing some function. But another database of identical design and with […]

Does this regex reliably remove square brackets from T-SQL?

By adminPosted on May 29, 2020

Question : I’m using SQL Server Management Studio 17.4, which supports search-and-replace using a Microsoft version of regular expressions (regex). […]

Recent Posts

  • Mongoexport halts when it reaches 101 records
  • A Script to insert dummy Data in all tables of DB [duplicate]
  • Will query continue to run even after network times-out
  • Need some support on MySQL Query
  • The sort column must be the last column used in the index – MongoDB Indexing Advice
  • Understanding Backup Types
  • SQL Server sp_configure options?
  • DBA Permissions on LOCAL SERVER containing SQL SERVER [closed]
  • Update table using values from another table in SQL Server
  • Getting 0KB of size file while backup mysql database using mysql dump [closed]
  • Local Backup from Amazon RDS PostgreSQL database
  • Who is using my worker threads? SQL Server 2014 – HADR
  • Data Domain Boost viewing backups
  • One table for all persons
  • Database for building a realtime analytics system
  • Threads_cached 0 while thread_cache_size > 0
  • Why is performance non-linear if I do many UPDATEs in a single transaction
  • Mysql innoDB write operations are extremely slow
  • mysql_query expected [closed]
  • Oracle not using index when > used in where clause

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding