comp.databases.ms-sqlserver

• Date Index

---

• Millions of Delete Statements, halftime57@xxxxxxxxx
• Help with SQL query?, melissa820
  • Re: Help with SQL query?, Roy Harvey (SQL Server MVP)
  • Re: Help with SQL query?, Gert-Jan Strik
• Add a coulm in a table, after a specific column, D.
  • Re: Add a coulm in a table, after a specific column, Plamen Ratchev
    • Re: Add a coulm in a table, after a specific column, D.
      • Re: Add a coulm in a table, after a specific column, Hugo Kornelis
• CLR Assembly redeploy problem., Amber
• Create Index, Jackie Silva
• DB Backup - Single User Mode, velu5
  • Re: DB Backup - Single User Mode, David Portas
  • Re: DB Backup - Single User Mode, Erland Sommarskog
• get some rows into one column, candide_sh
  • Re: get some rows into one column, Hugo Kornelis
    • Re: get some rows into one column, candide_sh
      • Re: get some rows into one column, Gert-Jan Strik
  • Re: get some rows into one column, --CELKO--
    • Re: get some rows into one column, Tony Rogerson
      • Re: get some rows into one column, DA Morgan
• SqlClient connection to SQL 2005 creates 5000 tcp connections!, John Rivers
• some error in table definition, cong
  • Re: some error in table definition, Roy Harvey (SQL Server MVP)
    • Re: some error in table definition, Erland Sommarskog
      • Re: some error in table definition, Ed Murphy
      • Re: some error in table definition, Roy Harvey (SQL Server MVP)
      • Re: some error in table definition, cong
      • Re: some error in table definition, Roy Harvey (SQL Server MVP)
      • Re: some error in table definition, cong
      • Re: some error in table definition, --CELKO--
    • Re: some error in table definition, cong
• Error message on using union statement with order by using reserved words, signon77
  • Re: Error message on using union statement with order by using reserved words, Roy Harvey (SQL Server MVP)
    • Re: Error message on using union statement with order by using reserved words, signon77
  • Re: Error message on using union statement with order by using reserved words, --CELKO--
• Problem In SQL Server 2005 Replication On Port 2433, shgzs33
• Open SQL 2005 database question, Charlie
  • Re: Open SQL 2005 database question, Ed Murphy
    • Re: Open SQL 2005 database question, Charlie
  • Re: Open SQL 2005 database question, Erland Sommarskog
• CONTAINS and wildcard, Sharif Islam
  • Re: CONTAINS and wildcard, jhofmeyr
    • Re: CONTAINS and wildcard, Sharif Islam
• Error message with stored procedure, JJ297
  • Re: Error message with stored procedure, Plamen Ratchev
    • Re: Error message with stored procedure, JJ297
      • Re: Error message with stored procedure, Plamen Ratchev
      • Re: Error message with stored procedure, Plamen Ratchev
      • Re: Error message with stored procedure, JJ297
• Error message in DTS, David Greenberg
  • Re: Error message in DTS, David Greenberg
• Two Tables with Left Outer Join & Where Clause, pbassutti
  • Re: Two Tables with Left Outer Join & Where Clause, David Portas
  • Re: Two Tables with Left Outer Join & Where Clause, Erland Sommarskog
    • Re: Two Tables with Left Outer Join & Where Clause, pbassutti
• Uploading image type using TSQL, Artie
  • Re: Uploading image type using TSQL, Erland Sommarskog
• Get value from query to update another another table, rzito
  • Re: Get value from query to update another another table, Erland Sommarskog
• ODBC Failed [Microsoft][ODBC SQL ...NamedPipes]ConnectionWrite (WrapperWrite())., Lisa
  • Re: ODBC Failed [Microsoft][ODBC SQL ...NamedPipes]ConnectionWrite (WrapperWrite())., Erland Sommarskog
• CASE count wierd join needed maybe? just one more field needed!, kevin
  • Re: CASE count wierd join needed maybe? just one more field needed!, jhofmeyr
    • Re: CASE count wierd join needed maybe? just one more field needed!, jhofmeyr
      • Re: CASE count wierd join needed maybe? just one more field needed!, kevin
  • Re: CASE count wierd join needed maybe? just one more field needed!, --CELKO--
• SQL Server 2005 SP2 update 2 rollup Performance tank, traceable1
  • Re: SQL Server 2005 SP2 update 2 rollup Performance tank, Erland Sommarskog
    • Re: SQL Server 2005 SP2 update 2 rollup Performance tank, traceable1
      • Re: SQL Server 2005 SP2 update 2 rollup Performance tank, Erland Sommarskog
• MCDBA - SQL Server 2005 Certification?, Mycoal
  • Re: MCDBA - SQL Server 2005 Certification?, Tom Brown
• Can some explain this to me?, davidaustinarcher
  • Re: Can some explain this to me?, Roy Harvey (SQL Server MVP)
  • Re: Can some explain this to me?, --CELKO--
• Weird speed problem, DBMonitor
  • Re: Weird speed problem, DBMonitor
  • Re: Weird speed problem, Roy Harvey (SQL Server MVP)
  • Re: Weird speed problem, Hugo Kornelis
    • Re: Weird speed problem, DBMonitor
      • Re: Weird speed problem, Erland Sommarskog
      • Re: Weird speed problem, DBMonitor
      • Re: Weird speed problem, Erland Sommarskog
• Slow Execution Performance, Ben
  • Re: Slow Execution Performance, Erland Sommarskog
    • Re: Slow Execution Performance, Ben
      • Re: Slow Execution Performance, Erland Sommarskog
      • Re: Slow Execution Performance, Ben
      • Re: Slow Execution Performance, Erland Sommarskog
      • Re: Slow Execution Performance, Ben
      • Re: Slow Execution Performance, Erland Sommarskog
      • Re: Slow Execution Performance, Ben
• Re: Deleting all data, Joe Hurzeler
• Re: Cannot connect to SQL instance without port information, Joe Hurzeler
• Need help Joining tables, JJ297
  • Re: Need help Joining tables, Roy Harvey (SQL Server MVP)
    • Re: Need help Joining tables, JJ297
      • Re: Need help Joining tables, Roy Harvey (SQL Server MVP)
      • Re: Need help Joining tables, JJ297
• Subquery with invalid column name runs, Anne
  • Re: Subquery with invalid column name runs, Roy Harvey (SQL Server MVP)
    • Re: Subquery with invalid column name runs, Anne
      • Re: Subquery with invalid column name runs, Roy Harvey (SQL Server MVP)
      • Re: Subquery with invalid column name runs, Anne
      • Re: Subquery with invalid column name runs, --CELKO--
• find rows within seconds of top of hour, rcamarda
  • Re: find rows within seconds of top of hour, Roy Harvey (SQL Server MVP)
• Not Exists joining 2 tables, Artie
  • Re: Not Exists joining 2 tables, Erland Sommarskog
    • Re: Not Exists joining 2 tables, Artie
  • Re: Not Exists joining 2 tables, --CELKO--
    • Re: Not Exists joining 2 tables, Artie
      • Re: Not Exists joining 2 tables, Erland Sommarskog
    • Re: Not Exists joining 2 tables, Ed Murphy
• Min() query - 5th level optimization, Chris H
  • Re: Min() query - 5th level optimization, Erland Sommarskog
• Reusing a generated column to avoid over processing, brazil.mg.marcus.vinicius.lima
  • Re: Reusing a generated column to avoid over processing, Roy Harvey (SQL Server MVP)
    • Re: Reusing a generated column to avoid over processing, Roy Harvey (SQL Server MVP)
• emptying database, Phung
  • Re: emptying database, Greg D. Moore \(Strider\)
  • Re: emptying database, Jack Vamvas
• view, Phung
  • Re: view, Roy Harvey (SQL Server MVP)
    • Re: view, Roy Harvey (SQL Server MVP)
  • Re: view, ZeldorBlat
• design Index problem, Enorme Vigenti
  • Re: design Index problem, Erland Sommarskog
    • Re: design Index problem, Enorme Vigenti
      • Re: design Index problem, Erland Sommarskog
      • Re: design Index problem, Enorme Vigenti
      • Re: design Index problem, Erland Sommarskog
  • Re: design Index problem, Jack Vamvas
