Database Administrators Stack Exchange Community Digest

Top new questions this week:

Is there a way to easily validate that a SQL Script is compatible with a specific SQL Server version?

I am currently working on a project that needs to operate in different SQL environments. Most of my developers have SQL Server 2017. The application runs in SQL Azure, and the client has recently ...

sql-server ssdt compatibility-level  
asked by Joe Brinkman 9 votes
answered by David Spillett 9 votes

If a stored procedure is altered while it's currently being used in a cursor, does the cursor continue using the old query before it was altered?

If a stored procedure (or view) is currently in use within a long running cursor, and I alter that stored procedure, will the cursor continue using the old instance of the stored procedure until the ...

sql-server sql-server-2016 stored-procedures ddl cursors  
asked by J.D. 6 votes
answered by J.D. 5 votes

Why do we have Top N Sort in this example?

In the example below the result of Index Spool is already sorted, why do we have Top N Sort here instead of simple Top? use tempdb; go create table dbo.t1 (id int identity primary key, v int); ...

sql-server optimization execution-plan  
asked by sepupic 6 votes
answered by Thomas Franz -1 votes

What events still occur within a transaction that gets rolled back?

Is it true that all data modifications are undone when the transaction they are a part of gets rolled back? For example if a cursor that just executed a stored procedure 100 times that updated a ...

sql-server sql-server-2016 transaction ddl dml  
asked by J.D. 5 votes
answered by Solomon Rutzky 5 votes

How to remove SQL Server Error Logs

I have six error logs plus the current. They are taking up 10G of disk space on my hard drive on my VPS server. Thats about 25% of the server space. The largest file is 6G and growing. How can I ...

sql-server sql-server-2014 error-log  
asked by MiscellaneousUser 4 votes
answered by LowlyDBA 6 votes

Power BI on-prem data gateway for Azure devops pipeline?

I'm building a POC for DB devops using redgate SCA and an azure devops pipeline. Need to connect to our SQL Servers that don't have public IPs. Was hoping power BI on-prem gateway would facilitate. Is ...

sql-server azure powerbi  
asked by PeterDaniels 4 votes
answered by PeterDaniels 1 vote

SQL Server - Snapshot is useful in production environments?

I'm reading about SQL Server high availability solutions and disaster recovery and among the available resources the SQL Server have snapshot feature. In theory all seems like beautiful. I also ...

sql-server sql-server-2017 snapshot  
asked by Leonardo Lacerda 4 votes
answered by Shanky 5 votes

Greatest hits from previous weeks:

Connect to sql plus from command line using connection string

Let's say I have a Oracle database. I have a username = x, password = y, database = z. Also I know the port = a, SID = b, Hostname = c. So how do I need to connect correctly? I used many options ...

oracle sqlplus string  
asked by Edvinas 41 votes
answered by Hanspeter Oberlin 74 votes

When should a primary key be declared non-clustered?

While creating a test database for another question I asked earlier, I remembered about a Primary Key being able to be declared NONCLUSTERED When would you use a NONCLUSTERED primary key as opposed ...

sql-server primary-key  
asked by Stuart Blackler 171 votes
answered by Remus Rusanu 189 votes

How to safely change MySQL innodb variable 'innodb_log_file_size'?

So I'm fairly new to tuning InnoDB. I'm slowly changing tables (where necessary) from MyIsam to InnoDB. I've got about 100MB in innodb, so I increased the innodb_buffer_pool_size variable to 128MB: ...

mysql innodb myisam logs  
asked by Derek Downey 106 votes

Why Does the Transaction Log Keep Growing or Run Out of Space?

This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this: In SQL Server - What are some reasons the ...

sql-server transaction-log shrink auto-growth recovery-model  
asked by Mike Walsh 265 votes
answered by Mike Walsh 324 votes

How to run psql on Mac OS X?

I installed PostgreSQL on a computer with Mac OS X using the One click installer. Then I try to access PostgreSQL using the psql command, but it doesn't seem to be available. I get this message: ...

postgresql installation psql mac-os-x  
asked by Jonas 55 votes
answered by Denis de Bernardy 42 votes

How can I monitor the progress of an import of a large .sql file?

I am importing a 7 GB foobar.sql to restore a table in a local database. $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib ...

mysql mysqldump import  
asked by qazwsx 206 votes
answered by Rob 271 votes

How to handle TimeZone properly in SQL Server?

My local development server is in the Middle East, but my production server is in the UK. I need to show the date to the user in their time zone. For example, if a user is in Saudi Arabia then I ...

sql-server sql-server-2008 timezone  
asked by user960567 34 votes
answered by Jon Seigel 47 votes

Can you answer these questions?

What All Is Factored Into A MySQL Checksum? (Why Could They Be Different?)

I'm currently going through the excruciating task of moving MySQL databases from one shared web hosting environment to another. This has been a multi-month battle (and I'm learning a lot). After ...

mysql backup migration php checksum  
asked by azoundria 1 vote

How would I maintain referential integrity across a database where I use versioned records while keeping data in sync?

I am building a database that consists of a few tables that are used as data sources for a form our application generates. [form] [question] [responses] id id id name ...

mysql database-design data-synchronization data-versioning  
asked by Barry Chapman 1 vote

firebird is very slow compared to sqlite

I am using Firebird for past few months and today a customer complained about performance issue. I checked into client's database and they had 167,77,216 rows in one table. So I made a clone of that ...

asked by 0_0 2 votes
answered by Mark Rotteveel 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