Search Results | SQL Server Performance Forums

Issue w/ "Not in"

Post by: lshores, Jul 12, 2006 in forum: Performance Tuning for DBAs

Thanks for your help joechang. You pointed me in the right direction. Just FYI for everyone, I found the specific reason SQL handles EXIST queries...

Issue w/ "Not in"

Thread by: lshores, Jul 12, 2006, 2 replies, in forum: Performance Tuning for DBAs

I have two queries, one using an inner join, one using Not in to return the count from the same tables. For some unknown reason, the two queries are...

Secure FTP

Thread by: lshores, Dec 19, 2003, 1 replies, in forum: Analysis Services/Data Warehousing

Does anyone know if sftp is supported by MS SQL 2000? I currently use the xp_cmdshell to call the ftp protocol to transfer files from a directory...

Time Format

Post by: lshores, Dec 2, 2003 in forum: General Developer Questions

Thank you plahoud, this is exactly what I was looking for.

Time Format

Thread by: lshores, Dec 2, 2003, 5 replies, in forum: General Developer Questions

Does anyone know how to format the date and time to a value without the colons in the time field? For example: 12022003101455 ( December 12, 2003...

Snapshot Performance Issue

Post by: lshores, May 30, 2003 in forum: Performance Tuning for SQL Server Replication

I have a table that has columns defined as NOT NULL without default values. If I add a default value to a column to avoid this issue, run the...

What is the syncobj_xxx generated in views?

Thread by: lshores, May 27, 2003, 2 replies, in forum: Performance Tuning for SQL Server Replication

I am a novice at setting up replication, and tried to do so for the first time last week. After I set up Snapshot replication and then...