Neil Pike | ITPro Today

Neil Pike

Latest from Neil Pike

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

How can I convert a SQL date/time to just date?How can I convert a SQL date/time to just date?

Feb 20, 2000

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

I have a SQL Server process that shows as being in SPINLOOP. What does this mean?I have a SQL Server process that shows as being in SPINLOOP. What does this mean?

Feb 8, 2000

1 Min Read

All from Neil Pike

Early Versions (SQL Server 2000 – 2008)

Where can I get an OLE-DB/ODBC/JDBC driver to connect SQL Server to product xyz?

Where can I get an OLE-DB/ODBC/JDBC driver to connect SQL Server to product xyz?

Oracle Cloud Infrastructure

What issues are there with SQL 7's DTS function and Oracle.

What issues are there with SQL 7's DTS function and Oracle.

Early Versions (SQL Server 2000 – 2008)

What is the Microsoft Loopback adapter and why do I need it for SQL Server?

What is the Microsoft Loopback adapter and why do I need it for SQL Server?

Early Versions (SQL Server 2000 – 2008)

My SQL Server database has been marked "suspect" - what can I do?

My SQL Server database has been marked "suspect" - what can I do?

Early Versions (SQL Server 2000 – 2008)

What tools are available to stress/benchmark SQL Server?

What tools are available to stress/benchmark SQL Server?

Early Versions (SQL Server 2000 – 2008)

How can I list all available SQL Servers in my application?

How can I list all available SQL Servers in my application?

Early Versions (SQL Server 2000 – 2008)

I am getting an error 603 restoring a database ever since I applied SP5 to SQL 6.5?

I am getting an error 603 restoring a database ever since I applied SP5 to SQL 6.5?

Early Versions (SQL Server 2000 – 2008)

Why do I get an error "Msg 602, Level 21, State 3. Could not find row in Sysindexes for dbid 'x', object 'yyyyyyyy',index 'z'." when running a SQL Server query?

Why do I get an error "Msg 602, Level 21, State 3. Could not find row in Sysindexes for dbid 'x', object 'yyyyyyyy',index 'z'." when running a SQL Server query?

Early Versions (SQL Server 2000 – 2008)

Why do my SQL Server identity values get out of synch causing gaps/duplicates etc.?

Why do my SQL Server identity values get out of synch causing gaps/duplicates etc.?

Early Versions (SQL Server 2000 – 2008)

Why do I have problems revoking permissions on some tables with SQL Server?

Why do I have problems revoking permissions on some tables with SQL Server?

Early Versions (SQL Server 2000 – 2008)

Why do I get an error "Bad pointer 0xABCDEF encountered while remapping stored procedure" in SQL Server?

Why do I get an error "Bad pointer 0xABCDEF encountered while remapping stored procedure" in SQL Server?

Early Versions (SQL Server 2000 – 2008)

How can I install SQL Server client tools in unattended mode?

How can I install SQL Server client tools in unattended mode?

Can I install SQL on a Terminal Server machine?

Can I install SQL on a Terminal Server machine?

Early Versions (SQL Server 2000 – 2008)

How can I re-install SQL Server without losing any data under a new version of NT I have installed?

How can I re-install SQL Server without losing any data under a new version of NT I have installed?

Early Versions (SQL Server 2000 – 2008)

How can I transfer DTS packages from one SQL 7 server to another?

How can I transfer DTS packages from one SQL 7 server to another?

Early Versions (SQL Server 2000 – 2008)

What do the bufwait, writelog and buffer latch errors in SQL Server mean?

What do the bufwait, writelog and buffer latch errors in SQL Server mean?

Early Versions (SQL Server 2000 – 2008)

Where can I get details on the layout of the TDS protocol that SQL Server uses to talk to clients?

Where can I get details on the layout of the TDS protocol that SQL Server uses to talk to clients?

Early Versions (SQL Server 2000 – 2008)

I'm getting a sort failed 1501 message on SQL Server - what's going on?

I'm getting a sort failed 1501 message on SQL Server - what's going on?

Early Versions (SQL Server 2000 – 2008)

How do I connect to SQL Server through a firewall?

How do I connect to SQL Server through a firewall?

I am getting an error 4409 selecting on a view ever since I applied SP5 to SQL 6.5.

I am getting an error 4409 selecting on a view ever since I applied SP5 to SQL 6.5.

Early Versions (SQL Server 2000 – 2008)

How can I move a SQL Server device from one disk to another, or rename it?

How can I move a SQL Server device from one disk to another, or rename it?

Early Versions (SQL Server 2000 – 2008)

I'm having trouble installing SQL Server.

I'm having trouble installing SQL Server.

Early Versions (SQL Server 2000 – 2008)

A query produces this error in SQL 7 'Internal Query Processor Error'.

A query produces this error in SQL 7 'Internal Query Processor Error'.

Early Versions (SQL Server 2000 – 2008)

How can I speed up SQL Server applications running over slow links?

How can I speed up SQL Server applications running over slow links?

Early Versions (SQL Server 2000 – 2008)

How do I transfer data between SQL Server databases / across servers?

How do I transfer data between SQL Server databases / across servers?

Early Versions (SQL Server 2000 – 2008)

Why am I being blocked by spid -1? I am not able to kill it and have to restart SQL Server to get around it.

Why am I being blocked by spid -1? I am not able to kill it and have to restart SQL Server to get around it.

Early Versions (SQL Server 2000 – 2008)

How many bytes can I fit on a row/page in SQL Server and why? Are there any workarounds?

How many bytes can I fit on a row/page in SQL Server and why? Are there any workarounds?

Early Versions (SQL Server 2000 – 2008)

I am getting a blue screen / completely hung machine / server restart on my SQL Server/client.

I am getting a blue screen / completely hung machine / server restart on my SQL Server/client.

Early Versions (SQL Server 2000 – 2008)

What is a reproduction (repro) script that I need to produce for a SQL Server bug?

What is a reproduction (repro) script that I need to produce for a SQL Server bug?

Early Versions (SQL Server 2000 – 2008)

I am getting a message GetOverLappedResult() from a SQL Server query.

I am getting a message GetOverLappedResult() from a SQL Server query.

Identity Management & Access Control

How does a client talk to SQL Server? What is a net-lib? What network protocols are used? What net-libs support NT authentication/encryption?

How does a client talk to SQL Server? What is a net-lib? What network protocols are used? What net-libs support NT authentication/encryption?

Regulatory Compliance

What are the minimum hardware/software requirements for SQL Server?

What are the minimum hardware/software requirements for SQL Server?

Early Versions (SQL Server 2000 – 2008)

Where can I get more info on the spt_values table?

Where can I get more info on the spt_values table?

Sign up for the ITPro Today newsletter

Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

Newsletter Sign-Up