r language

Technical Article

RE: Reduce Restore Time

  • Reply

our primary database backup file is approximately 17-20 gb. We dump to a seperate raid array over a gb switch. Our backup times are not unreasonable. We wanted to reduce the time to restore. I may investigate LiteSpeed. Thanks for the suggestions.

You rated this post out of 5. Change rating

2005-01-19

Technical Article

Remove timepart from datetime field, change Stored Procs.

  • Topic

A Table called Hdr has a datetime field with date value and time value ex:1997-03-05 19:16:05.000. Time value is not used for any purpose in the application.Below queries currently  used in Stored procs.@fromdate and @todate are char(10) field. --value passed to parameter in ymd format, ex @fromdate='2004/01/01',@todate='2004/01/30' no dateformat option set select * from hdr […]

You rated this post out of 5. Change rating

2005-01-06

10 reads

Technical Article

RE: Hockey Query Help

  • Reply

I wasn't able to do it in one query -- maybe someone else will figure that out.Here is an example involving 2 steps:create table stats (playerID int, teamID int)  -- this represents your table--populate with test data.  insert into stats select 1,1 insert into stats select 1,2 insert into stats select 1,3 insert into stats […]

You rated this post out of 5. Change rating

2005-01-06

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