For more information about the site, see the Site Index
- Priority for System Administrator user?
- Display all tables from SQL Server using Visual Basic 6.0
- How to use results from one stored procedure in another
- Improve SQL Server Maintenance Wizard optimization performance
- Permanently prevent query analyzer from accessing particular database
- Cluster index vs. non-cluster index
- More information on backups and re-indexing
- Differences between SQL-89, SQL-92 & SQL-199
- How to set up a QA box that closely simulates production
- Active/active or active/passive clustering?
- How to display the XML result of 'Select For XML Explicit'
- Top SQL Server resources
- SQL Server 2005 bitmap index?
- Log in failed for user 'myservernameaspnet'
- Convert owner field as loginAdmin
- Not allowing TEAM-SQL users to log in with SQL Server authentication
- Why do applications use a single log on to SQL server?
- Convert English language database into Japanese
- Find S_name & S_marks of which student gets 2nd highest marks in table
- Return a SQL Server storing 100GB of data
- Which process is consuming majority of central processing unit?
- Fragmentation based on results from DBCC SHOWCONTIG
- Speed up application
- Recreate operating system and SQL with data on new drives
- How does failover clustering work in SQL 2005?
- Why upgrade to SQL Server 2005?
- Creating and altering views on SQL Server
- Mismatches after moving a SQL database to a new server
- Restoring a database with only the trans.mfd file
- SQL Server primary database backup options
- What is a trigger?
- How do you implement data/row-level security in SQL Server 7.0 or 2000?
- Windows and SQL Servers 2003 and their MDAC versions
- An efficient query for joins of four tables
- Restoring a database from the production server to a disaster recovery server
- Best practices for backing up the master, model, and msdb databases
- Difference between WHERE and HAVING
- Paging through SQL query results
- Leading zeros
- Removing duplicate rows
- Column name in a combo box
- Delete from table A if matching row exists in B
- Updating a local table from company tables
- Split a column value based on numeric character
- TOP query with multiple columns
- Migrating poorly designed database to new, normalized one
- ISO/ANSI SQL and the GROUP BY clause
- Procedure for finding last modified info?
- Applying LDF file to MDF without turning it to .BAK first?
- Runs of sequential numbers, part 1
- Runs of sequential numbers, part 2
- Joining derived tables
- Nested selects
- Error running a stored procedure that references a remote server
- Cumulative sum across the row, not down the column
- Mixing ORs with NOTs
- The last N rows in each group
- Counting days per month in a date range, part 1 of 2
- Joining two many-to-many relationship tables
- NULL columns in a LEFT OUTER JOIN
- Counting days per month in a date range, part 2 of 2
- Extract surname from name column
- Generate N rows for a column value of N
- Sum elapsed hours by task by date, part 3 of 3
- Sum elapsed hours by task by date, part 2 of 3
- Sum elapsed hours by task by date, part 1 of 3
- Displaying decimal places in SQL Server 2000
- Extracting data without strings converted to strange characters
- Creating a DTS package
- Money data type conversion issue using DTS
- How to manage data without partitions in SQL Server
- Problems trying to install SQL Server on a two-node cluster on SAN
- Starting on SQL Server and ASP pages
- Memory usage by different databases
- Sending mail from SQL Server
- Repairing corrupt MDF files
- In-place versus side-by-side upgrade
- Any way to alias a call to functions?
- Script to show permissions
- Resolving error 644
- Loading of schema information slow
- Creating transactional replication on 10 servers
- NVARCHAR versus VARCHAR
- Search logic allowing wild cards and reverse order names
- Installing SQL Server 2000 on Windows XP
- Method for retrieving SQL Server records similar to ROWNUM
- Deadlock on creating unique document numbers
- Routine to push existing records up or down
- Recovering a database with just the .ldf and .mdf files
- Problems on some of the five databases with separate maintenance plans
- Knowing what data will be lost with repair_allow_data_loss option
- First transaction log in the morning is the size of the database
- Changing collation name of specific database
- Database marked 'Suspect'
- Attaching a database that has missing log file
- Temporary database is full from a query
- Looking at data replication tools
- Getting type mismatch error converting string to date
- "Max connections reached" error
- Trying to retreive deleted file
- More