Viewing 15 posts - 27,511 through 27,525 (of 39,769 total)
Quite a few of the heavy posters use the "Active Threads" link to check for changes since their last login and the post count is shown. That's how I scan...
August 6, 2008 at 12:23 pm
You could left join with a table of all periods, including 0s for NULLs (CASE or ISNULL).
Or you could "populate" 0 orders with the missing periods.
August 6, 2008 at 12:01 pm
Cursor opens a copy of the data, essentially and holds it. This isn't the most efficient way to do things. A While loop typically reruns a query to check if...
August 6, 2008 at 12:00 pm
If you are testing/benchmarking, you can DBCC FREEPROCACHE, but it will slow down a production server as all plans have to be rebuilt then.
August 6, 2008 at 11:58 am
Thanks, glad you liked it and hope you enjoy the little one.
Steve
August 5, 2008 at 10:39 pm
If it's a job, they only need to be able to run sp_startjob in the msdb database. You could create a batch file that runs SQLCMD/osql to make this work.
August 5, 2008 at 11:39 am
I'd go with something like Gianluca's idea. SSIS or import to a table.
August 5, 2008 at 11:37 am
Are you doing log backups during this process? Or are you in simple mode?
The commits every xx rows doesn't prevent the logging or clear the log. Only a checkpoint (simple...
August 5, 2008 at 11:33 am
Outlook shouldn't be running on the server. It needs to be installed, but the SQL Agent account will use the Outlook DLLs to connect to your Exchange server and send...
August 5, 2008 at 11:32 am
Thanks, that's interesting. I bet it's the order of replacements that cause an issue.
I'll see if there's anything we can change.
August 5, 2008 at 11:30 am
Jack has a good explanation. Basically statistics are meta data about the indexes and data. They help ensure the query optimizer performs well.
August 5, 2008 at 11:29 am
Glad to see most of you aren't afraid of un-retiring if you need to.
And if you get the chance to do something else you want, best of luck. Free cheesecakes...
August 5, 2008 at 11:28 am
There are not timeouts for objects, it's a connection timeout or query timeout that you need to set.
August 5, 2008 at 11:27 am
I'm not sure what you're putting in and what you think it should be. Please post the URL and the text that should be there separately.
August 5, 2008 at 10:50 am
Thanks and it's something to consider. Lots of people use the Active Threads link on the left, so they see what's new, but it might make sense to move threads...
August 5, 2008 at 10:48 am
Viewing 15 posts - 27,511 through 27,525 (of 39,769 total)