Database Administrators Stack Exchange Community Digest

Top new questions this week:

Creating an Index that is not used by a (SELECT) query reduces performance of that query

I have just watched this video by Pinal Dave. He has a SELECT query that produces ~370k reads in tempdb and ~1200 reads of the table the query is SELECTing from. He then creates an index (Let's call ...

sql-server performance index  
asked by SEarle1986 8 votes
answered by Martin Smith 9 votes

Azure IaaS VM - Use D:\ Drive for tempdb - NTFS Formatting 64k

This was a question I was battling with earlier today and eventually figured out an answer. Wouldn't mind something better, but wanted to provide this to whomever also needed. First, on an Azure VM ...

sql-server azure-vm  
asked by Nicholas McQuillen 6 votes
answered by David Browne - Microsoft 4 votes

SQL 2019 install....what is AzureAttestService?

We started the installation and configuration of SQL Server 2019 on Windows 2019 and noticed after install a new service named 'AzureAttestService' was running and set to automatic. Services list the ...

sql-server azure-sql-database sql-server-2019  
asked by JamesDBA 5 votes

SSIS Package Not Being Deployed

I have an issue with an SSIS package, that when deployed via VS2017 to the integration services catalog is not actually being deployed. This is an individual package deployment, and not a project ...

ssis sql-server-2017 ssdt visual-studio-2017  
asked by SteveG 4 votes
answered by GregGalloway 0 votes

Execution Plan Warnings cardinality xml data type

I have the following statements: -- 1st DECLARE @AuditParameters XML = ( SELECT 1 AS AccountID, 2 AS CategoryID, 3 AS CategoryAttributeID, '4' AS SyncBatchGUID ...

sql-server optimization execution-plan plan-cache warning  
asked by Kevy Augusto 4 votes
answered by Martin Smith 4 votes

How can SUSER_SNAME return the localized user name?

I need to assign network service user to SQL Server database programmatically, so I am running this script: USE [MyDB] GO DECLARE @user nvarchar(50) DECLARE @SQLStatement nvarchar(500) SET @user = ...

sql-server t-sql logins  
asked by jstuardo 3 votes
answered by Solomon Rutzky 1 vote

where can I find the DNS name associated to the listener of an Availability Group?

I have an availability group that has a listener. The listener is called SQLPROD as you can see on the picture below. It uses port 1433 When I run the following script: ALTER AVAILABILITY GROUP ...

sql-server availability-groups clustering powershell dmv  
asked by Marcello Miorelli 3 votes
answered by Tony Hinkle 2 votes

Greatest hits from previous weeks:

Oracle 12c Installation in Windows 7 error INS-30131

I am trying to install Oracle 12c in a Windows 7 x64 computer and after a while I get this error: SEVERE: [FATAL] [INS-30131] Initial setup required for the execution of installer validations failed. ...

oracle installation  
asked by Yván Ecarri 8 votes

What is a Key/Value store database?

I've been looking at the wikipedia page for NoSQL and it lists several variations on the Key/Value store database, but I can't find any details on what it means by Key/Value store in this context. ...

asked by indyK1ng 56 votes

How do I list all databases and tables using psql?

I am trying to learn PostgreSQL administration and have started learning how to use the psql command line tool. When I log in with psql --username=postgres, how do I list all databases and tables? I ...

postgresql tools psql command-line  
asked by Jonas 1219 votes
answered by Frank Heikens 1606 votes

List the database privileges using psql

I'm in the middle of a database server migration and I can't figure (after googling and searching here) how can I list the database privileges (or all the privileges across the server) on PostgreSQL ...

postgresql ubuntu permissions psql  
asked by pedrosanta 158 votes
answered by DrColossos 131 votes

How to determine if an Oracle table is locked or not?

We've been using BI software and a repository database that are installed on Oracle Enterprise 11gR2. Some of these batch reports will try to access a database table which may still be locked. How ...

oracle-11g-r2 locking business-intelligence  
asked by Selahattin 25 votes
answered by Ravindra Reddy 34 votes

PostgreSQL not running on Mac

The error in its entirety reads: psql: could not connect to server: No such file or directory. Is the server running locally and accepting connections on Unix domain socket ...

asked by Michael P. 66 votes
answered by Michael P. 44 votes

How do I list all schemas in PostgreSQL?

When using PostgreSQL v9.1, how do I list all of the schemas using SQL? I was expecting something along the lines of: SELECT something FROM pg_blah;

postgresql schema postgresql-9.1  
asked by Stéphane 258 votes
answered by a_horse_with_no_name 277 votes

Can you answer these questions?

Why is PostgreSQL prefix/range search finicky?

Configuration PostgreSQL 11.4 SET default_statistics_target=1000; Data The scenario is that there are "computers" each with "files", which each have path (ordered text list) unique to that ...

postgresql index query-performance execution-plan btree  
asked by Paul Draper 1 vote

Is it possible to Increase storage performance in azure vm using disk striping?

Given the following Azure VM: E8s_v3 (8 cpu, 64 GB RAM, 12800 IOPS, 192 MBps) I added 2 SSD Premium drives, one for data (1024 GBs / 200 MBps / Host Caching enabled read-only) and one for Logs (256 ...

sql-server performance storage azure-vm cloud  
asked by Victor Barajas 1 vote
answered by MattyZDBA 0 votes

How does the actual restoration works in SQL Server internally?

Suppose my Database DB1 lost some data, but I have a Full, Differential and then followed by Transaction log backups. Till full\Differential backup I can understand it is like the snapshot of the ...

sql-server backup restore  
asked by Harsh Sanghai 1 vote
answered by Learning_DBAdmin 0 votes
You're receiving this message because you subscribed to the Database Administrators community digest.
Unsubscribe from this community digest       Edit email settings       Leave feedback       Privacy
Stack Overflow

Stack Overflow, 110 William Street, 28th floor, New York, NY 10038