SEARCH RESULTS

Home  >  Search Results

results found for "" in order of relevance.

Only the top 100 results are shown. Refine your search for a smaller result set.


Updating Results
Updating Results
Total Results:100 - Showing Page: 1 of 6 << < > >>
SQL SERVER VS ORACLE: A Comparative Review-Part I (11/16/2009)

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso...

SQL Server 2008 Transact-SQL Optimization Tips (Part 1) (8/10/2011)

SQL Server 2008 Transact-SQL Optimization Tips (Part 1) Use compound operators ("+=", "-=", "*=", "/=", "%=", "&=", "^=&q...

SQL Server 2008 Transact-SQL Optimization Tips (Part 2) (8/17/2011)

SQL Server 2008 Transact-SQL Optimization Tips (Part 2) Try to use constraints instead of triggers, whenever possible. Constraints are much more efficient than triggers and can boost perf...

Tips for using jobs in SQL Server 2008 (4/27/2011)

Tips for using jobs in SQL Server 2008 Run the scheduled jobs during periods of low database access. To reduce the total SQL Server overhead, try to schedule SQL Server 2008 jobs during CPU ...

SQL CLR a new approach (10/31/2008)

Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso...

SQL Server 2005 Transact-SQL Optimization Tips (Part 1) (11/5/2008)

SQL Server 2005 Transact-SQL Optimization Tips (Part 1) Consider using the PIVOT option to create cross-tab queries. This is a new SQL Server 2005 feature. In SQL Server 2000 there was not a ...

Automation and T-SQL (6/17/2003)

Automation and T-SQL By Bill Wunder   T-SQL does 4 things well: select, insert, update, and delete. That’s not to say that you can’t write a select, insert, update or delete...

Yukon Delay (6/16/2003)

Yukon Delay... By Alex Gray   Last week it was reported that Microsoft have announced that they are putting back the release date of the next version of SQL Server ...

Installing & Upgrading to SQL Server 2005 (3/23/2006)

Installing & Upgrading to SQL Server 2005 by Robert Pearl Based on my attendance at SQL2K5 seminar on Installing and Upgrading, let's talk about what you’ll need to know before upgradin...

SQL VS ORACLE: A Comparative Review-Part II (11/23/2009)

Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso...

Useful undocumented SQL Server 2008 Agent Procedures (1/20/2010)

Useful undocumented SQL Server 2008 Agent Procedures SQL Server 2008 supports the following useful undocumented SQL Server Agent stored procedures: - sp_MSget_jobstate - sp_MSgetalertinf...

Practical Top 10 Tips For SQL Server Optimization (1/25/2010)

  While using SQL server, you can use these following  SQL Server Optimization   Tips in order to improve speed and performance of SQL server and reduce data redundancy.    ...

My First Experience with SQL Azure (7/25/2011)

My First Experience with SQL Azure By Chris Shaw There is so much news around the SQL Server world right now. If you haven’t been keeping up with it, you may be missing one of t...

[Msg]: RE: [sswug:sql2k] generate insert statement (12/18/2002)

Found the script in my archive... scripted by Nicole Welch --Moorthy CREATE proc sp_ScriptTableInsert @DatabaseName varchar(500), @ScriptSourceTable varchar(500), @DeleteExisting int = 1, ...

[Msg]: RE: [sswug:sql2k] Digest for sswug-sql2k@topica.com, issue 565 (1/29/2003)

Did you have a question? If so, please try again. Sharon -----Original Message----- From: Csillam, Frank M Mr HQ INSCOM [mailto:fmcsill@vulcan.belvoir.army.mil] Sent: Wednesday, January 29, 2...

[Msg]: RE: [sswug:sql2k] Digest for sswug-sql2k@topica.com, issue 565 (1/29/2003)

-----Original Message----- From: sswug-sql2k@topica.com [mailto:sswug-sql2k@topica.com] Sent: Wednesday, January 29, 2003 10:54 AM To: sswug-sql2k@topica.com Subject: Digest for sswug-sql2k@t...

DSNTEP2 aka Batch SPUFI (7/6/2006)

DSNTEP2 aka Batch SPUFI by Craig S. Mullins DSNTEP2 is an application program that can be used to issue DB2 dynamic SQL statements. It is sometimes referred to as “Batch SPUFI” because...