When you try to Bulk Insert into a Temp table, the use must have privs to write to C:\Temp on the server because some working files are created there.

Looks interesting... can't download the code, though, because I'm not a member and they want too much info for my liking.

fosco (5/15/2008)

---

Good Morning,

I need some advice on what to bring up at a meeting with some developers concerning the performance issues they have been experiencing, they said its to...

That's good info... but like JackO said, that's for DATETIME precision... not GETDATE precision. We're trying to figure out why a high speed loop seems to indicate that GETDATE...

Sure... do a search on "Tally Table" or "Number Table"......

Take a look at the following URL for additional uses such as

Encoding/Decoding a string

Removing text between delimiters such as in HTML

Doing a "moving" average

Finding/Counting Days of the Week

Finding/Counting Weekdays...

Find bad characters in a string

Remove Digits from Strings

Remove Alpha from "numbers"

Change to Title Case

Histogram of characters in a column

Generate test data (not just dates)

Find gaps in serial numbers or...

The following shows the accuracy you're talking about...

SELECT 1,CAST('2000-01-01 23:59:59.990' AS DATETIME) UNION ALL

SELECT 2,CAST('2000-01-01 23:59:59.991' AS DATETIME) UNION ALL

SELECT 3,CAST('2000-01-01 23:59:59.992' AS DATETIME) UNION ALL

SELECT...

The CPU does other things... it's not dedicated to running your code.

Ack... double post... :sick:

http://www.sqlservercentral.com/Forums/Topic500305-5-1.aspx?Update=1

Ack... double post.... :sick:

http://www.sqlservercentral.com/Forums/Topic500664-338-1.aspx

When using DATENAME, it's already in a character format, so you don't need to use CONVERT or CAST...

SELECT DATENAME(yy,GETDATE())+RIGHT('00'+DATENAME(wk,GETDATE()),2)

Better question to ask is why is the column in your table VARCHAR(18) instead of FLOAT like it should be?

What a riot! I laughed out loud especially at the end. Well done, David!

In the same vein, someone needs to write an article on how to be politically...

Heh... no problem, Steve... I know about the QOD's and the fact that, like you said, they can't cover every caveat. It's one of those questions that someone asked...