i am running a delete statement: DELETE FROM TransactionEntries WHERE SessionGUID = @SessionGUID The actual execution plan of the delete is:
I have a fairly simple query that I keep getting timeouts (it takes over three minutes to complete, I stopped it early so I could post this question) on when it is running in code, however when I run
I\'m developing a databas开发者_如何学Ce-driven web application. I\'m not always connected to the network so I\'d like to setup a development environment on my laptop with a SQL Server database. The d
I am using Sql Server 2000 and want to know why we can not create index on 开发者_JAVA技巧bit fields?Just a limitation of the product. SQL Server 2005+ does allow this.
I have SQL Server 2000 in both server. We have imported existing data to new server. And also we use vb application. Now we changing our data to new server. When we run application to retrieve date wi
I\'m working with SQL Server 2000 and Java. I am creating an application that, among other things, reads the metadata from the tables, recreates them at another server and carry the data.
I\'ve been tasked with extracting some data from an SQL 开发者_运维问答Server 2000 database into a flat format on disk. I\'ve little SQL Server experience.
Not sure the best way to do this or if there is even a single best answer but here is the problem: I have a SQL Server 2000 databa开发者_StackOverflowse that consists of at least 13 tables. Some of t
I need to modify a database and need to find all the tables that contain the column name of \'sysnames\'.
Can we write 开发者_运维问答a user defined function to encrypt a string of text based on a key in sql server 2000? For e.g. I want to try writing a triple DES algorithm to encrypt text. How to write s
加载中,请稍侯......