Viewing 15 posts - 406 through 420 (of 1,583 total)
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
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 4:08 pm
Can you create a "temporary" log file for the database on another drive to get around the log file issue?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 3:04 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 2:52 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 11:35 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 10:11 am
Would this work? DECLARE @Rand INT
SET @Rand = (RAND() * 20) + 10
SELECT TOP @Rand FROM MYTable WHERE SomeIntColumn > @Rand
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 9:49 am
@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 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 9:37 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 1, 2014 at 1:51 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 1, 2014 at 1:48 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 1, 2014 at 1:40 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 1, 2014 at 10:33 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2014 at 11:05 pm
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....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2014 at 4:30 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2014 at 3:54 pm
Throw the results into a parameter table, then loop through the table and send the email to each recipient - this is a very rough example but should get you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 28, 2014 at 3:27 pm
Viewing 15 posts - 406 through 420 (of 1,583 total)