Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 34

What's the meaning of "resources external to the SQL Server computer are needed" in Microsoft's SQL documentation?

In Microsoft's SQL Server documentation on Windows service account configuration, the decision to use either a VA (virtual account) or a MSA (managed service account) hinges on...

Asked on 01/04/2021 by Stuart J Cuthbertson

2 answer

Article table has a lot of null. What is the best way to prevent null in MySQL

I'm optimizing table schema. My case is like. User can generate an article. It has a lot of item. like name, age, sex, address, hobby... name, sex is a required...

Asked on 01/04/2021 by jonggu

1 answer

Full text search on larger text rows

I am wondering what is the best practice to use the right query in my case. The problem is I tried the LIKE and ILIKE and it was faster then...

Asked on 01/04/2021 by Spedo De La Rossa

1 answer

Select a count of record sharing the same value than record X

Figure a table with two columns: id, catId How to select the records having the same catId than the record having id = 3? Example:id catId1 32...

Asked on 01/03/2021 by Slim

1 answer

GRANT ROLE TO USER in MySQL

I created one role QI_RO, granted all privileges on all schemas on the server and I was trying to grant role privilege to another user but throwing error.GRANT QI_RO...

Asked on 01/03/2021 by Rj_N

1 answer

Error passing variable table type to a stored procedure

I'm having a noob problem passing a data table type to a stored procedure. Here is the implementation :DECLARE @T TVARIABLE INSERT INTO @T ...

Asked on 01/01/2021 by user2578332

1 answer

Is there any unique identifier for PostgreSQL? How can the master identify its slave unqiuely?

Is there any way to have more than one PostgreSQL slave servers in the same system. If yes, how come a master detect each server as different slaves from the...

Asked on 01/01/2021 by manvith

1 answer

Why BCP creates such big files?

I'm creating some reports via BCP to be sent via emails.create TABLE ##tempsss ( create TABLE ##JOB_DataAssociacao_verContrato( ...

Asked on 01/01/2021 by Racer SQL

1 answer

How to maintain customer addresses for Orders?

The database I am designing is part of a project I am working on. I have come up with 3 simple "business rules":Customers must either be Individuals or Businesses (a...

Asked on 12/31/2020 by ProGrammer

1 answer

My database is in TB with different schemas. I would like to search in each schema following information:Schema nameTable nameTable sizeRows countTable Created dateWhere table name contains: *.bak or dropped_*...

Asked on 12/31/2020

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 34)

What's the meaning of "resources external to the SQL Server computer are needed" in Microsoft's SQL documentation?

Article table has a lot of null. What is the best way to prevent null in MySQL

Full text search on larger text rows

Select a count of record sharing the same value than record X

GRANT ROLE TO USER in MySQL

Error passing variable table type to a stored procedure

Is there any unique identifier for PostgreSQL? How can the master identify its slave unqiuely?

Why BCP creates such big files?

How to maintain customer addresses for Orders?

Table size and row count

Ask a Question