• Wrong result Set when using NoLock, bmm
  • Re: Wrong result Set when using NoLock, Greg D. Moore \(Strider\)
  • Re: Wrong result Set when using NoLock, Erland Sommarskog
    • Re: Wrong result Set when using NoLock, bmm
      • Re: Wrong result Set when using NoLock, Erland Sommarskog
  • Re: Wrong result Set when using NoLock, Najm
• database to comprehensively manage anniversaries, PeterF
  • Message not available
    • Re: database to comprehensively manage anniversaries, PeterF
• fastest way to deduplicate a list, Michael Evanchik
  • Re: fastest way to deduplicate a list, Erland Sommarskog
• ¿Libros en español para Diseño de Base de datos y Normalización?, mtbvfr
• Books in Spanish for Database Design and Normalisation?, mtbvfr
  • Re: Books in Spanish for Database Design and Normalisation?, bbcworldtour
• How can i store data ?(encoding and data type), oruccim@xxxxxxxxx
  • Re: How can i store data ?(encoding and data type), oruccim@xxxxxxxxx
    • Re: How can i store data ?(encoding and data type), Robert Klemme
    • Re: How can i store data ?(encoding and data type), Ed Murphy
• configure sql server details, pearl146
  • Re: configure sql server details, Erland Sommarskog
• indexes and selects, MikeJ
  • Re: indexes and selects, Erland Sommarskog
• Wrapping T-SQL in Function and it gets very slow., Christian Ulrich
  • Re: Wrapping T-SQL in Function and it gets very slow., Erland Sommarskog
    • Re: Wrapping T-SQL in Function and it gets very slow., Christian Ulrich
• pass Column Name using Parameter in SQL Statement..., raghutumma
  • Re: pass Column Name using Parameter in SQL Statement..., Erland Sommarskog
  • Re: pass Column Name using Parameter in SQL Statement..., --CELKO--
    • Re: pass Column Name using Parameter in SQL Statement..., paulschultz54
      • Re: pass Column Name using Parameter in SQL Statement..., Greg D. Moore \(Strider\)
      • Re: pass Column Name using Parameter in SQL Statement..., Tony Rogerson
• indexes, MikeJ
  • Re: indexes, Erland Sommarskog
• Re: delete database file on server -> sharing violation, Tony Rogerson
  • <Possible follow-ups>
  • Re: delete database file on server -> sharing violation, Tony Rogerson
• Two Domains, mike
• Re: Replace Multiple Spaces with One Space?, Blackburn
  • Re: Replace Multiple Spaces with One Space?, MikeJ
• Run SQL script on Instance Startup, traceable1
  • Re: Run SQL script on Instance Startup, Steve215
    • Re: Run SQL script on Instance Startup, traceable1
    • Re: Run SQL script on Instance Startup, traceable1
• Student needs help with editions, jamesallen74@xxxxxxxxx
  • Re: Student needs help with editions, Hugo Kornelis
• Yellowfin Release 3.3, YellowFin Announcements
• How to find SQL Servers & Databases in Each server using BATCH File?, raghutumma
• Solution: Invalid STDGMEDIUM structure error in DTS package, jshunter@xxxxxxxxxxxxx
• Re: A suitable SQL Server book for my goals, Hugo Kornelis
• Re: What are these queries used for?, Hugo Kornelis
• define unique keys, TGEAR
  • Re: define unique keys, Hugo Kornelis
  • Re: define unique keys, Ed Murphy
• T-SQL Challenge, imani_technology_spam@xxxxxxxxx
  • Re: T-SQL Challenge, Hugo Kornelis
  • Re: T-SQL Challenge, Ed Murphy
    • Re: T-SQL Challenge, imani_technology_spam@xxxxxxxxx
  • Re: T-SQL Challenge, --CELKO--
  • <Possible follow-ups>
  • T-SQL Challenge, imani_technology_spam@xxxxxxxxx
• Can you help me test my MS SQL test on my new testing website, spaceman
• transactions, Nick Chan
  • Re: transactions, Hugo Kornelis
    • Re: transactions, Nick Chan
• a ouple of questions about ms sql server, aaabbb16
  • Re: a ouple of questions about ms sql server, Hugo Kornelis
    • Re: a ouple of questions about ms sql server, aaabbb16
• RSS to SQL?, Big Moxy
  • Re: RSS to SQL?, Martijn Tonies
