I dunno... I'm thinking that's about the 100th 64 bit related performance problem that I've seen in the last month or so... I'm thinking the 64 bit version is like...

With the information given, I would say the xyz.exe has a problem that needs to be repaired. Just because it compiles doesn't mean it's right... 😉

You can get an accurate rowcount from sys.indexes if you first run DBCC UpdateUsage(0)

It'll be a lot faster than getting a row count from every table in a database with...

Yes... you need to (must) use a BCP Format file to do this with Bulk Insert... the double-quote part of the delimiter you want (two charters... either ," or ",)...

o2srule (6/26/2008)

---

Here's what I came up with but it seems kind of kludgy, although it works. It's limited to strings that are 255 in length. I'd like it to...

OSQL utility might be better... it will do everything that SQL Server will do... ISQL doesn't have all the features (if I remember correctly).

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0),

GETDATE()-DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)

So... what do you do when you run against a...

Mark... does your Tally table have a clustered PK on it?

Heh... no problem... if you think no coffee is bad, I'm trying to quit smoking... got anyone you want to take to a porkchop dinner? 😀

toniupstny (6/26/2008)

---

You might want to determine if there might be any reason (legal requirements or self-preservation) to keep an archive of the deleted records in a separate database. This...

Heh... I think it's a bit funny that you can spell "Pduplessis" correctly, but not "Jeff"... 😛

LEFT(columnname,50)

Yep... "Read Committed" is the default on most of the other editions (At least Standard, Enterprise, and Developer's Editions... dunno about the others). Thanks for the tip on the...

jthomastx (6/26/2008)

---

I actually have a similar question. I have a table that contains customer_id, customer_Fname, Contact_date, Contact_type. In running a query showing all contact dates / times for...