Combining two updates in one SQL statement
Translating a specific Oracle SELECT statement
Exporting a production DB and importing it into new development server
Looking for I/O stats
Executing an Oracle stored procedure in Oracle from SQL Server
Query database from VB app or SQL Server?
Certifications for Access and SQL Server
A better way to search
Getting the error: D:MSSQL7Binnisqlw.exe is not valid
Problems inserting dates
Is SQL Server 2000 NUMA-aware?
Exporting a list of images in a document
Returning a value from a stored procedure to an ASP Web page
Using a string list as a parameter in a stored procedure
Determining the physical space occupied by database tables
Backing up a single table, not the database?
Resetting automumber fields to begin at 1
Lock problems and slow performance
Moving objects to the correct filegroup
Converting Access database to SQL Server
Getting information about stored procedures
MOD() function in SQL 7.0
Limiting the ranges of columns returned
Validating online backups
Data from Fortran programs to SQL Server?
Date format in SQL Server
Differences between SQL server 7 and 2000
Removing duplicate records
Query to find cities, including nearby locations
Is there a way to shrink the transaction log?
Displaying all of one person's phone numbers in one column
Creating a view to retrieve data from more than one database
Best method to copy a database with all of its properties without data
Is it possible to execute a stored procedure in Oracle from SQL Server 6.5?
Errors running 16- and 32-bit programs
Any equivalent to Oracle's ROWNUM?
Full text queries in SQL Server 6.5
@@identity problem on converted SQL code
Incrementing record id without using identity
Suddenly can't view databases from Enterprise Manager
Best way to add login names and passwords to user info table
Error with SQL Server driver: Shared memory; connection open
Adding data into SQL Server 7 from Visual Basic
Changing interface to point from MS Access to SQL Server
Generating a Word doc containing database info
System stored procedure to determine current database users
Calling a stored procedure from a stored procedure in COBOL
What does SELECT PLATFORM() do?
Order of WHERE predicates and performance
Help with tools to create database diagram
Triggering an update on one server from another
Access vs. SQL Server: performance and migration issues
Data's physical location managed like in Oracle?
What is the difference between these two queries?
Problem getting recordset in VB from a stored procedure
Restoring a database backed up on SP1 to SP3
Importing/exporting to SAP
Can DISTINCT be used on only one field in a query?
Time data being converted unintentionally
Updating a table with a text file
Not getting a result set when executing a stored procedure
Downloading SQL Server 2000 Personal Edition
Cost comparison of client servers and non-distributed systems
Tools for a seamless export from Oracle to SQL Server
Executing distributed queries
SQL Server vs. Visual FoxPro
Problem with connection between IIS Web server and SQL Server
Scheduling jobs to run on alternate Saturdays
Preventing specific hosts from connecting to SQL Server
Using arrays in stored procedures
SQL Server 7.0's interpretation of dates
Sorting vs. indexing
Table partition support
Copying the _WA_sys indexes/statistics
Restoring the database only using the mdf file
Preparing for the 70-029 exam
Replicating and backing up logs without overwriting previous ones
Deleting the SQL Server icon
Resources for upgrading from 6.5 to 7.0
Future for triggers
Identifying exact lock escalation and the criteria used to determine it
Returning values with more than two digits to the right of the decimal point
Database not completing restore process, remaining in loading mode
Retrieving data via an HTML document through IIS
BCP utility explained
Localserver dependent on Internet connection
Comparing Microsoft SQL Server to Oracle
Creating a view between servers
Checking for NULL records in all columns in Access
Microsoft SQL Learning Edition?
Moving from Access to SQL Server
Connecting Access and SQL Server 2000
Query to show duplicate customers only once
SQL Server's limitations
Renaming instance after upgrade
Creating standby servers
Creating installation program to create new database
Placing and retrieving comments on tables and columns