Database Administrators Stack Exchange
Database Administrators Stack Exchange

Most Popular

more tags
1500 questions
24
votes
1 answer

Where do this Constant Scan and Left Outer Join come from in a trivial SELECT query plan?

I have this table: CREATE TABLE [dbo].[Accounts] ( [AccountId] UNIQUEIDENTIFIER UNIQUE NOT NULL DEFAULT NEWID(), -- WHATEVER other columns ); GO CREATE UNIQUE CLUSTERED INDEX [AccountsIndex] ON [dbo].[Accounts]([AccountId] ASC); GO This…
sharptooth
  • 1,301
  • 2
  • 9
  • 21
24
votes
6 answers

slow load speed of data from mysqldump

I've got a moderate size MySQL database with about 30 tables, some of which are 10 million records, some 100 million. The mysqldump of all the tables (into separate files) is fairly fast, takes maybe 20 minutes. It generates about 15GB of data. The…
Pat Farrell
  • 393
  • 1
  • 4
  • 10
24
votes
1 answer

Are unfixable spatial index corruptions considered normal?

I have a spatial index for which DBCC CHECKDB reports corruptions: DBCC CHECKDB(MyDB) WITH EXTENDED_LOGICAL_CHECKS, DATA_PURITY, NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS The spatial index, XML index or indexed view 'sys.extended_index_xxx_384000'…
boot4life
  • 1,279
  • 1
  • 11
  • 19
24
votes
3 answers

MySQL InnoDB page_cleaner settings might not be optimal

Seeing this note in mysqld.log: [Note] InnoDB: page_cleaner: 1000ms intended loop took 15888ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.) There seems to be mention of something like this here: MySQL instance…
mcmacerson
  • 352
  • 1
  • 3
  • 9
24
votes
1 answer

Is my SQL Server patched?

How can I tell whether my SQL Server instances are patched? Is there native functionality that will identify whether there are patches available for my server? Heck, do I even have version data available to me?
billinkc
  • 15,893
  • 4
  • 51
  • 89
24
votes
3 answers

Does CPU utilization affect the cost of foreign NUMA access?

Scenario Let's assume I have a SQL Server with 4 sockets with each 1 NUMA node. Each socket has 4 physical cores. There is 512 GB of memory total so each NUMA node has 128 GB of RAM. A key table is loaded into the first NUMA node. Question Let's…
xav
  • 407
  • 2
  • 8
24
votes
2 answers

PostgreSQL "size of temporary files"

I've imported data into a new database (about 600m rows of timestamp, integer, double). I then created some indexes and tried to alter some columns (got some out of space issues), the database is vacuumed. Now pgAdmin III tells me that the "Size of…
Ofiris
  • 821
  • 6
  • 10
  • 19
24
votes
2 answers

Decision criteria on when to use a non-dbo schema vs a new Database

I'm mostly an application developer but find myself having to do all the up-front database work for my current project (btw... its MS SQL Server 2008). As a first decision, I'm trying to figure out whether to divide my state using seperate Databases…
JoeGeeky
  • 1,257
  • 4
  • 14
  • 26
23
votes
2 answers

Many columns vs few tables - performance wise

Yes, I am aware that data normalization should be my priority (as it is). I've got a table with 65 columns storing vehicle data with columns: used_vehicle, color, doors, mileage, price and so forth, in total 65. Now, I can divide that and have a…
Urim Kurtishi
  • 353
  • 1
  • 2
  • 6
23
votes
4 answers

check constraint does not work?

I have the following table. create table test ( id smallint unsigned AUTO_INCREMENT, age tinyint not null, primary key(id), check (age<20) ); The problem is that the CHECK constraint does not work on the age column. For example, when I…
Alireza
  • 3,636
  • 10
  • 37
  • 44
23
votes
4 answers

SQL server service won’t start after disabling TLS 1.0 and SSL 3.0

Because of security reasons, we disabled TLS 1.0 and older protocols on our windows, and enabled just TLS 1.1 and TLS 1.2 under the following registry path: …
Jiri Mares
  • 331
  • 1
  • 2
  • 5
23
votes
4 answers

How to make pg_dump skip extension?

This is on 9.3 but I can remember simillar things happening since 7.x. So I create database and install plpgsql extension into it. Later on I create a pg_dump and before restoring it into databse I make sure it also has plpgsql extension. Then when…
Jacek Prucia
  • 341
  • 1
  • 2
  • 4
23
votes
3 answers

Postgresql doesn't accept replication connection

Plain old streaming replication. PostgreSQL: 9.2.7 Windows 8.1 64 bit My primary and secondary clusters are on same windows machine. I have already done pg_start_backup() and everything, so both nodes have exact same data. Now the problem with…
Sachin Verma
  • 789
  • 4
  • 9
  • 15
23
votes
1 answer

How to calculate/store Top 10 in a tabular model?

We have recently created an SSAS tabular model so our users can access it via PowerView. We have a measure on one of our fact tables to get the TotalActiveItems using a formula: TotalActive:=COUNTAX(FILTER('Stats', ISBLANK([DeactDate]) = TRUE),…
Taryn
  • 9,676
  • 3
  • 45
  • 74
23
votes
5 answers

What is the best query to use to monitor a SQL Server database's status?

I want to be able to run a query to get the crucial information about a database's status. I.e., I want the query to be able to tell what whether or not the database is in a good state. This is the query that I inherited for this check: SELECT name…
brett rogers
  • 433
  • 1
  • 3
  • 9
1 2 3
…
99 100