sql-server-2000
11 seconds to delete 240 rows in SQL Server
i am running a delete statement: DELETE FROM TransactionEntries WHERE SessionGUID = @SessionGUID The actual execution plan of the delete is:[详细]
2023-04-11 03:53 分类:问答Query extremely slow in code but fast in SSMS
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[详细]
2023-04-10 14:33 分类:问答Can I install and run SQL Server locally to develop legally for free?
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[详细]
2023-04-10 14:13 分类:问答Sql Server Index on Bit fields
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.[详细]
2023-04-09 19:31 分类:问答Conversion of Datetime from server to another server
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[详细]
2023-04-09 17:51 分类:问答How to detect if a column is a computed column
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.[详细]
2023-04-09 16:08 分类:问答Export Image column from SQL Server 2000 using BCP
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.[详细]
2023-04-09 13:05 分类:问答I need to change a tables unique ID column
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[详细]
2023-04-08 19:51 分类:问答I need to modify a table structure and need to find specific columns in database
I need to modify a database and need to find all the tables that contain the column name of \'sysnames\'.[详细]
2023-04-08 03:28 分类:问答Implementing some cryptography algorithms on sql server
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[详细]
2023-04-07 18:32 分类:问答