• An Index Reduces Performance of SELECT Queries (Video)
  • 3 Common Mistakes to Kill SQL Server Performance (Video)
  • SQL Server Performance Tuning Made Easy – In-Person (Video)
  • SQL Server Performance Tuning Made Easy – Online (Video)
  • 3 Performance Tuning Tricks you Always Wanted to Know (Video)
  • Secrets of SQL Server-Database Worst Practices (Video)
  • Kick Start! SQL Server 2017/2019 Performance Tips and Trick (Video)
SQL SERVER - Auto Generate Script to Delete Deprecated Fields in Current Database elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

Learn Now
Free Learning Videos
  • An Index Reduces Performance of SELECT Queries (Video)
  • 3 Common Mistakes to Kill SQL Server Performance (Video)
  • SQL Server Performance Tuning Made Easy – In-Person (Video)
  • SQL Server Performance Tuning Made Easy – Online (Video)
  • 3 Performance Tuning Tricks you Always Wanted to Know (Video)
  • Secrets of SQL Server-Database Worst Practices (Video)
  • Kick Start! SQL Server 2017/2019 Performance Tips and Trick (Video)
Upcoming Events
SQL SERVER - Auto Generate Script to Delete Deprecated Fields in Current Database elearning

Instant Learning ~
SQL Server Performance Tuning Practical Workshop for EVERYONE

SQL SERVER – Shrinking Truncate Log File – Log Full

UPDATE: Please follow link for SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008. Sometime, it looks impossible to shrink the Truncated Log file. Following code always shrinks the Truncated Log File to minimum size possible. USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY…
Read More

SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.

To fix the error which occurs after the Windows server name been changed, when trying to update or delete the jobs previously created in a SQL Server 2000 instance, or attaching msdb database. Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from…
Read More

SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure

Following code will help to find all the Stored Procedures (SP) which are related to one or more specific tables. sp_help and sp_depends does not always return accurate results. ----Option 1 SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%tablename%' ----Option 2 SELECT DISTINCT o.name, o.xtype FROM syscomments c INNER JOIN sysobjects o…
Read More

SQL SERVER – Cursor to Kill All Process in Database

When you run the script please make sure that you run it in different database then the one you want all the processes to be killed. CREATE TABLE #TmpWho (spid INT, ecid INT, status VARCHAR(150), loginame VARCHAR(150), hostname VARCHAR(150), blk INT, dbname VARCHAR(150), cmd VARCHAR(150)) INSERT INTO #TmpWho EXEC sp_who DECLARE @spid…
Read More

SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created

Following cursor query runs through the database and find all the table with certain prefixed (‘b_’,’delete_’). It also checks if the Table is more than certain days old or created before certain days, it will delete it. We can have any other operation on that table like to delete, print or index.

Read More
Menu