It could be anything - from indexes to using the UPPER() function...

I'd start with removing the 'UPPER' function and see if it makes any big difference.

If not - look at...

It's important to remeber that ,mappings are available only to the session that created them. Thus, the actual account that is executing the code might not have any drive Z...

HI

You might wanna check Full Text Indexing in BOL, but I dout it can find HEX strings correctly...

If not - your only option (still better than Access) is to use...

Hi

The trick is to use inline query. Notice that I moved your SQL to CTE to allow for complex, yet coordinated, where clause...

;WITH MySampleCTE AS

(

Select

row_number() over(order by name)...

HI Jonest

What suggestions do you expect to hear from us?

Hi James

The migration process is devided into few steps, each requires its own decisions:

1. Migrate the dbase files 'as-is'. This is plain simple using SQL (not Express) management console, Microsoft...

SELECT

c.value('FIELD[@_KEY="Name"][1]/@_VALUE', 'VARCHAR(100)') as Name,

c.value('FIELD[@_KEY="Age"][1]/@_VALUE', 'VARCHAR(100)') as Age,

c.value('FIELD[@_KEY="Address"][1]/@_VALUE', 'VARCHAR(100)') as Address

FROM @Xml.nodes('MYDATA') T(C)

I always use the following practice:

execute SET DATEFORMAT YMD right before your insert or update statements so SQL doesn't get ambigous about it.

I think that's what...

If you look carefullt in the query plan, you'll notice that the BETWEEN directive is converted into 'X>=100 AND X<=200' pattern, so that's for optimizations.

As for performance, I sometimes...

Hi Amit

I guess one of these switches will get you where you wanted. Espacially the last one:

-m error_level

Customizes the display of error messages. The message number, state, and error level...

I bet you won't be sorry for that.

good luck and contact me if you need any help...

Tal

It's a SQL like log querying tool by Microsoft, originally developed for querying W3C log files, but has many capabilities, featuring CSV, TSV, FileSystem and many more input formats. The...

Microsoft LogParser does great job regarding varying commas inside CSV and type controlling what goes into SQL

you got me on this one...

I guess that's because this is almost the only PROCEDURal code that is allowed to do anything in the server: create or drop objects, alter...