Combining two updates in one SQL statement
Translating a specific Oracle SELECT statement
Looking for I/O stats
Executing an Oracle stored procedure in Oracle from SQL Server
Exporting a production DB and importing it into new development server
Certifications for Access and SQL Server
Query database from VB app or 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
Validating online backups
Data from Fortran programs to SQL Server?
Date format in SQL Server
Removing duplicate records
Query to find cities, including nearby locations
Differences between SQL server 7 and 2000
Is there a way to shrink the transaction log?
Creating a view to retrieve data from more than one database
Displaying all of one person's phone numbers in one column
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?
Incrementing record id without using identity
Error with SQL Server driver: Shared memory; connection open
Best way to add login names and passwords to user info table
Suddenly can't view databases from Enterprise Manager
Full text queries in SQL Server 6.5
@@identity problem on converted SQL code
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
Problem with connection between IIS Web server and SQL Server
Scheduling jobs to run on alternate Saturdays
Tools for a seamless export from Oracle to SQL Server
SQL Server vs. Visual FoxPro
Executing distributed queries
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
Identifying exact lock escalation and the criteria used to determine it
Future for triggers
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
Checking for NULL records in all columns in Access
Microsoft SQL Learning Edition?
Creating a view between servers
Connecting Access and SQL Server 2000
Moving from Access to SQL Server
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