- SQL 2K Backup Log Monitoring
- SQL 2005 Integration Services Help
- Performance mystery -- SP vs script
- Database Restore Woes
- SQL Server 2K problem with fractional real values
- Query Help, thanks!
- Transforming rows into columns
- Script to restart replication
- How can I find what tables are loaded in memory ?
- Windows 2000 Server / IIS / SQL Server 2000
- why does a user function require dbo.* and a stored proc does not?
- DTS import does not import all rows / records
- Query not using index
- Table lock
- Senior Infrastructure Database Administrator - Calgary, Canada
- Re: Changing collation
- santosh_stb@indiatimes.com
- "Storing an image into Sql Server Database "
- Convert Seconds to hours:minutes:seconds
- SQL 7 SP 4 Installation Hangs
- Connecting to SQL Server from ASP
- SQL Statement Tuning
- SQL Statement Tuning
- Cloning a table
- debugging stored procedures
- Enabling Microsoft EFS in a SQLServer 2000 Cluster
- collate SQL_Latin1_General_CP850_BIN to SQL_Latin1_General_CP1_CI_AS
- character sets in SQL server
- syntax question whole word finding
- SQL Connection Log
- Stored procedure deadlock on self with subquery
- Insert Into Column problem ...
- T-SQL too big for Task Scedule - HELP!
- Using LIKE with underscore and forward slash..
- Identity In SQL VS Autonumber In Access
- Client connection to SQL Server on shared hosting
- SQL Statement Help
- Speed cost for using "or" clause and functions on join statement
- Design question: Nested views and functions?
- various working with dates issues
- Homecconline.com is a great site for computer hardware
- Another DTS question
- Update query
- Lock:Timeout events
- slow performance on specific query
- curious result
- Anyone interested in getting Microsoftt, CISCO or any other IT CertificationzzzZ
- Help, im new to MSSQL
- Asking Email Address Up David Portas and Erland Sommarskog
- Newbie
- SQL Server/PeopleSoft DBA Needed!
- Is there a way to autoincrement a field with mixture of alpahbetic characters and numbers?
- Stored Procedure Not Returning Recordset in ASP
- Newbie Needs Help
- SQL Server on chared hosting with client connections
- Column calculations
- Database performance degrading (again)
- Permutate rows based on table
- BCP Issue w/Right Truncation
- SQL 2000, AS400 and Client Access
- Get the field value after INSERT
- Question on aggregate statement
- Query/Report Help needed
- Stand alone client tools installation
- Mystery Database IDs in Profiler
- Query - check for a string in stored procedure
- Report Containing Sequential Dates (removing date gaps)
- Update Time Out?
- Null & String Ops Again
- MS SQL Server - User Rights
- Login Confusion
- SQL Query - Aggregate data
- Script to lock down a regular user?
- Concurrency issues with "Tree" structures.
- get the description of a column
- Problem backing up Database and Transaction Log due to disk space limitations
- TSQL: I want to use a SELECT statement with COUNT(*) AS 'name' and ORDER BY 'name'
- Complex query help needed....
- DTS Package and ASP.NET
- Urgent deliverable
- Update Query
- How to remember last record read
- multiple foreign keys on same field, based on other field
- ASP to SQL Connection Prob, Same Server, IIS
- Using select results in a stored procedure
- DB2 User Group Italy - next meetings March 2005
- simple division problem
- How to Backup Read-
- How to Backup Read-Only databases
- Dr. Michael Rys on Microsoft SQL Server 2005 and XQuery
- Cannot Drop Database
- Select first type problem...
- 'NETWORKDAYS(start_date,end_date,holidays)' in SQL ?
- Database design question
- A Query-Transpose of Data
- Some Queries
- Delete data, but file size increase
- Log all commands executed in QA
- Make easy money!! NO SCAM!! Please Read!
- Profiler not reporting reads accurately
- SQLServer Redirector Port 1434
- Get list of files in directory using a SP
- Format result of sp_helpdb
- SQL Monitoring
- backing up read-only database
- Conversion between Date Formats
- Conditional JOIN
- Timeout expired
- execution plans
- list of databases in Analysis Services
- Full Text Indexes do not fully populate
- About SQL field Type
- New Question Regarding LOG SHIPPING & MASTERDB
- Looking for MCDBA certified individual with a TS/SCI Clearance
- using DTS question
- Help needed to improve the performance of the query
- Slow SQL Query - Case in Where Stmnt
- SQL Server reports
- Can I EXPORT tables to a backup DB and delete them from my production server?
- How to remove WITH FILLFACTOR = 100 when Generate Sql Script ?
- How do I get uppercase values returned only.
- BCP Beginner - Please Help
- Failing replication requiring restart of SQL Agent
- aggregate sql question
- DataSet Update Problem
- Pivot table not showing blank value column ...
- Problem with Excel Pivot Table
- Security and access rights using local and global groups
- Best practices for field sizes
- sp_executesql vs. stored proc.
- sp_executesql vs. stored proc.
- Tricky group by order by query
- Tempdb gets out of control when inserting records
- How to create a new serverinstance but with old datafiles?
- [DBNETLIB]ConnectionCheckForData (CheckforData())
- forcing dbsqlexec to exit cleanly
- Stored Procedure and multiple keys which could be NULL
- Efficiently joining same table twice
- Problem Installing SQL 7 or SQL SERVER 2000 on Laptop
- Converting Decimal to String W/O Decimal Point
- OT:Check it out AllAdvanatage is back
- Help with update query please!
- BCP Format File
- BCP Utility - Skip rows..
- Importing CSV files
- MS SQL 6.5 Unable to connect.
- How to check when a stored procedure was last called/executed
- error 7965 not a valid recordset property
- Date query question!
- Simple select question!
- SQL-problem
- data transform and compare with in a query
- Parameterized order by clause: doesn't work
- 2 Questions: license Installation and Speed
- Backing Up the Database (Newbie Question)
- Spinning Image
- Need help / suggestion
- 2005 Express - Concurrent Connections
- passing a field name into a parameter
- Machine Name In Trigger
- Assigning column types in select into
- Delete rows in Excel From DTS package
- Key Lock Hashed Resource Text Value not unique?
- Importing Access DB
- [mssql][ant] Failed to execute: GO
- Syntax problem
- Syntax error in update?
- Update using an Inner Join
- Error with the trigger
- Sql Server Developers Licence
- Query to tranform rows to column
- Need help in log shipping
- Using SELECT LIKE with ADO Parameter in ASP Page
- access data in remote SQL server with trusted authority
- open query help
- orphan recods
- user defined functions & default parameters
- SQL DATEADD function
- What's a significant LockTimeout measurment in PERFMON?
- What's a significant LockTimeout measurment in PERFMON?
- Date Compare in SQL Server Stored Procedure
- Date Compare in SQL Server Stored Procedure
- Cannot DTS connect to SQL Server 2005
- Seek method, table-direct, and sql server2005
- Datatype
- pass hash (#) table with different structure to stored procedure
- Date Compare in SQL Server Stored Procedure
- Group by Problems
- list schema's of a sql server
- Question about SUM and Nulls
- SQL Query Help
- Auto-increment PK - Use MS or Grow your own ?
- Query Analyzer does not see Enterprise manager database and vise versa
- Find Missing data from table
- INTO FREE COMPUTER GEAR? FREE SAMSUNG 17" LCD Monitor NO TRICKS-NO SCAM-NO PURCHASE!
- Newbie....Import a DTS Package (.DTS file)
- SP To create table
- T-SQL Cursor Variable..
- IF (SQL server)
- checking the existance of fields and types
- I need help with SELECT statement
- tab character
- Books on Data Warehouse Performance Tuning for MS-SQL 2000
- (newbie) copying rows between tables via notepad
- Backup - Solution Needed
- Newbie needs help
- Email on insert in a table
- Question: Upper row limit of 6080 characters
- Bizarre case behavior.
- SELECT-how to get only the last 20 records?
- Will OSQL Produce SQL Backup?
- Can't Export Fields w/ over 255 characters
- Large binary writes slower than expected
- "Hill Climbing" -- a More General Question on Systematic SQL Skill Upgrade
- Import MS-Excel to SQL-Server
- Semistructured data
- looking for a tool/ middleware tool which...
- Win xp sp2
- Help needed
- Anyway to recover delete stored proc?
- Query help with 2 tables plus one more - easy I think
- Query help with 2 tables plus one more - easy I think
- SQL JOIN help
- SQL 2 tables ask
- IF statement in DML
- Creditwrench
- sql LEFT JOIN and IN question
- restore db stuck loading
- Multiple Table Joins Makes Query Go To Sleep
- SQL ask 2 tables
- Writing your own aggregate functions
- Using the same View repeatedly
- A story of incorrect syntax
- ASP.NET/IIS/SQL help !
- SQL Debugger Problem
- SQL Transaction Processing - Learning Resources
- Execute same statement for each value in result set
- Export
- Question:Killing sessions before nightly CHECKDB
- Question:Killing sessions before nightly CHECKDB
- SQLMail does not start
- stored procedures/security
- simple problem, it's friday...
- Return most recent membership based on year stored in joined table
- DB design thoughts??
- execute proc on stopping mssql server
- Having Clause won't run on Linked Server
- importing DB from another SQL server
- SOX Solutions?
- incompatiable data sync