Combining two updates in one SQL statement
Translating a specific Oracle SELECT statement
Executing an Oracle stored procedure in Oracle from SQL Server
Looking for I/O stats
Exporting a production DB and importing it into new development server
Query database from VB app or SQL Server?
Certifications for Access and SQL Server
A better way to search
Problems inserting dates
Getting the error: D:MSSQL7Binnisqlw.exe is not valid
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
Getting information about stored procedures
Converting Access database to SQL Server
MOD() function in SQL 7.0
Limiting the ranges of columns returned
Date format in SQL Server
Data from Fortran programs to SQL Server?
Validating online backups
Query to find cities, including nearby locations
Removing duplicate records
Differences between SQL server 7 and 2000
Displaying all of one person's phone numbers in one column
Is there a way to shrink the transaction log?
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?
@@identity problem on converted SQL code
Incrementing record id without using identity
Suddenly can't view databases from Enterprise Manager
Full text queries in SQL Server 6.5
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
System stored procedure to determine current database users
Generating a Word doc containing database info
Calling a stored procedure from a stored procedure in COBOL
What does SELECT PLATFORM() do?
Triggering an update on one server from another
Access vs. SQL Server: performance and migration issues
Order of WHERE predicates and performance
Help with tools to create database diagram
Data's physical location managed like in Oracle?
Problem getting recordset in VB from a stored procedure
What is the difference between these two queries?
Importing/exporting to SAP
Restoring a database backed up on SP1 to SP3
Can DISTINCT be used on only one field in a query?
Time data being converted unintentionally
Updating a table with a text file
Downloading SQL Server 2000 Personal Edition
Cost comparison of client servers and non-distributed systems
Not getting a result set when executing a stored procedure
Scheduling jobs to run on alternate Saturdays
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
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
Database not completing restore process, remaining in loading mode
Returning values with more than two digits to the right of the decimal point
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
SQL Server's limitations
Query to show duplicate customers only once
Renaming instance after upgrade
Creating standby servers
Creating installation program to create new database
Placing and retrieving comments on tables and columns