Where "X" is the new drive?

USE [master]

GO

ALTER DATABASE [YOURDB] ADD FILE ( NAME = N'tmpLog', FILENAME = N'X:\TempLog.ldf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) TO FILEGROUP [PRIMARY]

GO

Can you create a "temporary" log file for the database on another drive to get around the log file issue?

I don't believe there's much you can do until the process(es) completes. Your log file is being written to and it won't allow the space in the file to be...

I thought the same thing Jeff, but figured it was probably because either they didn't have permissions to create an Agent job or because they have hundreds of them and...

Create a *.bat file and use sql command to execute it - then create a scheduled task to execute it @Echo Off

set ServerName=YOURSERVER

set DBName=YOURDATABASE

set sql_login=USERNAME

set sql_passwd=PASSWORD

if...

Would this work? DECLARE @Rand INT

SET @Rand = (RAND() * 20) + 10

SELECT TOP @Rand FROM MYTable WHERE SomeIntColumn > @Rand

@OP - What you can take from this is everyone's answer is showing you a better way of doing to UPDATE so you can AVOID the loop 🙂

How much data are you talking about and what process do you already have in the works? It could very well be you have a good process going and shouldn't...

How much data are you talking about? A couple million rows or hundreds of millions? If the lesser you could create an ancillary table to hold the "proper set of...

Not 100% certain about the Oracle SQLDeveloper tool but if the data is straightforward, I would simply use SSIS or bulk import of sorts

This link may help you out (it...

bpriddy (2/27/2014)

---

Can you query an Oracle database that is set to "read only" mode?

We have a database in Oracle our Police Department uses that will be placed in read only...

Is the use of sp_prepare and sp_unprepare required by the driver?

In my past experience with this, doing this in separate steps typically increases the total time involved because you are...

What's the execution plan look like? It'd be great if you could post that and your index script.

My guess is you have an index scan on the date index and...

Sounds like the front end web application is using a specific user account that does not have access (or no longer has access) to the database it's trying to reach....

Has the user been mapped to the database? If not, that's most likely the cause of your error. If you're concerned about granting permissions. If the user...