Database Administrators Stack Exchange
Database Administrators Stack Exchange

Most Popular

more tags
1500 questions
21
votes
2 answers

Duplicate an Oracle database user

We'll be having external auditors coming over to perform a review on our Oracle database. They will be running a tool to perform the review and for that, they require a user ID that can connect to the database and grab information from it. We have…
Gommel
  • 213
  • 1
  • 2
  • 4
21
votes
3 answers

Can I use SQL Server Management Studio 2012 on a 2008 server?

My school is using SQL Server 2008. Last time I used it I only installed (at home) SQL Server Management Studio 2008 part, and used VPN to connect to school's server. Now I want to install SQL Server Management Studio again, but this time the 2012…
user1121487
21
votes
1 answer

Anyone use SUMA, trace flag 8048, or trace flag 8015?

Recently included SQL Server startup Trace Flag 8048 to resolve a serious spinlock contention issue in a SQL Server 2008 R2 system. Interested to hear from others who have found usage cases where performance value was delivered by trace flag 8048…
sql_handle
  • 1,001
  • 6
  • 8
21
votes
1 answer

Struggling to debug high CPU usage on Amazon RDS MySQL instance

We're running an m1.xlarge MySQL RDS server and having some issues with high CPU usage. We had some problems a couple of weeks ago with CPU utilization reaching 100% on a large instance. When we upgraded the size to xlarge that stabilised things for…
WillJThomas
  • 471
  • 1
  • 3
  • 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
  • 487
  • 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
  • 7
  • 17
  • 30
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
  • 15,893
  • 4
  • 51
  • 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
4 answers

CREATE FILE encountered operating system error 5 (Access is denied.)

I'm trying to execute the following script in SQL Server Management Studio: USE [master] GO CREATE DATABASE [test1] ON PRIMARY ( NAME = N'test1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\test1.mdf', …
thiagocfb
  • 313
  • 1
  • 2
  • 4
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
  • 33
  • 48
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
2 answers

How do you turn off the croak sound for Toad?

How do you turn off this annoying feature? I don't want my DB manager to croak at me as loud as it can.
NoBugsOnlyFeatures
  • 313
  • 2
  • 7
21
votes
3 answers

SQL Server : How to disable trigger for an update only for your current session?

I am working on SQL Server 2008 R2. I have a table benefit which has a AFTER INSERT, UPDATE trigger named tiu_benefit. I want to write an UPDATE statement for this table to update 1 row but I dont want its trigger to fire. I know I can disable…
srh
  • 313
  • 1
  • 2
  • 5
1 2 3
…
99 100