Identity columns are last years news. Have you experimented with uniqueindentifiers - better known to programmers as GUID's? Guaranteed to be unique in the world, they offer a powerful alternative to identity columns.
2001-09-17
11,455 reads
In a active/active setup using SQL 2000 on Windows 2000 Advanced Server, are the client connections required to use MDAC 2.6? My company currently has a ban on MDAC 2.6 due to problems with MDAC 2.6 and Access 97. Will MDAC 2.5 allow clients to connect to a clustered virtual SQL server?
2001-08-31
4 reads
I am attempting to import data from one SQL Server to another by linking both SQL Servers together and running a query using the 4 part SQL object name. The SQL Servers are situated over separated networks, this being 2 separated VLANS. For security reasons I wish only to connect over a single port (say […]
2001-08-27
I'm about to embark on a project that will require us to convert an Access 2000 database to an SQL 2000. I want to develop web interfaces for the database however until those web apps are complete I want to keep using Access as a front end to the new SQL database. My question is […]
2001-08-21
2 reads
We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.
2001-08-20
8,199 reads
I have a stored Procedure to calculate Percentiles of a Numeric field.The stored Procedure works fine most of the times but at times it crashes giving errors in which it gives same values for a set of different parameters.Lgically there does not seem to be any problem.After this if I go in Enterprise Manager and […]
2001-08-10
2 reads
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.
2001-08-09
1,435 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/achigrik/sqlserver7.0installation.asp
2001-08-09
4 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/dpoole/whatskillsdoesadbaneed?.asp
2001-08-09
A quick question on indices. Let us suppose that I have a table with 2 fields used in a compound Index. Am I right in thinking that SQL will use the compound index to perform a search on the first field in the index, but will need an additional index to be created on the […]
2001-08-08
2 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers