SQLHacks for Microsoft SQL Server

Home page

Administration

Dates & Times

Data Manipulation

FAQs

Optimization

Summaries

Site Map

About us

  • About us
  • Copyrights
  • Credits
  • Disclaimers
  • Guaranties
  • Privacy
  • Support policies

Feedback

Site

All Recent Changes

  • Main.HomePage . . . April 21, 2010, at 08:35 PM by Syv: noright/notitle
  • Site.LocalTemplates . . . April 21, 2010, at 07:04 PM by TheBoss: formatting
  • Site.RightBar . . . April 16, 2010, at 09:25 PM by TheBoss: created adsense for Google
  • Site.SiteMap . . . April 14, 2010, at 09:30 PM by Syv: changed title
  • Site.SideBar . . . April 14, 2010, at 09:29 PM by Syv: feedback formatting
  • Main.Feedback . . . April 14, 2010, at 09:24 PM by Syv Ritch: created
  • Administration.Administration . . . April 14, 2010, at 09:16 PM by Syv: ttilespaced
  • SiteAdmin.AuthUser . . . April 14, 2010, at 09:08 PM by ?: Added the boss & syv
  • Site.PageHeader . . . April 14, 2010, at 09:05 PM by ?: spacing
  • Site.SideBarFooter . . . April 14, 2010, at 08:57 PM by Syv Ritch: empty
  • About.Credits . . . April 14, 2010, at 02:21 PM by Syv Ritch: formatting
  • Walter.Walter . . . April 14, 2010, at 12:20 PM by Syv Ritch: deleted
  • Site.PageFooter . . . December 13, 2009, at 03:41 PM by Syv Ritch: Remove social bookmarks
  • Administration.Backup-Integrity-Check-Index-Optimization . . . November 24, 2009, at 06:18 PM by Syv Ritch: deleted
  • Retrieve.Xinvs . . . April 04, 2009, at 05:17 PM by ?:
  • Chris20090115.Chris20090115 . . . January 17, 2009, at 06:30 PM by ?:
  • Optimize.Not-Shrink . . . January 15, 2009, at 05:49 PM by Syv Ritch: Wording
  • FAQs.Connecton-SessionID . . . May 18, 2008, at 09:01 PM by Syv Ritch: Further explanations
  • FAQs.ProcessingLogic . . . May 18, 2008, at 04:46 PM by syv Ritch: Fixed keywords
  • Administration.Empty-Log . . . May 15, 2008, at 09:58 AM by Syv Ritch: Created
  • Administration.Transactions-In-Logs . . . May 12, 2008, at 01:53 PM by Syv Ritch: Created
  • Summary.Row-Count . . . May 08, 2008, at 11:39 AM by Syv Ritch: Created
  • Administration.Row-Count-Inaccurate . . . May 05, 2008, at 09:29 AM by Syv Ritch: Created
  • Administration.ShrinkDB-Backup-Logs . . . May 02, 2008, at 09:19 AM by Syv Ritch: Created
  • Administration.Difference-Performance-Monitor . . . April 23, 2008, at 05:59 PM by Syv Ritch: Created
  • Retrieve.Duplicates . . . April 09, 2008, at 01:42 PM by Syv Ritch: Applies to
  • Retrieve.InlineViews . . . March 11, 2008, at 02:18 PM by Syv Ritch: Formatting
  • Optimize.SmallDateTime . . . March 05, 2008, at 07:44 AM by syv Ritch: Formatting
  • Dates.DateFunctions . . . March 03, 2008, at 09:04 AM by Syv Ricth: Formatting
  • Optimize.SlowNegativeQueries . . . February 29, 2008, at 07:59 AM by Syv Ritch: Formatting
  • Dates.Monday-To-Frida . . . February 25, 2008, at 08:49 AM by Syv Ritch: Created
  • FAQs.Naming-Conventions . . . February 22, 2008, at 08:27 AM by Syv Ritch: Created
  • FAQs.Table-Names . . . February 21, 2008, at 07:39 AM by Syv Ritch: Created
  • FAQs.Index-Names . . . February 20, 2008, at 08:45 AM by Syv Ritch: Created
  • FAQs.Uptimes . . . February 19, 2008, at 08:17 AM by Svy Ritch: Created
  • Summary.Group-By-All . . . February 18, 2008, at 09:25 AM by Syv Ritch: Created
  • Administration.Db-Status . . . February 15, 2008, at 08:37 AM by Syv Ritch: Created
  • FAQs.Stored-Procedures-Text . . . February 14, 2008, at 02:14 PM by Syv Ritch: Wording
  • FAQs.Lock-Escalation . . . February 13, 2008, at 09:35 AM by Syv Ritch: Created
  • FAQs.Critical-System-Tables . . . February 12, 2008, at 09:45 AM by Syv Ritch: Created
  • Site.SocialBookmarkIcons . . . February 08, 2008, at 12:57 PM by Syv Ritch: Removed URLencode
  • FAQs.Dynamic-Views-2005 . . . February 08, 2008, at 09:29 AM by Syv Ritch: Formatting
  • Dates.UTC-Vs-Local-Time . . . February 07, 2008, at 11:19 AM by Syv Ritch: Created
  • Retrieve.Retrieve-Every-N-Row . . . February 05, 2008, at 09:43 AM by Syv Ritch: Created
  • Optimize.Release-Unused-Space . . . February 04, 2008, at 09:34 AM by Syv Ritch: Created
  • FAQs.Deprecated-System-Management-Views-2005 . . . February 01, 2008, at 09:18 AM by syv Ritch: Wording
  • Optimize.Deprecate-Text . . . January 31, 2008, at 09:30 AM by Syv Ritch: Created
  • Retrieve.Emulate-Boolean . . . January 30, 2008, at 09:02 AM by Syv Ritch: Wording
  • Administration.Memory-Usage . . . January 29, 2008, at 09:44 AM by Syv Ritch: Created
  • Retrieve.Round-Nearest-Point5 . . . January 28, 2008, at 09:13 AM by Syv Ritch: Created
  • Dates.Person-Age . . . January 25, 2008, at 02:30 PM by Syv Ritch: Created
  • Retrieve.File-Exist . . . January 24, 2008, at 08:53 AM by Syv Ritch: Created
  • Retrieve.Database-Exist . . . January 24, 2008, at 07:52 AM by Syv Ritch: Spelling
  • Administration.Stored-Procedures . . . January 22, 2008, at 01:07 PM by Syv Ritch: Clarifications
  • Retrieve.Isnumeric-problems . . . January 22, 2008, at 09:05 AM by Syv Ritch: Created
  • Administration.Dedicated-Administrator-Command-Line . . . January 21, 2008, at 08:55 AM by Syv Ritch: Created
  • Retrieve.Sort-Order . . . January 18, 2008, at 07:59 AM by Syv Ritch: Created
  • Administration.Remote-Dedicated-Administrator-Connection . . . January 17, 2008, at 08:53 AM by Syv Ritch: Created
  • Administration.Dedicated-Administrator-Connection-Studio . . . January 16, 2008, at 08:49 AM by Syv Ritch: Wording
  • Dates.Search-By-Month-Year . . . January 15, 2008, at 11:21 AM by Syv Ritch: Created
  • Dates.Search-By-Year . . . January 14, 2008, at 11:43 AM by Syv Ritch: Formatting
  • Optimize.Tempdb-Stats . . . January 11, 2008, at 09:53 AM by Syv Ritch: Created
  • Retrieve.Sort-Nulls-Last . . . January 10, 2008, at 09:51 AM by Syv Ritch: Created
  • Retrieve.Sort-IP-Address . . . January 09, 2008, at 09:18 AM by Syv Ritch: Further explanation
  • Retrieve.Remove-Blanks . . . January 08, 2008, at 07:53 AM by Syv Ritch: Wording
  • Administration.When-Was-Backup-Done . . . January 07, 2008, at 08:55 AM by Syv Ritch: Created
  • Administration.Restore-Verify-Only . . . January 04, 2008, at 12:13 PM by Syv Ritch: Attach broken.zip changed
  • Optimize.Unused_Indexes . . . January 03, 2008, at 09:45 AM by Syv Ritch: Created
  • Retrieve.Real-Random-Number . . . January 02, 2008, at 08:30 AM by Syv Ritch: Created
  • Administration.Happy-New-Year . . . December 24, 2007, at 02:42 PM by Syv Ritch: Moved earth
  • Dates.Best-Format-Date . . . December 20, 2007, at 08:43 AM by Syv Ritch: Created
  • Dates.Formatting-for-Readability . . . December 20, 2007, at 08:33 AM by Syv Ritch: Link to: Dates/Best-Format-Date
  • Optimize.Bcp-Vs-Bulk-Insert . . . December 19, 2007, at 09:55 AM by Syv Ritch: Created
  • Retrieve.Import-Web-Logs . . . December 18, 2007, at 09:42 AM by Syv Ritch: Icons, again
  • Retrieve.LogParser . . . December 17, 2007, at 06:50 PM by Syv Ritch: Wording/spelling
  • Summary.Grouping-Fixed-Size . . . December 14, 2007, at 09:13 AM by Syv Ritch: Created
  • Summary.GroupFixedNumberBuckets . . . December 14, 2007, at 09:09 AM by Syv Ritch: Link to: Summary.Grouping-Fixed-Size
  • Retrieve.Pagination-Like-Google . . . December 13, 2007, at 09:48 AM by Syv Ritch: Spelling
  • Retrieve.Eliminate-Repeating-Identical-Values . . . December 13, 2007, at 09:45 AM by Syv Ritch: Created
  • Summary.Summary-One-Row . . . December 12, 2007, at 07:43 AM by Syv Ritch: Created
  • Administration.Server-Info . . . December 11, 2007, at 08:18 AM by Syv Ritch: Created
  • Optimize.Procedure-Cache . . . December 10, 2007, at 08:18 AM by Syv Ritch: Created
  • Administration.Enable-More-Than-2gb . . . December 07, 2007, at 09:20 AM by Syv Ritch: Created
  • FAQs.So-Many-Ways . . . December 04, 2007, at 08:47 AM by Syv Ritch: Created
  • Administration.Applications-Connected . . . December 03, 2007, at 07:51 AM by Syv Ritch: Created
  • Optimize.Defragment-Data . . . November 30, 2007, at 09:04 AM by Syv Ritch: Created
  • Optimize.Fragmented-Data . . . November 30, 2007, at 08:36 AM by Syv Ritch: does not apply to MSSQL 2008
  • Optimize.IO-reads . . . November 28, 2007, at 11:58 AM by Syv Ritch: Created
  • Optimize.Fragmented-Data-2005 . . . November 26, 2007, at 07:40 AM by Syv Ritch: Created
  • Administration.Uptime . . . November 22, 2007, at 07:34 AM by Syv Ritch: Created
  • Administration.Free-Space . . . November 21, 2007, at 07:51 AM by Syv Ritch: Created
  • Administration.Read-Error-Logs . . . November 20, 2007, at 09:11 AM by Syv Ritch: Created
  • Optimize.Fast_Count . . . November 19, 2007, at 12:21 PM by Syv Ritch: Formatting
  • Dates.GroupByMonth . . . November 19, 2007, at 12:17 PM by Syv Ritch: Formatting
  • Optimize.Set-Nocount . . . November 17, 2007, at 01:24 PM by Syv Ritch: Change of title
  • Retrieve.Zero-Fill-Numbers . . . November 14, 2007, at 09:11 AM by Syv Ritch: Created
  • Retrieve.Cast-Strings . . . November 13, 2007, at 01:36 PM by Syv Ritch: Created
  • Retrieve.Round-Up-Round-Down . . . November 12, 2007, at 01:51 PM by Syv Ritch: Created
  • Administration.Monitor-Network-Activity . . . November 09, 2007, at 09:34 AM by Syv Ritch: Created
  • Administration.SQL-Server-Version . . . November 07, 2007, at 07:35 AM by Syv Ritch: Created
  • Administration.Server-IP-Address . . . November 06, 2007, at 10:57 AM by Syv Ritch: Created
  • Retrieve.Random-Numbers . . . November 05, 2007, at 07:36 AM by Syv Ritch: Created
  • Retrieve.Random-Not-Working . . . November 02, 2007, at 01:42 PM by Syv Ritch: Further explanations
  • Retrieve.Next_Identity . . . November 02, 2007, at 09:37 AM by Syv Ritch: Formatting
  • Dates.Group-By-Week . . . November 01, 2007, at 10:01 AM by Syv Ritch: Created
  • Summary.First-Last . . . October 31, 2007, at 08:01 AM by Syv Ritch: Created
  • Summary.RowsWithSubtotals . . . October 30, 2007, at 05:55 PM by Syv Ritch: Formatting
  • Retrieve.Increment-Values-With-Null . . . October 29, 2007, at 10:30 AM by Syv Ritch: Created
  • Retrieve.Identity-Insert . . . October 28, 2007, at 01:29 PM by Syv Ritch: Formatting
  • Summary.Average_wo_High_Low . . . October 27, 2007, at 08:30 AM by Syv Ritch: Formatting
  • Summary.RankingBySubsgroup . . . October 27, 2007, at 08:29 AM by Syv Ritch: Formatting
  • Optimize.Xp_cmdshell . . . October 26, 2007, at 07:37 AM by Syv Ritch: Created
  • Optimize.Usage . . . October 25, 2007, at 09:34 AM by Syv Ritch: Created
  • Optimize.SpaceTempdb . . . October 25, 2007, at 08:37 AM by Syv Ritch: Formatting
  • FAQs.DBCC-SHRINKDATABASE . . . October 24, 2007, at 09:12 AM by Syv Ritch: Numbering
  • FAQs.DBCC-REPAIR_ALLOW_DATA_LOSS . . . October 23, 2007, at 08:11 AM by Syv Ritch: Created
  • Administration.Shrink-Log . . . October 23, 2007, at 07:41 AM by ?:
  • FAQs.DBCC-CheckDB . . . October 18, 2007, at 09:42 AM by Syv Ritch: Created
  • Administration.Attach-Database . . . October 17, 2007, at 09:51 AM by Syv Ritch: Created
  • Administration.Drop-Recalcitrant-Databases . . . October 17, 2007, at 09:41 AM by Syv Ritch: Attach database
  • Dates.UTC-Dates . . . October 15, 2007, at 09:53 AM by Syv Ritch: Created
  • Retrieve.Parameterized-View . . . October 12, 2007, at 09:45 AM by Syv Ritch: Created
  • Retrieve.One-or-All-Same-Query . . . October 12, 2007, at 09:20 AM by Syv Ritch: Applies to
  • Summary.HowManyDuplicates . . . October 11, 2007, at 08:51 AM by Syv Ritch: Formatting
  • Dates.Leap_Year . . . October 10, 2007, at 11:07 AM by Syv Ritch: Formatting
  • Dates.Extracting_Portion_of_Dates . . . October 10, 2007, at 11:06 AM by Syv Ritch: Formatting
  • Dates.Last-Day-Month . . . October 09, 2007, at 10:32 AM by Syv Ritch: Created
  • Dates.DropTimes . . . October 08, 2007, at 10:10 AM by Syv Ritch: Formatting
  • Dates.Overlapping-Dates . . . October 08, 2007, at 10:07 AM by Syv Ritch: Formatting
  • Dates.Weekdays . . . October 07, 2007, at 04:55 PM by Syv Ritch: Created
  • Administration.RecordsForAllTables . . . October 06, 2007, at 10:05 AM by Syv Ritch: Formatting
  • Optimize.Regain_Space . . . October 05, 2007, at 09:45 AM by Syv Ritch: Formatting
  • Retrieve.Missing_Ids . . . October 05, 2007, at 09:44 AM by Syv Ritch: Formatting
  • Optimize.Table-vs-Views . . . October 03, 2007, at 08:12 AM by Syv Ritch: Applies to
  • Optimize.CaseSensitiveSearches . . . October 02, 2007, at 10:52 AM by Syv Ritch: Formatting
  • Retrieve.Calculate-Running-Balance . . . September 29, 2007, at 02:55 PM by Syv Ritch: Created
  • Retrieve.Null-Values-0 . . . September 28, 2007, at 11:26 AM by Syv Ritch: Spelling
  • Retrieve.Convert-Comma-Delimited-List . . . September 27, 2007, at 03:00 PM by Syv Ritch: Created
  • Retrieve.Comma-Delimited-Unique-Values . . . September 27, 2007, at 02:30 PM by Syv Ritch: Titles
  • Retrieve.MissingInfo . . . September 25, 2007, at 05:23 PM by Syv Ritch: Formatting
  • FAQs.System-Databases . . . September 25, 2007, at 02:36 PM by ?: Formatting
  • Site.Search . . . September 23, 2007, at 05:08 PM by Syv Ritch: (:searchresults fmt=#bygrouptitle order=group,title:)
  • Summary.ItemNotInGroupBy . . . September 23, 2007, at 05:05 PM by Syv Ritch: Formatting
  • FAQs.Replication-Components . . . September 21, 2007, at 09:53 AM by Syv Ritch: Created
  • FAQs.Using-Reserved-Words . . . September 20, 2007, at 09:53 PM by Syv Ritch: Correction
  • Dates.DataConversions . . . September 20, 2007, at 06:57 PM by Syv Ritch: Formatting
  • Dates.CalculateDates . . . September 20, 2007, at 06:56 PM by Syv Ritch: Formatting
  • Retrieve.Null-If . . . September 19, 2007, at 07:02 PM by Syv Ritch: Created
  • Summary.GrandTotals . . . September 19, 2007, at 06:31 PM by Syv Ritch: Formatting
  • Summary.Aggregates_Nulls . . . September 19, 2007, at 06:28 PM by Syv Ritch: Formatting
  • Administration.Database-Mail-Troubleshooting . . . September 19, 2007, at 02:21 PM by Syv Ritch: More trouble shooting
  • Administration.Database-Mail . . . September 18, 2007, at 07:53 AM by Syv Ritch: Further info
  • Administration.Use-Database-Mail . . . September 17, 2007, at 09:36 AM by Syv Ritch: Created
  • Retrieve.ConditionalColumns . . . September 17, 2007, at 09:26 AM by Syv Ritch: Formatting
  • Administration.Configure-Mail . . . September 16, 2007, at 06:47 PM by Syv Ritch: Created
  • FAQs.Backup-Restore-Plan . . . September 14, 2007, at 06:34 PM by Syv Ritch: Created
  • FAQs.Correct-Server-Database . . . September 14, 2007, at 01:15 PM by ?: Formatting
  • FAQs.Security-Components . . . September 13, 2007, at 02:31 PM by Syv Ritch: Created
  • Administration.Compatibility-Levels . . . September 12, 2007, at 01:49 PM by Syv Ritch: Created
  • Retrieve.Process-All-Tables . . . September 12, 2007, at 01:17 PM by Syv Ritch: Formatting
  • Administration.Monitor-Logs . . . September 12, 2007, at 12:33 PM by Syv Ritch: Formatting
  • Optimize.Server-Load . . . September 11, 2007, at 10:22 AM by Syv Ritch: Created
  • Optimize.BetterUnion . . . September 11, 2007, at 09:26 AM by Syv Ritch: Formatting
  • Administration.Database-Id . . . September 10, 2007, at 07:54 AM by Syv Ritch: Formatting
  • Optimize.DBCC-Show-Statistics . . . September 08, 2007, at 10:06 AM by Syv Ritch: Created
  • Administration.Lightweight-diagnostics . . . September 06, 2007, at 10:19 AM by Syv Ritch: Created
  • Site.PageListTemplate . . . September 05, 2007, at 10:53 AM by syv Ritch:
  • Retrieve.Extract-Url . . . September 03, 2007, at 11:26 AM by Syv Ritch: Created
  • Optimize.Index-Rebuild-Reorganize . . . September 02, 2007, at 06:29 PM by Syv Ritch: Created
  • Optimize.Truncate-Delete . . . September 01, 2007, at 01:11 PM by Syv Ritch: Created
  • Retrieve.String-Operations . . . August 31, 2007, at 09:33 AM by Syv ritch: Created
  • Optimize.Update-Indexes . . . August 27, 2007, at 10:00 AM by Syv Ritch: Created
  • Retrieve.Changed-Row . . . August 24, 2007, at 12:10 PM by Syv Ritch: Created
  • Administration.Lost-sa-Password . . . August 23, 2007, at 05:08 PM by Syv Ritch: Created
  • Administration.Restore-Master . . . August 22, 2007, at 05:17 PM by Syv Ritch:
  • Retrieve.Random-Rows . . . August 21, 2007, at 07:42 PM by Sy Ritch: Created
  • Retrieve.Output-CSV . . . August 20, 2007, at 07:19 PM by Syv Ritch: Created
  • Retrieve.Data-Length . . . August 19, 2007, at 04:47 PM by Syv Ritch: Created
  • Administration.List-Databases . . . August 18, 2007, at 04:25 PM by Syv Ritch: Wording
  • Administration.File-Location . . . August 09, 2007, at 02:21 PM by Syv Ritch: Created
  • Dates.Entering_Dates . . . August 07, 2007, at 09:29 AM by Syv Ritch: Applies to
  • FAQs.Error_Messages . . . August 06, 2007, at 11:48 AM by Syv Ritch: Further explanations @@error
  • Retrieve.Set_Rowcount . . . August 04, 2007, at 09:47 AM by Syv Ritch: Wording
  • Retrieve.Row_Count . . . August 03, 2007, at 06:19 PM by Syv Ritch: Created
  • FAQs.Single_User_vs_Restricted_User . . . August 01, 2007, at 07:12 PM by Syv Ritch: Edits
  • FAQs.Defrag_vs_Reindex . . . July 31, 2007, at 06:45 PM by Syv Ritch: Created
  • Summary.Running_Balance_Calcs . . . July 28, 2007, at 08:51 PM by Syv Ritch: Created
  • Summary.Multiple_Group_By . . . July 27, 2007, at 07:28 PM by Syv Ritch: Formatting
  • Summary.Percentage_Of_Total . . . July 26, 2007, at 06:37 AM by ?: Formatting
  • Summary.Running_Total . . . July 24, 2007, at 09:08 PM by Syv Ritch: Created
  • Retrieve.DenseRank . . . July 24, 2007, at 02:22 PM by Syv Ritch: Formatting
  • Optimize.SelectionOperators . . . July 24, 2007, at 02:20 PM by Syv Ritch: Formatting
  • Optimize.IncreaseSizeTempdb . . . July 24, 2007, at 02:19 PM by Syv Ritch: Formatting
  • Optimize.Concatenations . . . July 24, 2007, at 02:17 PM by Syv Ritch: Formatting
  • Optimize.IndexPerformance . . . July 24, 2007, at 02:16 PM by Syv Ritch: Formatting
  • Summary.RowNumber . . . July 24, 2007, at 02:15 PM by Syv Ritch: Formatting
  • Summary.Only1RowFromGroup . . . July 24, 2007, at 02:13 PM by Syv Ritch: Formatting
  • Administration.Cached_Queries . . . July 21, 2007, at 09:16 PM by Syv Ritch: Created
  • Administration.Configuration_Settings . . . July 18, 2007, at 07:00 PM by Syv Ritch: Created
  • Administration.Registered_Servers . . . July 18, 2007, at 06:51 PM by Syv Ritch: Created
  • Retrieve.Alias_Synonym . . . July 18, 2007, at 10:05 AM by Syv Ritch: Created
  • Retrieve.Format_Numbers . . . July 17, 2007, at 09:16 AM by Syv Ritch: Created
  • Optimize.Currently_Running_Tasks . . . July 16, 2007, at 07:10 PM by Syv Ritch: Created
  • Optimize.Waiting_Tasks . . . July 16, 2007, at 10:03 AM by Syv Ritch: Created
  • Administration.OS_System_Info . . . July 15, 2007, at 03:17 PM by Syv Ritch: Created
  • Administration.Monitor_Performance . . . July 12, 2007, at 10:52 AM by Syv Ritch: Title wording
  • Main.MasterTemplate . . . July 12, 2007, at 10:02 AM by Syv Ritch: Data used
  • Administration.Who_vs_who2 . . . July 11, 2007, at 06:22 PM by Syv Ritch: Spelling
  • Retrieve.Rewrite_Query . . . July 09, 2007, at 11:54 AM by Syv Ritch: From Denis The SQL Menace
  • About.AboutUs . . . July 08, 2007, at 08:18 AM by Syv Ritch: Wording
  • FAQs.Stored_Procedures_Naming . . . July 06, 2007, at 09:47 AM by Syv Ritch: Created
  • Dates.Select_By_Date_And_Time . . . July 05, 2007, at 06:39 PM by Syv Ritch: Created
  • Dates.DateDiff_Incorrect_Results . . . July 05, 2007, at 10:38 AM by syv Ritch: Wording
  • Dates.Timestamp_vs_CurrentTimestamp . . . July 04, 2007, at 06:46 PM by Syv Ritch: Created
  • Optimize.In_vs_Or . . . July 04, 2007, at 05:02 PM by Syv Ritch: Created
  • FAQs.Common_Table_Expressions . . . July 04, 2007, at 02:13 PM by Syv Ritch: Wording
  • Dates.Timestamp . . . July 04, 2007, at 01:45 PM by Syv Ritch: Further explanations
  • FAQs.Char_vs_nchar . . . July 03, 2007, at 02:27 PM by Syv Ritch: Created
  • Administration.DatabaseStatus . . . July 03, 2007, at 12:43 PM by Syv Ritch: Created
  • Administration.ListAllViews . . . July 01, 2007, at 08:54 PM by Syv Ritch: Formatting
  • Retrieve.PreviousRowNextRowNoCursor . . . July 01, 2007, at 05:59 PM by Syv Ritch: Further explanations
  • Retrieve.ListCommas . . . June 30, 2007, at 12:28 PM by Syv Ritch: TSQL language code
  • Dates.DateSelection . . . June 27, 2007, at 06:44 PM by Syv Ritch: Created
  • Dates.SearchForDates . . . June 26, 2007, at 05:47 PM by Syv Ritch: Created
  • Retrieve.Quotes . . . June 26, 2007, at 12:26 PM by Syv Ritch: Created
  • Summary.Summary . . . June 23, 2007, at 01:18 PM by Syv Ritch: Changed sidehead
  • Optimize.Optimize . . . June 23, 2007, at 01:17 PM by Syv Ritch: Changed sidehead
  • FAQs.FAQs . . . June 23, 2007, at 01:17 PM by Syv Ritch: Changed sidehead
  • Retrieve.Retrieve . . . June 23, 2007, at 01:16 PM by Syv Ritch: Changed sidehead
  • Dates.Dates . . . June 23, 2007, at 01:15 PM by Syv Ritch: Dates/Dates
  • Site.PageNotFound . . . June 23, 2007, at 01:09 PM by Syv Ritch: Wording
  • FAQs.RecordsForAllTables . . . June 21, 2007, at 09:56 AM by Syv Ritch: Created
  • FAQs.ListConnectedUsers . . . June 18, 2007, at 01:16 PM by Syv Ritch: Created
  • Retrieve.RemoveDuplicatesManually . . . June 18, 2007, at 12:36 PM by Syv Ritch: Link to batch duplicate rows
  • Retrieve.RemoveDuplicatesBulk . . . June 18, 2007, at 12:33 PM by Syv Ritch: Links
  • Optimize.MoveTempdb . . . June 18, 2007, at 11:52 AM by Syv Ritch: Created
  • FAQs.TableStructure . . . June 18, 2007, at 10:46 AM by Syv Ritch: Created
  • About.Support . . . June 18, 2007, at 09:26 AM by Syv Ritch: Formatting
  • About.Privacy . . . June 18, 2007, at 09:24 AM by Syv Ritch: SQLHacks.com
  • About.Guaranties . . . June 18, 2007, at 09:23 AM by Syv Ritch: SQLHacks.com
  • About.Disclaimers . . . June 18, 2007, at 09:22 AM by Syv Ritch: SQLHacks.com
  • About.Copyrights . . . June 18, 2007, at 09:21 AM by Syv Ritch: SQLHacks.com
  • About.About . . . June 18, 2007, at 09:18 AM by Syv Ritch: Created
  • FAQs.CurrentVersion . . . June 14, 2007, at 09:52 AM by Syv Ritch: Created
  • FAQs.ListAllViews . . . June 14, 2007, at 09:44 AM by Syv Ritch: Created
  • FAQs.ListAllTriggers . . . June 14, 2007, at 09:40 AM by Syv Ritch: Formatting
  • FAQs.NoIndex . . . June 13, 2007, at 08:18 PM by Syv Ritch: Created
  • FAQs.NoPrimaryKey . . . June 13, 2007, at 08:14 PM by Syv Ritch: Created
  • FAQs.IdentityColumns . . . June 13, 2007, at 08:04 PM by Syv Ritch: Created
  • FAQs.ListAllStoredProcedures . . . June 13, 2007, at 07:58 PM by Syv Ritch: Created
  • FAQs.SimpleMonitoring . . . June 13, 2007, at 07:42 PM by Syv Ritch: Created
  • Retrieve.SearchEveryField . . . June 13, 2007, at 06:08 PM by Syv Ritch: Created
  • Retrieve.ResetIdentity . . . June 13, 2007, at 05:37 PM by Syv Ritch: Created
  • Retrieve.NoPivot . . . June 13, 2007, at 05:28 PM by Syv Ritch: Created
  • Retrieve.SearchForNulls . . . June 13, 2007, at 05:09 PM by Syv Ritch: Meta data
  • Site.Retrieve . . . June 13, 2007, at 02:38 PM by Syv Ritch: Wording
  • Retrieve.SearchSpecialChars . . . May 30, 2007, at 01:31 PM by Syv Ritch: Created
  • Retrieve.WhereExists . . . May 30, 2007, at 01:27 PM by Syv Ritch: Created
  • Summary.GroupsVsDistinct . . . May 29, 2007, at 07:56 PM by ?: Formatting
  • Retrieve.OrganizationalChart . . . May 29, 2007, at 07:54 PM by Syv Ritch: Created
  • Site.Summary . . . May 29, 2007, at 02:23 PM by Syv Ritch: Created
  • Site.Optimize . . . May 29, 2007, at 02:17 PM by Syv Ritch: Titles
  • Faqs.ModifyNotNulls . . . May 29, 2007, at 02:14 PM by Syv Ritch: Created
  • Site.FAQs . . . May 29, 2007, at 02:09 PM by Syv Ritch: Created
  • Site.Dates . . . May 29, 2007, at 02:07 PM by Syv Ritch: Headings
  • Faqs.ListAllKeys . . . May 29, 2007, at 02:00 PM by Syv Ritch: Created
  • Main.AboutCredits . . . May 28, 2007, at 09:27 AM by Syv Ritch: Formatting
  • Main.AboutSupport . . . May 27, 2007, at 04:59 PM by Syv Ritch: Created
  • Main.AboutPrivacy . . . May 27, 2007, at 04:54 PM by Syv Ritch: Formatting
  • Main.AboutGuaranties . . . May 26, 2007, at 10:00 AM by Syv Ritch: Formatting
  • Main.AboutDisclaimers . . . May 26, 2007, at 09:55 AM by Syv Ritch: Created
  • Main.AboutCopyrights . . . May 26, 2007, at 09:52 AM by Syv Ritch: Created
  • Main.AboutAboutUs . . . May 26, 2007, at 09:33 AM by Syv Ritch: Formatting
  • Site.AboutAboutUs . . . May 25, 2007, at 06:57 PM by Syv: About us

All contents in SQLHacks.com are the property of db Networks Ltd and it's affiliates. All other trademarks not owned by db Networks Ltd or its affiliates that appear on the SQLHacks.com site are the property of their respective owners, especially: Windows®, MS SQL®, SQL Server® which are the property of Microsoft Corp. DB2® which is the property of IBM Systems. Oracle database® which is the property of Oracle Corp.