• Can anybody help? Is there an undocumented unique record key in SQL Server?, Tim
  • Re: Can anybody help? Is there an undocumented unique record key in SQL Server?, aj
  • Re: Can anybody help? Is there an undocumented unique record key in SQL Server?, Gert-Jan Strik
  • Re: Can anybody help? Is there an undocumented unique record key in SQL Server?, Erland Sommarskog
  • Re: Can anybody help? Is there an undocumented unique record key in SQL Server?, David Portas
• mmsql - transact, info
  • Re: mmsql - transact, Erland Sommarskog
• large data management, Enorme Vigenti
  • Re: large data management, Erland Sommarskog
    • Re: large data management, Enorme Vigenti
• sql server doesn't work well with 250ms+ network latency, jeff80
  • Re: sql server doesn't work well with 250ms+ network latency, Erland Sommarskog
  • Re: sql server doesn't work well with 250ms+ network latency, Tony Rogerson
• table columns, MikeJ
  • Re: table columns, Gert-Jan Strik
• .bak file format?, jims
  • Re: .bak file format?, aj
    • Re: .bak file format?, jims
  • Re: .bak file format?, Erland Sommarskog
• Service stop/start/restart questions 2005 SP2, aj
  • Re: Service stop/start/restart questions 2005 SP2, Erland Sommarskog
• SQL execution slow over the network, pramodbura
  • Re: SQL execution slow over the network, Jack Vamvas
    • Re: SQL execution slow over the network, pramodbura
  • Re: SQL execution slow over the network, Erland Sommarskog
• Database Protection and Auditing Tool, dba
• A probably over and over again asked question of Syntax - Help please, theintrepidfox
  • Re: A probably over and over again asked question of Syntax - Help please, Erland Sommarskog
    • Re: A probably over and over again asked question of Syntax - Help please, theintrepidfox
      • Re: A probably over and over again asked question of Syntax - Help please, Erland Sommarskog
  • Re: A probably over and over again asked question of Syntax - Help please, Ed Murphy
    • Re: A probably over and over again asked question of Syntax - Help please, theintrepidfox
      • Re: A probably over and over again asked question of Syntax - Help please, theintrepidfox
• How do I link a database in SQL, rzito
  • Re: How do I link a database in SQL, Erland Sommarskog
    • Re: How do I link a database in SQL, rzito
• Query Variables, Yota
  • Re: Query Variables, Erland Sommarskog
  • Re: Query Variables, steve
    • Re: Query Variables, Ed Murphy
      • Re: Query Variables, steve
      • Re: Query Variables, Ed Murphy
• Speed Issues After SQL Upgrade, Ben
  • Re: Speed Issues After SQL Upgrade, Ben
    • Re: Speed Issues After SQL Upgrade, Greg D. Moore \(Strider\)
  • Re: Speed Issues After SQL Upgrade, Erland Sommarskog
    • Re: Speed Issues After SQL Upgrade, Ben
  • Re: Speed Issues After SQL Upgrade, Ed Murphy
• Indexed View Crashes ASP.NET App, Jason Wilson
  • Re: Indexed View Crashes ASP.NET App, Erland Sommarskog
• how to query for a column value that contains dashes, jdrake
  • Re: how to query for a column value that contains dashes, Roy Harvey (SQL Server MVP)
  • Re: how to query for a column value that contains dashes, MC
  • Re: how to query for a column value that contains dashes, aj
• Would special character cause insertion problem?, tatata9999
  • Re: Would special character cause insertion problem?, Jack Vamvas
    • Re: Would special character cause insertion problem?, tatata9999
      • Re: Would special character cause insertion problem?, Erland Sommarskog
      • Re: Would special character cause insertion problem?, tatata9999
      • Re: Would special character cause insertion problem?, Erland Sommarskog
      • Re: Would special character cause insertion problem?, tatata9999
      • Re: Would special character cause insertion problem?, tatata9999
• get value of a single record instead of aggregated value with GROUP BY, blackpuppy
  • Re: get value of a single record instead of aggregated value with GROUP BY, Roy Harvey (SQL Server MVP)
  • Re: get value of a single record instead of aggregated value with GROUP BY, Erland Sommarskog
• Get Column Name, Eddie
  • Re: Get Column Name, MC
• Enterprise Data Architecture, Parker
• Collation Questions SQL Server 2005 SP2, aj
  • Re: Collation Questions SQL Server 2005 SP2, Erland Sommarskog
    • Re: Collation Questions SQL Server 2005 SP2, aj
      • Re: Collation Questions SQL Server 2005 SP2, Erland Sommarskog
• Delete all data in the database, hunkgym
  • Re: Delete all data in the database, Erland Sommarskog
• How to Execute SQL Scripts using Batch file?, raghutumma
  • Re: How to Execute SQL Scripts using Batch file?, Erland Sommarskog
  • Re: How to Execute SQL Scripts using Batch file?, Dan Guzman
• SQL Server 2005 database - Problem, Zeljko Bilandzija
  • Re: SQL Server 2005 database - Problem, Erland Sommarskog
• Business Intelligence Consultancies must adapt to survive and prosper., YellowFin Announcements
• Can a View be protected to support "JOINS" only?, Kevin Frey
  • Re: Can a View be protected to support "JOINS" only?, Erland Sommarskog
• bulk inserting uniqueidentifier column, bob . speaking
  • Re: bulk inserting uniqueidentifier column, Erland Sommarskog
    • Re: bulk inserting uniqueidentifier column, bob . speaking
      • Re: bulk inserting uniqueidentifier column, Erland Sommarskog
• How to select a word substring in a coumn header from right to left, sjharri
  • Re: How to select a word substring in a coumn header from right to left, Erland Sommarskog
  • Re: How to select a word substring in a coumn header from right to left, --CELKO--
• Opinions on SQL Server hardware, Artie
  • Re: Opinions on SQL Server hardware, Erland Sommarskog
  • Re: Opinions on SQL Server hardware, Nick Chan
  • Re: Opinions on SQL Server hardware, Tom van Stiphout
• Sql Server 6.5 Client Tool and ASP.net, ABCL
  • Re: Sql Server 6.5 Client Tool and ASP.net, pamela fluente
  • Re: Sql Server 6.5 Client Tool and ASP.net, Erland Sommarskog
• Help a newb (issue with excel, ms access and SQL Server), joaotsetsemoita
  • Re: Help a newb (issue with excel, ms access and SQL Server), Erland Sommarskog
• A Must Read-MCSD!!!, rojer.bake@xxxxxxxxx
• Joining SQL Results, Alec
  • Re: Joining SQL Results, Hugo Kornelis
  • Re: Joining SQL Results, --CELKO--
• SQL Server does not allow remote connections., aCe
  • Re: SQL Server does not allow remote connections., Erland Sommarskog
  • Re: SQL Server does not allow remote connections., Nick Chan
• Full Text Index, Sharif Islam
  • Re: Full Text Index, Greg D. Moore \(Strider\)
• Problem with object owner not dbo, Teresa Masino
  • Re: Problem with object owner not dbo, Erland Sommarskog
• Dynamic Tables Names and Temporary Tables Options, brstowe
  • Re: Dynamic Tables Names and Temporary Tables Options, Ed Murphy
    • Re: Dynamic Tables Names and Temporary Tables Options, brstowe
      • Re: Dynamic Tables Names and Temporary Tables Options, Hugo Kornelis
• migrating MSSQL databases to MySQL, agnesroz
  • Re: migrating MSSQL databases to MySQL, Dan Guzman
  • Re: migrating MSSQL databases to MySQL, pamela fluente
• SQL2005 database backup files, barbara . plume
  • Re: SQL2005 database backup files, Erland Sommarskog
• Re: SQL Configuration, Neil
• SQL 2005 license downgrade to 2000, rdraider
• Notification Services Updates, Greg D. Moore \(Strider\)
• negate RESULT SET, all inactive client, Mike
  • Re: negate RESULT SET, all inactive client, Erland Sommarskog
• SQL Timeout Errors - Can Anyone Help?, alvinstraight38@xxxxxxxxxxx
  • Re: SQL Timeout Errors - Can Anyone Help?, Erland Sommarskog
