Database Administrators Stack Exchange
Database Administrators Stack Exchange

Most Popular

more tags
1500 questions
20
votes
1 answer

Why does DELETE leave a lingering effect on performance?

At the end is a test script for comparing the performance between a @table variable and a #temp table. I think I've set it up correctly - the performance timings are taken outside of the DELETE/TRUNCATE commands. The results that I am getting are…
孔夫子
  • 4,330
  • 3
  • 30
  • 50
20
votes
1 answer

What factors go into an Indexed View's Clustered Index being selected?

Briefly What factors go into they query optimizer's selection of an indexed view's index? For me, indexed views seem to defy what I understand about how the Optimizer picks indexes. I've seen this asked before, but the OP wasn't too well received.…
EBarr
  • 690
  • 6
  • 13
20
votes
2 answers

During a log backup is the data backed up to the start or end of the operation?

Say I am running a log backup, and that log backup takes 10 minutes to complete. During that 10 minute window, further transactions are run. Given the below example, which transactions does the log backup actually contain? Transaction A…
George.Palacios
  • 5,590
  • 23
  • 48
20
votes
3 answers

Index max row size error

Is there a upper bound for an array column? I am getting this error when inserting into the array field - PG::Error: ERROR: index row size 3480 exceeds maximum 2712 for index "ix_data" Here's my table definition - create table test_array(id…
user310525
20
votes
3 answers

Restrict update on certain columns. Only allow stored procedure to update those columns

I have sensitive price columns that I would like to have updated only through a stored procedure. I would like all code or manual attempts to alter values in these price columns to fail if it is not using the stored procedures designed to update it.…
Elias
  • 311
  • 1
  • 2
  • 6
20
votes
1 answer

Forced plans on readable secondaries

If a plan is forced on the primary in an Availability Group, is it applied to queries run on a secondary? I'm looking for answers that cover both possibilities for plan forcing: Plan Guides Query Store Forced Plan I have read the following that…
Paul White
  • 94,921
  • 30
  • 437
  • 687
20
votes
5 answers

In PostgreSQL URL I can't use a password containing special characters

I have a postgresql database in Azure The passwd string has special characters like these: )mvd99/iyH_=ag=Por/W}%%aKY^ygt+,sC7%%P?APOU psql…
Sanx
  • 301
  • 1
  • 2
  • 3
20
votes
3 answers

PostgreSQL: difference between collations 'C' and 'C.UTF-8'

In PostgreSQL, what is the difference between collations C and C.UTF-8? Both show up in rows of pg_collation. Is it perhaps the case that C.UTF-8 is the same as C with encoding UTF-8 regardless or what the actual encoding of a database is?
rookie099
  • 368
  • 1
  • 2
  • 9
20
votes
1 answer

What exactly is the 'online' in OLAP and OLTP?

I'm a bit confused because I'm questioning the definition of 'online' in OLTP and OLAP. I used to think that 'online' here means that we want our answer in bounded time and based on the data available at an instance in time. But OLAP queries can…
Zeruno
  • 547
  • 1
  • 4
  • 15
20
votes
2 answers

best way to run sql server management studio on linux

I'm using ubuntu 18.04.2 on my desktop and running sql server 2017 from docker. I want to use sql server management studio to manage the server. SO far now, I have a windows 7 enterprise with with ssms 17.9.1 and it works ok It's really annoying…
opensas
  • 387
  • 1
  • 3
  • 10
20
votes
2 answers

Sql Server - Best Practices for Growing Database Files

I have been monitoring file growth via the data collector in sql server 2008 r2 for two weeks. The database is growing consistently at around 35(MB)/Day. The DB has not yet hit the initial size of 2 GB. The DB files auto growth is set to 5MB and I…
Ross Bush
  • 683
  • 1
  • 5
  • 18
20
votes
4 answers

Is it possible to disable new version checking in pgAdmin 4?

New versions of pgAdmin 4 are being released every month, and it's so annoying to see a popup with notification about another update. There's no option in preferences to disable it. Is there a trick to disable this particular popup, except…
Yaroslav
  • 405
  • 5
  • 10
20
votes
2 answers

How do you enable SQL Server 2019's result set caching?

SQL Server 2019 CTP 2.3 added a few new columns to sys.databases, including is_result_set_caching_on: It's not documented yet in the What's New in SQL Server 2019, nor in the ALTER DATABASE page. I tried using the same syntax as Accelerated…
Brent Ozar
  • 43,325
  • 51
  • 233
  • 390
20
votes
2 answers

Designing a user authenication (Roles & Rights) module

I am trying to model a User Authentication module for a MS SQL Server database that will be the back end to a Delphi UI Application. Basically, I want to have user accounts where the user belongs to only one group. A group can have "n" number of…
Johnny Holmes
  • 325
  • 1
  • 2
  • 6
20
votes
2 answers

How to verify SSL always being used on Postgresql 9.6

I have a sensitive application with app server and db on separate machines, and in the case of the slave db, in separate data-centers. Although I believe my postgresqls are configured to always use ssl I need a way to double-check this. Is there…
David Simic
  • 301
  • 1
  • 2
  • 3
1 2 3
…
99
100