Question : About 6 months ago, we upgraded a large .NET project from SQL server 2000 to 2012. (i know […]
Tag: sql-server-2000
Does a SQL Server job run on the server or the local machine?
Question : Does a SQL Server job always run on the server, or will it run in the context of […]
Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible
Question : We have a legacy application that is only used for a read only reference. It is using SQL […]
Optimizing IP Range Search?
Question : I have a simple query and table, and I would like to know which indexing is efficient on […]
Installing SQL Server 2000 32-bit on Windows Server 2008 x64?
Question : Am I correct in assuming there won’t be any issues installing SQL Server 2000 32-bit on a Windows […]
Detect changes in SQL Server database
Question : I need to know if a SQL Server 2000 database has been changed. The changes are not important, […]
Running a sql server Trace of 1 GB using sqlcmd
Question : I am load testing two sql server instances. I have a trace file from sql server 2000 database […]
Standard Time to Military Time
Question : I am somewhat new to SQL and I have seemingly simple query but I can’t seem to figure […]
Repair a SQL Server 2000 MDF file
Question : I had a SQL Server 2000 MDF on a SQL Server 2005 server (moved from prior version), there […]
Do you set an index on JOIN clauses or where clauses, or both?
Question : Say my query looks like: SELECT t1, t2 FROM t1 LEFT JOIN t2 ON (t1.id = t2.id AND […]