Question : This is fast (49ms): v_cpf_numerico := ext.uf_converte_numerico(new.nr_cpf); select cd_cliente into v_cd_cliente from central.cliente where nr_cpf_cnpj = v_cpf_numerico; This […]
DbaFix
Filter bad words in multiple tables using triggers
Question : I have for example two tables blog_posts and image and each record in these tables have a text […]
Nested CTEs Returning Incorrect Results in Certain Situations
Question : OK, first let me say I got this issue from: Seeking Tsql wrong join explantion in CTE [closed] […]
SQL Server Express to SQL Server Standard upgrade?
Question : The database size on our SQL Server Express database is around 10GB. I checked our database size and […]
SQL server disk write queue dramatically grows sometimes
Question : I have SQL Server 2008 and a single database with full recovery model. Usually, the queue length is […]
some tips on setting up sql server database server
Question : I am currently setting up a new SQL Server database server with databases. It is supplied by a […]
SELECT + INSERT or INSERT alone
Question : I have an application where several devices send data every second to my server. On the database I […]
How to grant only functions while revoking tables?
Question : I am a newbie to PostgreSQL, and configuring a new database. I wrote several functions for indirect access(read/write) […]
Hiring a database Dev
Question : To start, I have no technical experience. I own a home services business and I want a mySQL […]
Regarding create index and lock word in SQL statement used for SQL Server
Question : This way someone creates an index. CREATE TABLE [dbo].[QueueSlow]( [QueueID] [int] IDENTITY(1,1) NOT NULL, [QueueDateTime] [datetime] NOT NULL, […]