Wildcard Searches
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
18,059 reads
Pattern Search
The passed object is invalid. - error
I've written a script to extract the content of a database and convert it to flat text files as part of a migration. Out of the blue, I get a "0x80042730 The passed object is invalid." error as the first line of text is written to the 254th file via sp_oamethod. I'm using a scroll […]
2004-12-21
38 reads
BCP utility to make format file
Can anyone help me make a format file using the BCP utility? The table is called X_CUST_INFO and the DB is called CUSTFILES...any help would be great. Thanks in advance
2004-12-02
2 reads
64 bit processor
can anyone give me a few pointers on the general rule of thumb for the performance difference of running 32 bit sql server on a 64 bit chip vs running 32 bit sql server on a 32 bit chipthxrob
2004-08-17
"SELECTING INTO a Seperate Database"
I have decided to convert some very lenghthy stored procedures to a .net app to give us more flexibility and a web based user interface for a Nightly billing process. The steps I need to take are1 - Query our production database for a resultset2 - I am SELECTING INTO a new Table, However I […]
2004-08-06
6 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers