comp.databases.ms-sqlserver

• Date Index

• SQL Help with purging old data, The Man
• Stored procedure to create a new database with tables, Shiller
  • Re: Stored procedure to create a new database with tables, Massimo-Mastino
    • Re: Stored procedure to create a new database with tables, Shiller
      • Re: Stored procedure to create a new database with tables, Greg D. Moore \(Strider\)
      • Re: Stored procedure to create a new database with tables, AlterEgo
      • Re: Stored procedure to create a new database with tables, Shiller
• Does anyone use SSIS for database schema maintenance?, Ben
• Need help with CONVERT function, Wes Peters
  • Re: Need help with CONVERT function, Plamen Ratchev
• How to view all triggers, kwilla
  • Re: How to view all triggers, MC
    • Re: How to view all triggers, kwilla
• Accessing which data caused a trigger to fire, jcandersen
  • Re: Accessing which data caused a trigger to fire, Dan Guzman
• Reading a directory, Utahduck
  • Re: Reading a directory, AlterEgo
  • Re: Reading a directory, Russ Rose
  • Re: Reading a directory, Jack Vamvas
• Help required!, madhumita . iyengar
  • Re: Help required!, Plamen Ratchev
  • Re: Help required!, dgk
  • Re: Help required!, dgk
• millions records archiving and delete, Massimo
  • Re: millions records archiving and delete, Erland Sommarskog
    • Re: millions records archiving and delete, Mastino
• help with a query, Sam
  • Re: help with a query, AlterEgo
  • Re: help with a query, Ed Murphy
  • Re: help with a query, --CELKO--
    • Re: help with a query, Ed Murphy
      • Re: help with a query, --CELKO--
• SQL mail work around, jlaustill@xxxxxxxxx
  • Re: SQL mail work around, Greg D. Moore \(Strider\)
  • Re: SQL mail work around, AlterEgo
    • Re: SQL mail work around, jlaustill@xxxxxxxxx
• return duplicate records, alex
  • Re: return duplicate records, Steve Kass
  • Re: return duplicate records, --CELKO--
• export/import, othellomy
  • Re: export/import, Dan Guzman
    • Re: export/import, othellomy
• Importing DTS package to SSIS under x64 More options, fboweb.com
• newbe question: need a way to read in large query with .net, troy
  • Re: newbe question: need a way to read in large query with .net, Erland Sommarskog
    • Re: newbe question: need a way to read in large query with .net, troy
      • Re: newbe question: need a way to read in large query with .net, Erland Sommarskog
  • Re: newbe question: need a way to read in large query with .net, Carl Tegeder
• which driver to use to make a linked server connection between MSSQL 2005 and Access 2007, doron . almog
• nvarchar & varchar, haidani
  • Re: nvarchar & varchar, Plamen Ratchev
    • Re: nvarchar & varchar, oliver
      • Re: nvarchar & varchar, Michael
  • Re: nvarchar & varchar, Carl Tegeder
    • Re: nvarchar & varchar, Ed Murphy
• maintaining a database?, oraustin
  • Re: maintaining a database?, www.ITjobfeed.com
• file share, nick
  • Re: file share, Erland Sommarskog
    • Re: file share, Carl Tegeder
• faster count(*) or alternative, C10B
  • Re: faster count(*) or alternative, Greg D. Moore \(Strider\)
  • Re: faster count(*) or alternative, Erland Sommarskog
  • Re: faster count(*) or alternative, Russ Rose
    • Re: faster count(*) or alternative, C10B
      • Re: faster count(*) or alternative, Erland Sommarskog
      • Re: faster count(*) or alternative, Russ Rose
  • <Possible follow-ups>
  • faster count(*) or alternative, C10B
    • Re: faster count(*) or alternative, C10B
      • Re: faster count(*) or alternative, Erland Sommarskog
      • Re: faster count(*) or alternative, C10B
      • Re: faster count(*) or alternative, Greg D. Moore \(Strider\)
      • Re: faster count(*) or alternative, C10B
      • Re: faster count(*) or alternative, Greg D. Moore \(Strider\)
      • Re: faster count(*) or alternative, Erland Sommarskog
      • Re: faster count(*) or alternative, Erland Sommarskog
• SQL Challenge - how to return a record set starting at a particular record?, michealp
  • Re: SQL Challenge - how to return a record set starting at a particular record?, Russ Rose
  • Re: SQL Challenge - how to return a record set starting at a particular record?, Ed Murphy
    • Re: SQL Challenge - how to return a record set starting at a particular record?, Erland Sommarskog
      • Re: SQL Challenge - how to return a record set starting at a particular record?, Greg D. Moore \(Strider\)
• unable to specify UNC path for restore through GUI??, KR
  • Re: unable to specify UNC path for restore through GUI??, Erland Sommarskog
• Help, did SP1 install work?? SQL Server 2005, kataoki
  • Re: Help, did SP1 install work?? SQL Server 2005, Erland Sommarskog
• constraints across normalized tables, Emin
  • Re: constraints across normalized tables, Erland Sommarskog
  • Re: constraints across normalized tables, --CELKO--
    • Re: constraints across normalized tables, Erland Sommarskog
      • Re: constraints across normalized tables, --CELKO--
      • Re: constraints across normalized tables, Ed Murphy
  • Re: constraints across normalized tables, Gert-Jan Strik
• SQL Help, The Man
  • Re: SQL Help, Greg D. Moore \(Strider\)
    • Re: SQL Help, The Man
  • Re: SQL Help, Erland Sommarskog
    • Re: SQL Help, The Man
      • Re: SQL Help, Erland Sommarskog
      • Re: SQL Help, The Man
• SQL 2005 compatability mode, jsmall
  • Re: SQL 2005 compatability mode, Erland Sommarskog
• ASP cannot run stored proc until the web user has run the proc in Query Analyzer, central_scrutinizer
  • Re: ASP cannot run stored proc until the web user has run the proc in Query Analyzer, AlterEgo
• SQL error, Duffey
  • Re: SQL error, Erland Sommarskog
    • Re: SQL error, Duffey
      • Re: SQL error, Utahduck
      • Re: SQL error, Erland Sommarskog
• Query for the first and latest wish, Eugene
  • Re: Query for the first and latest wish, Utahduck
    • Re: Query for the first and latest wish, Eugene
      • Re: Query for the first and latest wish, Utahduck
  • Re: Query for the first and latest wish, Erland Sommarskog
    • Re: Query for the first and latest wish, Eugene
    • Re: Query for the first and latest wish, Eugene
  • Re: Query for the first and latest wish, Ed Murphy
• How to run replace on all columns, JackpipE
  • Re: How to run replace on all columns, Erland Sommarskog
    • Re: How to run replace on all columns, JackpipE
      • Re: How to run replace on all columns, Roy Harvey
      • Re: How to run replace on all columns, JackpipE
      • Re: How to run replace on all columns, Roy Harvey
      • Re: How to run replace on all columns, Roy Harvey
• Re: test, Utahduck
  • Re: test, Ed Murphy
• Format money value as padded string, paulmac106
  • Re: Format money value as padded string, Roy Harvey
    • Re: Format money value as padded string, Utahduck
      • Re: Format money value as padded string, paulmac106
      • Re: Format money value as padded string, Erland Sommarskog
      • Re: Format money value as padded string, paulmac106
      • Re: Format money value as padded string, Erland Sommarskog
      • Re: Format money value as padded string, Steve Kass
• SQL statement - INSERT INTO and SELECT, dhek
  • Re: SQL statement - INSERT INTO and SELECT, Utahduck
    • Re: SQL statement - INSERT INTO and SELECT, dhek
      • Re: SQL statement - INSERT INTO and SELECT, Ed Murphy
      • Re: SQL statement - INSERT INTO and SELECT, dhek
      • Re: SQL statement - INSERT INTO and SELECT, Utahduck
      • Re: SQL statement - INSERT INTO and SELECT, dhek
• error for sending(saving) data to database, projectid2007
  • Re: error for sending(saving) data to database, Erland Sommarskog
• Insert Date as Formatted String, paulmac106
  • Re: Insert Date as Formatted String, Erland Sommarskog
    • Re: Insert Date as Formatted String, paulmac106
  • Re: Insert Date as Formatted String, Utahduck
• T-SQL for the following?, Mark Probert
  • Re: T-SQL for the following?, KenJ
  • Re: T-SQL for the following?, Ed Murphy
    • Re: T-SQL for the following?, Mark Probert
• timeout or re-trys., tolcis
• Replication and Reports, tolcis
• Use RTRIM function on TEXTBLOB (text) field, Mintyman
  • Re: Use RTRIM function on TEXTBLOB (text) field, Erland Sommarskog
    • Re: Use RTRIM function on TEXTBLOB (text) field, Mintyman
      • Re: Use RTRIM function on TEXTBLOB (text) field, Erland Sommarskog
    • Re: Use RTRIM function on TEXTBLOB (text) field, Greg D. Moore \(Strider\)
• Unicode characters (Japanese), DL
  • Re: Unicode characters (Japanese), Erland Sommarskog
    • Re: Unicode characters (Japanese), DL
    • Re: Unicode characters (Japanese), DL
      • Re: Unicode characters (Japanese), Erland Sommarskog
• How to run profiler from cmd, Thyagu
  • Re: How to run profiler from cmd, Plamen Ratchev
• What is the best availability and backup solution?, Daniel.Peaper@xxxxxxxxx
  • Re: What is the best availability and backup solution?, Greg D. Moore \(Strider\)
    • Re: What is the best availability and backup solution?, Daniel.Peaper@xxxxxxxxx
• Storing variable values whilst using cursors, archanapatelwhite
  • Re: Storing variable values whilst using cursors, Russ Rose
• Subquery and display help, archanapatelwhite
  • Re: Subquery and display help, KenJ
    • Re: Subquery and display help, Erland Sommarskog
• Is there a Query Analyzer, click37
  • Re: Is there a Query Analyzer, Josh Assing
    • Re: Is there a Query Analyzer, click37
      • Re: Is there a Query Analyzer, Robert Klemme
• Partition Scheme using a function, eavery
  • Re: Partition Scheme using a function, Erland Sommarskog
    • Re: Partition Scheme using a function, eavery
      • Re: Partition Scheme using a function, Erland Sommarskog
      • Re: Partition Scheme using a function, eavery
• Stored Procedure, error when executing (, Goog79
  • Re: Stored Procedure, error when executing (, Goog79
  • Re: Stored Procedure, error when executing (, Greg D. Moore \(Strider\)
  • Re: Stored Procedure, error when executing (, Erland Sommarskog
• Restore SQL DB with correct logical file names, blueboy
  • Re: Restore SQL DB with correct logical file names, Jonathan Roberts
    • Re: Restore SQL DB with correct logical file names, blueboy
      • Re: Restore SQL DB with correct logical file names, Erland Sommarskog
      • Re: Restore SQL DB with correct logical file names, blueboy
      • Re: Restore SQL DB with correct logical file names, Erland Sommarskog
      • Re: Restore SQL DB with correct logical file names, blueboy
      • Re: Restore SQL DB with correct logical file names, Greg D. Moore \(Strider\)
      • Re: Restore SQL DB with correct logical file names, blueboy
      • Re: Restore SQL DB with correct logical file names, Erland Sommarskog
      • Re: Restore SQL DB with correct logical file names, blueboy
      • Re: Restore SQL DB with correct logical file names, Erland Sommarskog
      • Re: Restore SQL DB with correct logical file names, blueboy
      • Re: Restore SQL DB with correct logical file names, Erland Sommarskog
• simple SQL question to insert records in an existing table - Newbie, pamela fluente
  • Re: simple SQL question to insert records in an existing table - Newbie, Plamen Ratchev
    • Re: simple SQL question to insert records in an existing table - Newbie, jim_geissman
      • Re: simple SQL question to insert records in an existing table - Newbie, pamela fluente
      • Re: simple SQL question to insert records in an existing table - Newbie, Plamen Ratchev
      • Re: simple SQL question to insert records in an existing table - Newbie, pamela fluente
• Function to return "remaining" of field after it finds a character in the field., Jorgen [DK/2600]
  • Re: Function to return "remaining" of field after it finds a character in the field., Jorgen [DK/2600]
• Simple function for returning a character based on search criteria.., Jorgen [DK/2600]
  • Re: Simple function for returning a character based on search criteria.., Jorgen [DK/2600]
    • Re: Simple function for returning a character based on search criteria.., Erland Sommarskog
• Support for Spanish and English language, jackal_on_work
  • Re: Support for Spanish and English language, Erland Sommarskog
• Newbie with SQL Server Trigger, ricardo . sobral . santos
  • Re: Newbie with SQL Server Trigger, Erland Sommarskog
    • Re: Newbie with SQL Server Trigger, ricardo . sobral . santos
      • Re: Newbie with SQL Server Trigger, Erland Sommarskog
• Stored procedure, Krij
  • Re: Stored procedure, Dan Guzman
    • Re: Stored procedure, Krij
• SELECT *, Wes Groleau
  • Re: SELECT *, Roy Harvey
    • Re: SELECT *, Erland Sommarskog
  • Re: SELECT *, --CELKO--
• adding the vc express bundled sql server to odbc, Chuck
  • Re: adding the vc express bundled sql server to odbc, Erland Sommarskog
• Performance of SPROC changed by dbo. prefix, teddysnips
  • Re: Performance of SPROC changed by dbo. prefix, Greg D. Moore \(Strider\)
  • Re: Performance of SPROC changed by dbo. prefix, Gert-Jan Strik
    • Re: Performance of SPROC changed by dbo. prefix, Greg D. Moore \(Strider\)
    • Re: Performance of SPROC changed by dbo. prefix, teddysnips
      • Re: Performance of SPROC changed by dbo. prefix, Erland Sommarskog
  • Re: Performance of SPROC changed by dbo. prefix, Erland Sommarskog
• Fresh SQL Server 2005 giving problem in accessing access 97 file through Jet Ole DB Provider, rathi . vis
• sql server 2000 robo copy, shark
  • Re: sql server 2000 robo copy, Greg D. Moore \(Strider\)
• count records in several months, Sjef ten Koppel
  • Re: count records in several months, MC
  • Re: count records in several months, Delerium
• SQL Server Runtime?, Vincent
  • Re: SQL Server Runtime?, Greg D. Moore \(Strider\)
  • Re: SQL Server Runtime?, Erland Sommarskog
• SQL Server Link Server, Vincent
  • Re: SQL Server Link Server, Erland Sommarskog
• query, rrghosh
  • Re: query, Connie
• sum a table within a table, solonzenetzis
  • Re: sum a table within a table, Erland Sommarskog
  • Re: sum a table within a table, Ed Murphy
• Question on deploying .SQL files, Sandeep Madduri's group
  • Re: Question on deploying .SQL files, Erland Sommarskog
• A trick query., Rick
  • Re: A trick query., MC
• SQL 2005 AND SQLXMLBulkLoad, richard
  • <Possible follow-ups>
  • SQL 2005 AND SQLXMLBulkLoad, rrowles2000
    • Re: SQL 2005 AND SQLXMLBulkLoad, Standards Guy
• Connecting Sql Server 2005 on Windows 2003 using ASP local, kk035
  • Re: Connecting Sql Server 2005 on Windows 2003 using ASP local, Erland Sommarskog
    • Re: Connecting Sql Server 2005 on Windows 2003 using ASP local, kk035
      • Re: Connecting Sql Server 2005 on Windows 2003 using ASP local, Erland Sommarskog
      • Re: Connecting Sql Server 2005 on Windows 2003 using ASP local, kk035
      • Re: Connecting Sql Server 2005 on Windows 2003 using ASP local, Erland Sommarskog
• Full bakup of Data, shiju
  • Re: Full bakup of Data, Erland Sommarskog
• Change Object Ownership, berwiki
  • Re: Change Object Ownership, Erland Sommarskog
• T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?, DanWeaver
  • Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?, Erland Sommarskog
    • Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?, DanWeaver
      • Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?, Erland Sommarskog
      • Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?, DanWeaver
      • Message not available
      • Re: T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?, DanWeaver
• Possibilities to restore an old database, Alvin
  • Re: Possibilities to restore an old database, Erland Sommarskog
• trying to group by two diff criteria, dn.perl@xxxxxxxxx
  • Re: trying to group by two diff criteria, Erland Sommarskog
• Encrypting mdf files, rsm
  • Re: Encrypting mdf files, Erland Sommarskog
  • Re: Encrypting mdf files, David Portas
    • Re: Encrypting mdf files, rsm
      • Re: Encrypting mdf files, Greg D. Moore \(Strider\)
• Syntax, please :-((((((((((((((, Radu
  • Re: Syntax, please :-((((((((((((((, Gert-Jan Strik
  • Re: Syntax, please :-((((((((((((((, Erland Sommarskog
    • Re: Syntax, please :-((((((((((((((, Radu
• show number of values as % of total records..?, Otto
  • Re: show number of values as % of total records..?, Erland Sommarskog
    • Re: show number of values as % of total records..?, Otto
      • Re: show number of values as % of total records..?, Erland Sommarskog
• Blobs in SQL Server, Connie
  • Re: Blobs in SQL Server, Erland Sommarskog
    • Re: Blobs in SQL Server, Connie
• Kill connection, DaveP
  • Re: Kill connection, Erland Sommarskog
• Performance, Mark
  • Re: Performance, Ed Murphy
  • Re: Performance, Greg D. Moore \(Strider\)
  • Re: Performance, Erland Sommarskog
• Sql server process memory question, caspervt
  • Re: Sql server process memory question, Greg D. Moore \(Strider\)
    • Re: Sql server process memory question, caspervt
  • Re: Sql server process memory question, Erland Sommarskog
• Merging contents of one db to another huge db., Chandra
  • Re: Merging contents of one db to another huge db., Erland Sommarskog
• Replace Multiple Spaces with One Space?, Joe Cool
  • Re: Replace Multiple Spaces with One Space?, Russ Rose
    • Re: Replace Multiple Spaces with One Space?, Joe Cool
      • Re: Replace Multiple Spaces with One Space?, Ed Murphy
      • Re: Replace Multiple Spaces with One Space?, Russ Rose
      • Re: Replace Multiple Spaces with One Space?, Ed Murphy
  • Re: Replace Multiple Spaces with One Space?, --CELKO--
• Backup and restore database hourly: how to implement it?, danceli
  • Re: Backup and restore database hourly: how to implement it?, Greg D. Moore \(Strider\)
    • Re: Backup and restore database hourly: how to implement it?, danceli
      • Re: Backup and restore database hourly: how to implement it?, Greg D. Moore \(Strider\)
      • Re: Backup and restore database hourly: how to implement it?, danceli
      • Re: Backup and restore database hourly: how to implement it?, Greg D. Moore \(Strider\)
      • Re: Backup and restore database hourly: how to implement it?, danceli
      • Re: Backup and restore database hourly: how to implement it?, Greg D. Moore \(Strider\)
      • Re: Backup and restore database hourly: how to implement it?, Erland Sommarskog
      • Re: Backup and restore database hourly: how to implement it?, danceli
      • Re: Backup and restore database hourly: how to implement it?, Greg D. Moore \(Strider\)
      • Re: Backup and restore database hourly: how to implement it?, Jonathan Roberts
      • Re: Backup and restore database hourly: how to implement it?, Jonathan Roberts
      • Re: Backup and restore database hourly: how to implement it?, Greg D. Moore \(Strider\)
• export database structure, Xerxes
  • Re: export database structure, Russ Rose
• Delta compression of query results, Russell Wallace
  • Re: Delta compression of query results, Robert Klemme
  • Re: Delta compression of query results, BJMurphy
  • Re: Delta compression of query results, Erland Sommarskog
• in query, how can I compare string?, kirke
  • Re: in query, how can I compare string?, Erland Sommarskog
    • Re: in query, how can I compare string?, Ed Murphy
• Basic Questions, BJMurphy
  • Re: Basic Questions, Erland Sommarskog
    • Re: Basic Questions, BJMurphy
      • Re: Basic Questions, jim_geissman
      • Re: Basic Questions, BJMurphy
      • Re: Basic Questions, Erland Sommarskog
      • Re: Basic Questions, Erland Sommarskog
• Project Planning, PP
  • Re: Project Planning, Erland Sommarskog
• Can't Connect to SQL db, DanWeaver
  • <Possible follow-ups>
  • Can't Connect to SQL db, DanWeaver
    • Re: Can't Connect to SQL db, Erland Sommarskog
      • Re: Can't Connect to SQL db, DanWeaver
      • Re: Can't Connect to SQL db, Erland Sommarskog
      • Re: Can't Connect to SQL db, DanWeaver
• Memory Config (2005 Standard + x64 Win2k3 Enterprise), paholmes
• for zared: highly trustable long retention - fahbi - (1/1), hodge
• scripting data, farseer
  • Re: scripting data, Mork69
  • Re: scripting data, Erland Sommarskog
• Java DatabaseMetaData and MS SQL 2005, jweaver
  • Re: Java DatabaseMetaData and MS SQL 2005, Erland Sommarskog
• attn: tiphanie - truly energetic postings - ifja wur - (1/1), robb
• returning one single record rather than multiples, Lee
  • Re: returning one single record rather than multiples, Erland Sommarskog
    • Re: returning one single record rather than multiples, Lee
      • Re: returning one single record rather than multiples, Plamen Ratchev
• Callable statements, SQLServer and JRun, cormac . foley
  • Re: Callable statements, SQLServer and JRun, Erland Sommarskog
    • Re: Callable statements, SQLServer and JRun, cormac . foley
  • <Possible follow-ups>
  • Callable statements, SQLServer and JRun, cormac . foley
• DTAC Thailand Selects Yellowfin for Real-Time Business Intelligence, YellowFin Announcements
• SQL Format Function "0000", duprejonathan
  • Re: SQL Format Function "0000", Plamen Ratchev
    • Re: SQL Format Function "0000", Plamen Ratchev
      • Re: SQL Format Function "0000", duprejonathan
• Urgent: MS-BI (SQL Server 2005-AS/RS/IS)-CMM 5-Hyderabad (with possible onsite), WI Projects
• Migrating to 2005, need advice, tootsuite
  • Re: Migrating to 2005, need advice, Erland Sommarskog
  • Re: Migrating to 2005, need advice, Mork69
    • Re: Migrating to 2005, need advice, Erland Sommarskog
      • Re: Migrating to 2005, need advice, Mork69
• Problem with SQL server 2000, Rex
  • Re: Problem with SQL server 2000, Ed Murphy
  • Re: Problem with SQL server 2000, Erland Sommarskog
• Problems loading SQL server 2000, Richard Deakin
  • Re: Problems loading SQL server 2000, Erland Sommarskog
• databases, lipuni
  • Re: databases, Jonathan Roberts
    • Re: databases, Russ Rose
• SSIS Import, Eric
  • Re: SSIS Import, AlterEgo
• sql 2005 upgrade problems, KR
  • Re: sql 2005 upgrade problems, Erland Sommarskog
  • Re: sql 2005 upgrade problems, GZ
• Log File is Full error: How to prevent this happening?, danceli
  • Re: Log File is Full error: How to prevent this happening?, Erland Sommarskog
    • Re: Log File is Full error: How to prevent this happening?, GZ
      • Re: Log File is Full error: How to prevent this happening?, Erland Sommarskog
• Can't connect to SQL Server(SQL Express) in VS 2005, DanWeaver
  • Re: Can't connect to SQL Server(SQL Express) in VS 2005, Erland Sommarskog
    • Re: Can't connect to SQL Server(SQL Express) in VS 2005, DanWeaver
• Large number of INSERT statements - not all are executed, Dmitri
  • Re: Large number of INSERT statements - not all are executed, AlterEgo
  • Re: Large number of INSERT statements - not all are executed, Erland Sommarskog
• Learning SQL Server with Win XP Home, DanWeaver
  • Message not available
    • Re: Learning SQL Server with Win XP Home, DanWeaver
• get record with earliest datetime value, hharry
  • Re: get record with earliest datetime value, SQLJunkie
    • Re: get record with earliest datetime value, hharry
      • Re: get record with earliest datetime value, Plamen Ratchev
• Where is my dts?, othellomy
  • Re: Where is my dts?, Dan Guzman
    • Re: Where is my dts?, othellomy
      • Re: Where is my dts?, othellomy
      • Re: Where is my dts?, Dan Guzman
• Creating maintenance plan wizard problem, Zvonko Biškup
• Optimizing a big query, Merennulli
  • Re: Optimizing a big query, Steve
    • Re: Optimizing a big query, Merennulli
  • Re: Optimizing a big query, Dan Guzman
  • Re: Optimizing a big query, Erland Sommarskog
    • Re: Optimizing a big query, Merennulli
• Backup fails using SMO with big databases, sjoshi
  • Re: Backup fails using SMO with big databases, GZ
• Full date value not being written via JDBC - any ideas?, MackTheKnife
  • Re: Full date value not being written via JDBC - any ideas?, Erland Sommarskog
  • Re: Full date value not being written via JDBC - any ideas?, joeNOSPAM@xxxxxxx
• Effective permission for a group, akkha1234@xxxxxxxxx
  • Re: Effective permission for a group, Erland Sommarskog
• Need advice on system performance, tootsuite
  • Re: Need advice on system performance, AlterEgo
    • Re: Need advice on system performance, tootsuite
• xp_cmdshell sql server 2000, shark
  • Re: xp_cmdshell sql server 2000, Erland Sommarskog
• Column update structure change, DaveP
  • Re: Column update structure change, AlterEgo
    • Re: Column update structure change, Erland Sommarskog
  • Re: Column update structure change, Erland Sommarskog
    • Re: Column update structure change, DaveP
• Need help running query on data/time field, Techhead
  • Re: Need help running query on data/time field, Plamen Ratchev
    • Re: Need help running query on data/time field, Techhead
      • Re: Need help running query on data/time field, Techhead
      • Re: Need help running query on data/time field, Plamen Ratchev
      • Re: Need help running query on data/time field, Techhead
      • Re: Need help running query on data/time field, Plamen Ratchev
  • Re: Need help running query on data/time field, Erland Sommarskog
• odd stored procedure behavior, brianlanning
  • Re: odd stored procedure behavior, Erland Sommarskog
• Locate rows in table where column value missing (I think!), teddysnips
  • Re: Locate rows in table where column value missing (I think!), Plamen Ratchev
    • Re: Locate rows in table where column value missing (I think!), teddysnips
• Why optimizer is not smart? Is dynamic SQL my only option..., serge
  • Re: Why optimizer is not smart? Is dynamic SQL my only option..., Erland Sommarskog
  • Re: Why optimizer is not smart? Is dynamic SQL my only option..., Dan Guzman
• Date function, tolcis
  • Re: Date function, Erland Sommarskog
• Dynamic SQL does not work!, SQLJunkie
  • Re: Dynamic SQL does not work!, Steve
  • Re: Dynamic SQL does not work!, Erland Sommarskog
    • Re: Dynamic SQL does not work!, SQLJunkie
      • Re: Dynamic SQL does not work!, Erland Sommarskog
      • Re: Dynamic SQL does not work!, SQLJunkie
• SQL Server 2005: Unable to add SQL2000 subscriptor using non-standard port!, basuritta
• Connecting SQL 2000 using SQL 2005, Taw
  • Re: Connecting SQL 2000 using SQL 2005, Erland Sommarskog
    • Re: Connecting SQL 2000 using SQL 2005, pb648174
    • Re: Connecting SQL 2000 using SQL 2005, Taw
      • Re: Connecting SQL 2000 using SQL 2005, Erland Sommarskog
• Monitoring memory usage, aleu@xxxxx
• Stored Procedure querying another database, mkarbarz@xxxxxxxxx
  • Re: Stored Procedure querying another database, Steve
    • Re: Stored Procedure querying another database, mkarbarz@xxxxxxxxx
      • Re: Stored Procedure querying another database, Erland Sommarskog
      • Re: Stored Procedure querying another database, mkarbarz@xxxxxxxxx
      • Re: Stored Procedure querying another database, AlterEgo
      • Re: Stored Procedure querying another database, AlterEgo
      • Re: Stored Procedure querying another database, mkarbarz@xxxxxxxxx
• Query RowVersion in SQL Server 2005, Guedes
  • Re: Query RowVersion in SQL Server 2005, Erland Sommarskog
• Who Turned off the SQL Server AGENT???!!!!, robboll
  • Re: Who Turned off the SQL Server AGENT???!!!!, AlterEgo
    • Re: Who Turned off the SQL Server AGENT???!!!!, robboll
      • Re: Who Turned off the SQL Server AGENT???!!!!, AlterEgo
      • Re: Who Turned off the SQL Server AGENT???!!!!, robboll
      • Re: Who Turned off the SQL Server AGENT???!!!!, AlterEgo
      • Re: Who Turned off the SQL Server AGENT???!!!!, robboll
• looking for a consultant, dave1678
• "insert on existing update" in MS SQL Server?, Bart op de grote markt
  • Re: "insert on existing update" in MS SQL Server?, Serge Rielau
  • Re: "insert on existing update" in MS SQL Server?, Erland Sommarskog
  • Re: "insert on existing update" in MS SQL Server?, Bart op de grote markt
  • Re: "insert on existing update" in MS SQL Server?, Alex Kuznetsov
• NULLS and '', Paul
  • Re: NULLS and '', Steve
    • Re: NULLS and '', Paul
      • Re: NULLS and '', Plamen Ratchev
      • Re: NULLS and '', Paul
      • Re: NULLS and '', Steve
      • Re: NULLS and '', Plamen Ratchev
      • Re: NULLS and '', Erland Sommarskog
      • Re: NULLS and '', Paul
      • Re: NULLS and '', Paul
      • Re: NULLS and '', Paul
      • Re: NULLS and '', Alex Kuznetsov
      • Re: NULLS and '', Paul
• SQL job error, paullie69
  • Re: SQL job error, Steve
    • Re: SQL job error, paullie69
• @@Error not catching error., trialproduct2004
  • Re: @@Error not catching error., Erland Sommarskog
  • Re: @@Error not catching error., Erland Sommarskog
• Migrating SQL logins with password, Chloe C
• Re: bcp & trigger: got missiing data in bcp out files, Razvan Socol
• great tool to compare data from two different queries, knightconsulting
  • Re: great tool to compare data from two different queries, Josh Assing
• Stored procedure and SQL Job Agent Task, vikram . mankar
  • Re: Stored procedure and SQL Job Agent Task, vikram . mankar
  • Re: Stored procedure and SQL Job Agent Task, Erland Sommarskog
    • Re: Stored procedure and SQL Job Agent Task, vikram . mankar
      • Re: Stored procedure and SQL Job Agent Task, Erland Sommarskog
      • Re: Stored procedure and SQL Job Agent Task, vikram . mankar
      • Re: Stored procedure and SQL Job Agent Task, Erland Sommarskog
      • Re: Stored procedure and SQL Job Agent Task, vikram . mankar
      • Re: Stored procedure and SQL Job Agent Task, Erland Sommarskog
      • Re: Stored procedure and SQL Job Agent Task, vikram . mankar
• MS SQL using TSQL via JAVA jdbc, asufty888
  • Re: MS SQL using TSQL via JAVA jdbc, Erland Sommarskog
  • Re: MS SQL using TSQL via JAVA jdbc, joeNOSPAM@xxxxxxx
• use of union in indexed views, Mr,Goody
  • Re: use of union in indexed views, Erland Sommarskog
• "ODBC--call failed" Error, Ben
  • Re: "ODBC--call failed" Error, AlterEgo
  • Re: "ODBC--call failed" Error, Erland Sommarskog
• Problem: Performance difference between MSDE and SQL Express 2005, HC
  • Re: Problem: Performance difference between MSDE and SQL Express 2005, Erland Sommarskog
    • Re: Problem: Performance difference between MSDE and SQL Express 2005, HC
      • Re: Problem: Performance difference between MSDE and SQL Express 2005, HC
      • Re: Problem: Performance difference between MSDE and SQL Express 2005, Erland Sommarskog
      • Re: Problem: Performance difference between MSDE and SQL Express 2005, HC
      • Re: Problem: Performance difference between MSDE and SQL Express 2005, HC
      • Re: Problem: Performance difference between MSDE and SQL Express 2005, Erland Sommarskog
      • Re: Problem: Performance difference between MSDE and SQL Express 2005, HC
      • Re: Problem: Performance difference between MSDE and SQL Express 2005, Erland Sommarskog
• Using DTS to migrate Access ot SQL Server, Wes Groleau
  • Re: Using DTS to migrate Access ot SQL Server, Jonathan Roberts
    • Re: Using DTS to migrate Access ot SQL Server, Erland Sommarskog
      • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
      • Re: Using DTS to migrate Access ot SQL Server, Jonathan Roberts
    • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
      • Re: Using DTS to migrate Access ot SQL Server, Jonathan Roberts
      • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
      • Re: Using DTS to migrate Access ot SQL Server, Erland Sommarskog
      • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
      • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
  • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
  • Re: Using DTS to migrate Access ot SQL Server, Steve
    • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
      • Re: Using DTS to migrate Access ot SQL Server, Ben
      • Re: Using DTS to migrate Access ot SQL Server, Wes Groleau
• Using LIKE in a CASE statement, alberto . estrada1
  • Re: Using LIKE in a CASE statement, Erland Sommarskog
  • Re: Using LIKE in a CASE statement, --CELKO--
    • Re: Using LIKE in a CASE statement, alberto . estrada1
      • Re: Using LIKE in a CASE statement, Erland Sommarskog
• Re: DTS and SOAP Web Service, Jonathan Roberts
• I don't understand this "server timeout", Wes Groleau
  • Re: I don't understand this "server timeout", Erland Sommarskog
    • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Erland Sommarskog
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Erland Sommarskog
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Erland Sommarskog
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Erland Sommarskog
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Erland Sommarskog
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Erland Sommarskog
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Erland Sommarskog
      • Re: I don't understand this "server timeout", Wes Groleau
      • Re: I don't understand this "server timeout", Wes Groleau
    • Re: I don't understand this "server timeout", Wes Groleau
• Doubt about SQL Server, aguzmanc
  • Re: Doubt about SQL Server, Erland Sommarskog
• replacing join operation in XML, Preeti . s83
  • Re: replacing join operation in XML, Erland Sommarskog
• How to remove rows where only part of the row is duplicated, andylole
  • Re: How to remove rows where only part of the row is duplicated, markc600
  • Re: How to remove rows where only part of the row is duplicated, Erland Sommarskog
    • Re: How to remove rows where only part of the row is duplicated, andylole
• SQL Slow from MSDE 2000 to SQL Express, HC
  • Message not available
    • Message not available
      • Re: SQL Slow from MSDE 2000 to SQL Express, Erland Sommarskog
      • Re: SQL Slow from MSDE 2000 to SQL Express, HC
      • Re: SQL Slow from MSDE 2000 to SQL Express, HC
      • Re: SQL Slow from MSDE 2000 to SQL Express, Erland Sommarskog
      • Re: SQL Slow from MSDE 2000 to SQL Express, HC
      • Re: SQL Slow from MSDE 2000 to SQL Express, HC
      • Re: SQL Slow from MSDE 2000 to SQL Express, Erland Sommarskog
      • Re: SQL Slow from MSDE 2000 to SQL Express, HC
• SQL a range in the all dataset, Wei ZOU
  • Re: SQL a range in the all dataset, AlterEgo
    • Re: SQL a range in the all dataset, Ed Murphy
  • Re: SQL a range in the all dataset, Steve
• any way to debug stored procedures without buying visual studio?, Jeff Kish
  • Re: any way to debug stored procedures without buying visual studio?, Erland Sommarskog
    • Re: any way to debug stored procedures without buying visual studio?, NRBOMMA
    • Re: any way to debug stored procedures without buying visual studio?, Jeff Kish
      • Re: any way to debug stored procedures without buying visual studio?, Erland Sommarskog
• Re: script to copy logins and users with all permissions, dunleav1
• Ansi SQL92 question, dunleav1
  • Re: Ansi SQL92 question, dunleav1
  • Re: Ansi SQL92 question, Serge Rielau
    • Re: Ansi SQL92 question, dunleav1
    • Re: Ansi SQL92 question, dunleav1
      • Re: Ansi SQL92 question, Erland Sommarskog
  • Re: Ansi SQL92 question, --CELKO--
• SQL Collation Problem, Ryan
  • Re: SQL Collation Problem, Ryan
  • Re: SQL Collation Problem, Erland Sommarskog
• Re: Why transaction gets promoted to Distributed transaction, joeNOSPAM@xxxxxxx
• monitoring applications querys, Fritz Franz
  • Re: monitoring applications querys, Robert Klemme
    • Re: monitoring applications querys, Fritz Franz
• MS SQL 2005: Where clause and optimizer, boa sema
  • Re: MS SQL 2005: Where clause and optimizer, Erland Sommarskog
    • Re: MS SQL 2005: Where clause and optimizer, boa sema
• Re: urgent requirement for project leader/apm required, Ed Murphy
• Re: how to compare value of two fileds and based on that insert value into third fileds, Ed Murphy
  • Re: how to compare value of two fileds and based on that insert value into third fileds, Tradeorganizer
• How do I determine the backup date of a restored Database..?, Query Builder
  • Re: How do I determine the backup date of a restored Database..?, Erland Sommarskog
• SQL Server 2005 order by date does not sort properly, Jer
  • Re: SQL Server 2005 order by date does not sort properly, Dan Guzman
  • Re: SQL Server 2005 order by date does not sort properly, Plamen Ratchev
  • Re: SQL Server 2005 order by date does not sort properly, Jer
    • Re: SQL Server 2005 order by date does not sort properly, Erland Sommarskog
• Re: Querying towards a responsive UI, Erland Sommarskog
  • Re: Querying towards a responsive UI, shripathikamath
    • Re: Querying towards a responsive UI, Erland Sommarskog
      • Re: Querying towards a responsive UI, shripathikamath
  • <Possible follow-ups>
  • Re: Querying towards a responsive UI, Plamen Ratchev
    • Re: Querying towards a responsive UI, Plamen Ratchev
    • Re: Querying towards a responsive UI, shripathikamath
      • Re: Querying towards a responsive UI, Plamen Ratchev
• Re: bcp and trigger: missing data in bcp out file, Erland Sommarskog
  • Re: bcp and trigger: missing data in bcp out file, Thyagu
• Re: SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases, Erland Sommarskog
  • Re: SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases, Mark D Powell
• Re: BCP error - missing data, Erland Sommarskog

• Security
• UNIX
• Linux
• Coding
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint