I recently had to create a UDF that would convert a Java time value to a datetime value. We have an application that stores dates and times as the number of milliseconds since Jan.
Read more →
Have you ever needed to quickly disable all jobs on a SQL Server? If you have a lot of jobs to disable, then this stored procedure will help you out. We move our systems to our disaster recovery site twice per year for disaster recovery testing.
Read more →
So how do you DELETE thousands/millions of rows from a table without blocking anyone for long periods of time? Well, here is an example:
DECLARE @Count INT DECLARE @Error INT
Read more →
Well today has definitely been interesting. I have been working with a co-worker who is responsible for trouble shooting customer problems. This specific customer is running our product with MSDE. We do not have dial-up access to the server, so everything is being done over the phone, plus the customer speaks Spanish, which I do not.
Read more →
I have been asked to look into why a stored procedure is failing. The problem is that the application gets an error that a temp table doesn't exist. Here is the code with the problem (my comments in blue, contents were changed to protect company information):
Read more →
This is my first post. Hopefully I'll have some good information to post here soon.
Read more →