Logiclabz

Recent Posts in Sql Server

• Schedule Sql Server Job to run every 30 Seconds
  20-Apr-2012
  Schedule Sql Server Job to run every 30 Seconds
• T-SQL to find Procedures/Commands used in Sql Server Jobs
  19-Feb-2012
  T-SQL to find a list of sql procedures or commands used in sql server jobs which becomes difficult i
• Selecting Random Rows from a Table in SQL Server
  03-Feb-2012
  Optimized way of Selecting Random Rows from a Table in SQL Server. Simple alternative to NEWID() fun
• Useful SQL Server Management Studio Keyboard Shortcuts
  24-Jan-2012
  List of some userful SQL Server Management Studio Keyboard Shortcuts
• Case-sensitive check/search/match in T-SQL - Sql Server 2005
  08-Dec-2011
  To do a case sensitive check/search/match in sql server t-sql queries and if condition
• Get AM/PM in Sql Server DateTime Format
  13-Jun-2011
  Get AM/PM in Sql Server DateTime Format
• Replace/Remove Special Characters in Sql Server 2005/2008
  03-Jun-2011
  SQL Server user-defined function to replace or remove special character supported in both sql server
• Create Linked Server in Sql Server 2005
  21-Sep-2010
  T-SQL query to create a linked server in sql server 2005
• Alter/Change new Default Value of a Column in already created Table
  21-Jul-2010
  Change or alter default column value of already created table with new default value.
• T-SQL to Disable/Enable Job in SQL Server 2005
  04-Mar-2010
  The T-SQL query to enable or disable specific sql server job in sql server 2005.