sp_who2

Technical Article

RE: Very Large Database Backup

  • Reply

Allen, Looks to me like you've got the backups tuned as well as they can be. I can only offer some suggestions/experiences: 1. How do you minimize the data lost? Reduce the backup time. See Q2. 2. How do you reduce the backup time? I'd do striped backups, but you're already doing so. I've never […]

You rated this post out of 5. Change rating

2003-06-13

1 reads

Technical Article

RE: Scheduling DTS Packages...

  • Reply

Be sure you don't have any interactive elements in the package. If so, it will stall waiting for input. Usually this is either a message box or an error with an "OK" Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net

You rated this post out of 5. Change rating

2003-06-09

Technical Article

RE: SQL Time

  • Reply

select convert(time_challan,114) from tableA you've missed the first parameter of convert should be select convert(varchar,time_challan,114) from tableA

You rated this post out of 5. Change rating

2003-06-07

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers