SQLServerCentral.com Content tagged Advanced Querying, SQL Server 7, 2000http://www.sqlservercentral.com/Content tagged Advanced Querying, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Delimited String Parsing Functions - TwoCol sethttp://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/2008/11/03http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/Delimited String Parsing Functions - Basic Sethttp://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/2008/10/20http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/Delimited String Parsing Functions - Big Set
SQL Response SQL Server monitoring made easy
"Keeping an eye on our many SQL Server instances
is much easier with SQL Response." Mike Lile.
Download a free trial of SQL Response now.
]]>http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/Counter Table (table of numbers) Setter-Upper for SQL Server 2000http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/Encrypting Data With the Encrypt Functionhttp://www.sqlservercentral.com/articles/Security/encryptfunction/372/2006/05/29http://www.sqlservercentral.com/articles/Security/encryptfunction/372/Execution Planshttp://www.sqlservercentral.com/articles/Administration/executionplans/1345/2005/10/07http://www.sqlservercentral.com/articles/Administration/executionplans/1345/Push FTP with SQL Serverhttp://www.sqlservercentral.com/articles/Administration/pushftp/473/2005/07/01http://www.sqlservercentral.com/articles/Administration/pushftp/473/Using Xp_sendmail With the Recipients Generated From a Queryhttp://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/2005/02/18http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/Case Sensitivity in Selects - Part 2http://www.sqlservercentral.com/articles/Administration/casesensitivityinselectspart2/1412/2004/06/22http://www.sqlservercentral.com/articles/Administration/casesensitivityinselectspart2/1412/Case Sensitivity in Selects - Part 3http://www.sqlservercentral.com/articles/Administration/casesensitivityinselectspart3/1388/2004/06/15http://www.sqlservercentral.com/articles/Administration/casesensitivityinselectspart3/1388/Making Good Use of Sysforeignkeys Table - Part 1: Display table relatihttp://www.sqlservercentral.com/articles/Administration/makinggooduseofsysforeignkeystablepart1displaytabl/1364/2004/06/01http://www.sqlservercentral.com/articles/Administration/makinggooduseofsysforeignkeystablepart1displaytabl/1364/Creating a System Stored Procedure
SQL Backup Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.
]]>http://www.sqlservercentral.com/articles/Administration/creatingasystemstoredprocedure/1358/2004/05/20http://www.sqlservercentral.com/articles/Administration/creatingasystemstoredprocedure/1358/Execution Planshttp://www.sqlservercentral.com/articles/Administration/executionplans/1345/2005/10/07http://www.sqlservercentral.com/articles/Administration/executionplans/1345/The SQL Server Black Boxhttp://www.sqlservercentral.com/articles/Administration/blackbox/954/2003/04/11http://www.sqlservercentral.com/articles/Administration/blackbox/954/Utilizing fn_virtualfilestatshttp://www.sqlservercentral.com/articles/Administration/filestatsexample/862/2002/12/04http://www.sqlservercentral.com/articles/Administration/filestatsexample/862/Using Bitwise Operators to Boost Performancehttp://www.sqlservercentral.com/articles/Performance+Tuning/usingbitmaskoperators/790/2002/09/05http://www.sqlservercentral.com/articles/Performance+Tuning/usingbitmaskoperators/790/Understanding Execution Plans Part 1http://www.sqlservercentral.com/articles/Performance+Tuning/understandingexecutionplans/739/2002/07/26http://www.sqlservercentral.com/articles/Performance+Tuning/understandingexecutionplans/739/Creating your own sp_MSforeach stored procedurehttp://www.sqlservercentral.com/articles/Administration/sp_msforeachworker/711/2002/06/17http://www.sqlservercentral.com/articles/Administration/sp_msforeachworker/711/Auditing Your SQL Server Environment Part II Auditing Your SQL Server
SQL Response Too many SQL Servers to keep up with?
Download a free trial of SQL Response to monitor your
SQL Servers in just one intuitive interface."The monitoring
in SQL Response is excellent." Mike Towery.
]]>http://www.sqlservercentral.com/articles/Security/auditingii/697/2002/05/30http://www.sqlservercentral.com/articles/Security/auditingii/697/Making Dynamic Queries Statichttp://www.sqlservercentral.com/articles/Performance+Tuning/makingdynamicqueriesstatic/672/2002/05/02http://www.sqlservercentral.com/articles/Performance+Tuning/makingdynamicqueriesstatic/672/Auditing Your SQL Server Environment Part Ihttp://www.sqlservercentral.com/articles/Security/newenvironmentparti/653/2002/04/02http://www.sqlservercentral.com/articles/Security/newenvironmentparti/653/Push FTP with SQL Serverhttp://www.sqlservercentral.com/articles/Administration/pushftp/473/2005/07/01http://www.sqlservercentral.com/articles/Administration/pushftp/473/Executing a script from SQL Serverhttp://www.sqlservercentral.com/articles/Administration/scriptscheduling/450/2001/10/17http://www.sqlservercentral.com/articles/Administration/scriptscheduling/450/DBCC SQLPERF (Logspace) Reporting Internalshttp://www.sqlservercentral.com/redirect/articles/438/2001/09/17http://www.sqlservercentral.com/redirect/articles/438/Using Java to Encrypt Passwordshttp://www.sqlservercentral.com/articles/Security/usingjavatoencryptpasswords/357/2001/07/19http://www.sqlservercentral.com/articles/Security/usingjavatoencryptpasswords/357/Encrypting Data With the Encrypt Functionhttp://www.sqlservercentral.com/articles/Security/encryptfunction/372/2006/05/29http://www.sqlservercentral.com/articles/Security/encryptfunction/372/Using Xp_sendmail With the Recipients Generated From a Query
SQL Response SQL Server monitoring made easy
"Keeping an eye on our many SQL Server instances
is much easier with SQL Response." Mike Lile.
Download a free trial of SQL Response now.
]]>http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/2005/02/18http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/Undocumented T-SQL Tricks With Logshttp://www.sqlservercentral.com/articles/Administration/readpurgelog/279/2001/06/27http://www.sqlservercentral.com/articles/Administration/readpurgelog/279/Quickly Enabling and Disabling Constraints and Triggershttp://www.sqlservercentral.com/articles/Administration/enabledisable/177/2001/05/24http://www.sqlservercentral.com/articles/Administration/enabledisable/177/