Top new questions this week:
|
|
I was asked the other day what would happen if SQL Server wanted to run a single query that was granted more memory than is available to the instance. My initial thoughts were that I may see …
|
|
Our SQL Server’s collation is set to SQL_Latin1_General_CP1_CI_AS I have a requirement where we have the same values with different cases but SQL Server treats them the same since our collation is set …
|
|
I attempted to rebuild all the indexes of a DB using the query, USE [DB_Name]; GO DECLARE @TableName VARCHAR(255) DECLARE @sql NVARCHAR(500) DECLARE TableCursor CURSOR FOR SELECT ‘[‘+…
|
|
As the title alludes to I am wondering if it is possible or if you have experienced an issue with differing GETDATE() results within the same UPDATE statement. I have a stored procedure which updates …
|
|
I have a users table for my company’s management system. Right now, the previous developer split everything into separate table. So you would have: ‘users’ ( id, email, username, password, first_name,…
|
|
I am trying to establish whether SQL Server is affected by the recently discovered OpenSSL vulnerabilities. For example, are SQL Servers that are using TLS/Certificates to encrypt connections between …
|
|
I am not a specialist in databases, and I only need to clarify a terminological question that I have. Assume we have a table containing the field F. F gets its values from the set S, a collection of …
|
Greatest hits from previous weeks:
|
|
I have one table of services. I need to merge two SELECT queries. Both have different where clauses. For example SELECT U_REGN as ‘Region’, COUNT(callID) as ‘OpenServices’, SUM(CASE WHEN …
|
|
I have a table: CREATE TABLE names (id serial, name varchar(20)) I want the “last inserted id” from that table, without using RETURNING id on insert. There seem to be a function CURRVAL(), but I don’…
|
|
I don’t design schemas everyday, but when I do, I try to setup cascade updates/deletes correctly to make administration easier. I understand how cascades work, but I can never remember which table is …
|
|
I am running Ubuntu 16. I have installed Postgresql. Postgresql used to work, but then I rebooted. nmap commands show port 5432 is open. Postgres seems to be working correctly: service …
|
|
Is there a best practice between using a LEFT JOIN or a NOT EXISTS format? What is benefit to using one over the other? If none, which should be preferred? SELECT * FROM tableA A LEFT JOIN tableB B …
|
|
I wrote a script to REINDEX indexes in a database. Here is one of them: echo -e “\nreindex for unq_vbvdata_vehicle started at: `date “+%F %T”`” >> ${LOG_FILE} psql -U ${USERNAME} -h ${HOSTNAME} …
|
|
I’m really confused with the terms database, user and schema. Can anyone explain how they are different from each other (if they are)? If they are same then, what are the similarities between them? …
|
Can you answer these questions?
|
|
Scenario: I am being asked to create an HR training tracker for employees of a business. in this database I am using two tables: EMPLOYEE(EMPLID, LastName, FirstName, PrimaryEmail) with EMPLID as the …
|
|
I have been seeing an issue with cqlsh not connecting to protocol version v4 on few nodes of a cassandra cluster. 20% of nodes are downgrading to v3 but I want all nodes to be connected to v4 because …
|
|
First thanks for your time and I am using SQL Server Hello, I am having a problem obtaining the data, first I will explain the case. I have a data set that contains rows from both the current year and …
|
