data warehouse

Technical Article

RE: Search in DTS packages

  • Reply

I've never had any luck saving as structured files, the search tends to not find what I'm looking for, I think (emphasis on think) because many things are stored as unicode. What I think you might be better off doing is script something to save all the packages as VBScript files, which is another save-as […]

You rated this post out of 5. Change rating

2003-12-01

1 reads

Technical Article

RE: DATETIME datatype

  • Reply

I found this snippet in the SQL Books Online, SP3 version, in the reference for LIKE: It is recommended that LIKE be used when you search for datetime values, because datetime entries can contain a variety of dateparts. For example, if you insert the value 19981231 9:20 into a column named arrival_time, the clause WHERE […]

You rated this post out of 5. Change rating

2003-07-30

1 reads

Blogs

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

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