Database Administrators Stack Exchange
Database Administrators Stack Exchange

Most Popular

more tags
1500 questions
21
votes
3 answers

What's the most efficient way to batch UPDATE queries in MySQL?

I'm writing an application that needs to flush out a large number of updates to the database for an extended period of time, and I've gotten stuck at how to optimize the query. Currently I'm using INSERT INTO ... VALUES (..), (..) ON DUPLICATE KEY…
jli
  • 313
  • 1
  • 2
  • 7
21
votes
2 answers

Truncate a table with 17 billion rows in an AG

I need to truncate a table with 17 billion rows, the table is in a database that is part of an AG. What will be the effect of this operation on the AG latency and the size of log backups? Is there a recommended way of doing this?
yegnasew
  • 497
  • 4
  • 8
21
votes
1 answer

What's a good SQL Server backup schedule?

There seems to be a plethora of information regarding the process of setting up backup tasks, but not much information about the big-picture view of database backups. At least, it's hard to formulate a search engine query that gives you that…
atanamir
  • 313
  • 1
  • 2
  • 5
21
votes
2 answers

How do I show the binlog_format on a MySQL server?

How do I show the binlog_format on a MySQL server? And if I dont like it how do I set it to XX permanently? Where XX is STATEMENT, ROW or MIXED.
Nifle
  • 1,472
  • 8
  • 17
  • 31
21
votes
4 answers

MySql - Changing expire_logs_days without restarting the server

I'm using MySql 5.5. Is it possible to change expire_logs_days and have the changes take effect without restarting the server?
Ran
  • 1,573
  • 9
  • 21
  • 35
21
votes
3 answers

SQL Server database synchronization

Problem definition Our users need the ability to query a database that is mostly up to date. The data can be stale up to 24 hours and that is acceptable. What would be the lowest cost approach to getting and keeping a second database up to date with…
billinkc
  • 16,143
  • 4
  • 54
  • 89
21
votes
2 answers

Broken NTFS Permissions for MSSQL$SQLEXPRESS

I have been "securing" our database server. To do this I removed some permissions from the folders that the SQL Express install created. D:\SQL D:\SQL\Data D:\SQL\Backup etc.. I kept the permissions on the Data folder as they were, but I removed…
Mat Fergusson
  • 313
  • 1
  • 2
  • 5
21
votes
1 answer

How do I cleanup PostgreSQL's WAL?

What is the correct way to cleanup PostgreSQL's WAL? I have a database with more than 100 GB and it has around 600 GB in pg_wal. Also I have 2 logical replications set up. Primary and replicas are running PostgreSQL 10. Primary and replicas have…
Gabriel Weich
  • 313
  • 1
  • 2
  • 7
21
votes
8 answers

Taking backup of all the databases in SQL Server

I have a Microsoft SQL Server 2005 DB server. In the DB server, I have around 250 user databases. I have to take a back up of all these databases. Since, manually taking backup consumes lot of time, I am looking for a Batch script or DB script which…
user1493004
21
votes
1 answer

Should I add SET NOCOUNT ON to all my triggers?

It is fairly common knowledge that you should have SET NOCOUNT ON by default when creating new stored procedures. Microsoft has changed the default template to include this in 2012. I thought this should be the same for triggers, yet it is not…
DamagedGoods
  • 2,591
  • 6
  • 34
  • 48
21
votes
4 answers

How to do a case-insensitive LIKE in a case-sensitive database?

My vendor requires the data warehouse database to be case sensitive, but I need to do case-insensitive queries against it. In a case-sensitive database, how would you write this to be case-insensitive? Where Name like '%hospitalist%'
James
  • 2,668
  • 5
  • 28
  • 51
21
votes
3 answers

How can I insert smiley faces into MySQL ( )

I'm on MySQL 5.5.21, and trying to insert the '\xF0\x9F\x98\x8A' smiley face character. But for the life of me, I can't figure out how to do it. According to various forums which I've been reading, it is possible. But whenever I try it, the data…
Bryan Hunt
  • 313
  • 1
  • 2
  • 7
21
votes
13 answers

The Value of Certifications

Questions What certifications do you have? Has your certification (or lack of one) ever worked for or against you? Do you intend to reach out for certification? Do you renew your certifications? If so, does your employer actively support the…
Riedsio
  • 1,377
  • 1
  • 14
  • 18
21
votes
8 answers

MySQL Workbench: "ssl is required but the server doesn't support it"

I'm having trouble finding answers with various Internet and Google searches for MySQL Workbench issue I'm experiencing. I have not found any answers on how to make this work again. Here's the MySQL Workbench error I'm having issues troubleshooting…
morgansbyers
  • 383
  • 1
  • 3
  • 6
21
votes
5 answers

Why does the varchar datatype allow unicode values?

I have a table with a varchar column. It is allowing Trademark(™), copyright(©) and other Unicode characters as shown below. Create table VarcharUnicodeCheck ( col1 varchar(100) ) insert into VarcharUnicodeCheck (col1) values ('MyCompany') insert…
Shiva
  • 807
  • 3
  • 8
  • 17
1 2 3
…
99 100