cross apply

Technical Article

RE: English in Script Comments

  • Reply

Steve mentioned "I typically don't review the scripts when they are submitted because honestly I don't have time". I'm sure this is true of the other site owners as well. Would it be beneficial to the community as whole if there was a group of reviewers that performed this function? I'm sure in a community […]

You rated this post out of 5. Change rating

2004-08-16

Technical Article

RE: Closing an open database

  • Reply

/* To automatically close a db when no users are accessing it */ ALTER DATABASE pubs SET AUTO_CLOSE ON go However when u use the db , it will be opened again ! so what is the exact test that u are doing? consider putting db in dbo use only mode. sp_dboption pubs ,'dbo use […]

You rated this post out of 5. Change rating

2004-01-02

Technical Article

RE: UDF as Computed Column Part 2

  • Reply

Hmmmm... It was with the first script "Create Schema Authorization" but the entire exercise worked fine this morning. The fn_getDuration function is nice little headbanger. Thanks for your assistance.

2003-07-23

Technical Article

RE: Combining Two Grouping Select Statements

  • Reply

quote: To be more specific, I am trying to obtain the total of questionnaires in the query per "WSI" as opposed to the percentage from the whole. This select statement is being called from an ASP page as opposed to in the sql stored procedures etc. I think it would be better if you used […]

You rated this post out of 5. Change rating

2003-06-18

1 reads

Technical Article

RE: interbase vs sql server

  • Reply

Depends whether you want a desktop or an industrial-strength solution. Interbase is fine if all you want is a small discreet desktop datbase solution similar to MSACCESS. If on the other hand you want the speed, power, scalability and robustness offered by a mainstream RDBMS then choose SQL Server over Interbase everyday. Don't get me […]

You rated this post out of 5. Change rating

2003-06-18

1 reads

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