• Re: time conversion hiccup, tatata9999
  • Re: time conversion hiccup, Erland Sommarskog
    • Re: time conversion hiccup, tatata9999
    • Re: time conversion hiccup, tatata9999
      • Re: time conversion hiccup, Ed Murphy
      • Re: time conversion hiccup, tatata9999
      • Re: time conversion hiccup, Ed Murphy
      • Re: time conversion hiccup, tatata9999
      • Re: time conversion hiccup, tatata9999
      • Re: time conversion hiccup, Erland Sommarskog
      • Re: time conversion hiccup, tatata9999
      • Re: time conversion hiccup, Erland Sommarskog
      • Re: time conversion hiccup, tatata9999
      • Re: time conversion hiccup, tatata9999
      • Re: time conversion hiccup, Erland Sommarskog
• Changing Collation, manstein
• ms sql 2005 developer edition, HandersonVA
  • Re: ms sql 2005 developer edition, xman
    • Re: ms sql 2005 developer edition, HandersonVA
      • Re: ms sql 2005 developer edition, Erland Sommarskog
• SQL Server 9 - Vista 64 - Error message in Event Viewer - interactive service, Accessed
• replication or mirroring, mmark751969
  • Re: replication or mirroring, Erland Sommarskog
• SQL 2005 Ambiguous column name, rdraider
  • Re: SQL 2005 Ambiguous column name, Erland Sommarskog
    • Re: SQL 2005 Ambiguous column name, rdraider
    • Re: SQL 2005 Ambiguous column name, steve
      • Re: SQL 2005 Ambiguous column name, Serge Rielau
      • Re: SQL 2005 Ambiguous column name, steve
      • Re: SQL 2005 Ambiguous column name, Serge Rielau
      • Re: SQL 2005 Ambiguous column name, steve
      • Re: SQL 2005 Ambiguous column name, Serge Rielau
• Exporting a MS-SQL database, bsagal
  • Re: Exporting a MS-SQL database, Jack Vamvas
• Re: strategies for paging, Nick Chan
• The Two Standards of the Sql CTE, steve
• Do you know what the Sql CTE really is?, steve
• Finding common joins, Cindy
  • Re: Finding common joins, Jack Vamvas
    • Re: Finding common joins, Marc Melancon
  • Re: Finding common joins, --CELKO--
    • Re: Finding common joins, Cindy
      • Re: Finding common joins, Ed Murphy
      • Re: Finding common joins, Cindy
• Simple recovery model affect performance?, rdraider
  • Re: Simple recovery model affect performance?, Erland Sommarskog
• Reports of users, zach
• Re: I want to parse @ArrayOfDays into @d1 through @d5, bobc
  • Re: I want to parse @ArrayOfDays into @d1 through @d5, Tony Rogerson
  • Re: I want to parse @ArrayOfDays into @d1 through @d5, Erland Sommarskog
    • Re: I want to parse @ArrayOfDays into @d1 through @d5, bobc
    • Re: I want to parse @ArrayOfDays into @d1 through @d5, bobc
      • Re: I want to parse @ArrayOfDays into @d1 through @d5, bobc
      • Re: I want to parse @ArrayOfDays into @d1 through @d5, Erland Sommarskog
      • Re: I want to parse @ArrayOfDays into @d1 through @d5, bobc
      • Re: I want to parse @ArrayOfDays into @d1 through @d5, bobc
      • Re: I want to parse @ArrayOfDays into @d1 through @d5, Erland Sommarskog
• Re: How Do I give EXECUTE Permissions on Stored Procedures?, abu hisham
  • Re: How Do I give EXECUTE Permissions on Stored Procedures?, Ed Murphy
  • Re: How Do I give EXECUTE Permissions on Stored Procedures?, Erland Sommarskog
• Database Security, tatata9999
• Re: The best way to use the Database Engine Tuning Advisor, Tommy Hayes
  • Re: The best way to use the Database Engine Tuning Advisor, abu hisham
    • Re: The best way to use the Database Engine Tuning Advisor, Tommy Hayes
      • Re: The best way to use the Database Engine Tuning Advisor, Tommy Hayes
• Alternate to cursors, srirangam . seshadri
  • Re: Alternate to cursors, Roy Harvey (SQL Server MVP)
• web database question, Sue
  • Re: web database question, Jack Vamvas
  • Re: web database question, Erland Sommarskog
• Re: replication, aleu@xxxxx

We are proud to have Web Hosting and Rack Housing from 9 Net Avenue Deutschland.
(15)