Skip to content
Thursday, February 9, 2023
Latest:
  • Changing Service tiers? Do you need downtime?
  • Different Database Services in AWS
  • Google Launched second Cloud Region in India
  • SQL Server IaaS Agent Extension |Part-1
  • Day-3 | SQL Server Internals and SQL Azure Workshop | IBM Noida

SQLChamp

Let's learn together!

  • Home
  • LearnSQL
  • SQLServer
  • SQLTips
  • Azure Data Platform
    • SQLAzure
    • SQLServer on Azure VM
  • Best Practices
  • Speaking Events
    • In-Person Events
    • Events

sql tips

SQLTips 

SQL Tip-6 | Use Covering Index to solve key lookup issues

August 4, 2013 Sarabpreet Singh Anand covering index, non clustered, sql tips, tricks

Do you have Key Lookup problem? Key lookup taking most of the query time. then probably this is the best

Read more
SQLTips 

SQL Tip-3 | Don’t Shrink your Database

July 23, 2013 Sarabpreet Singh Anand best practices, shrink, space, sql tips, SQLServer, tips

You should avoid shrinking your database until and unless it becomes unmanageable. Shrinking is a Resource intensive task, Moreover it

Read more
SQLTips 

SQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic*

July 18, 2013 Sarabpreet Singh Anand automatic, SQL, sql tips, SQLServer, sqltip, startup

I know this one is very basic but in the recent past I noticed a couple of environments where the

Read more
SQLTips 

SQL Tip-1 | Don’t forget to recycle your SQLServer ErrorLog

July 17, 2013 Sarabpreet Singh Anand error log, errorlog, recycle, sql tips, SQLServer, tricks

Many a times I’ve seen that DBAs forget to recycle the ErrorLog of their critical SQLServers. Now I also understand

Read more
  • Azure (2)
  • Azure Data Platform (2)
  • Azure Data Platform (32)
  • Best Practices (37)
  • Events (9)
  • In-Person (9)
  • In-Person Events (22)
  • Latest Announcements (6)
  • LearnSQL (32)
  • Powershell for SQL (5)
  • Powershell-Basics (1)
  • Pro-Tip (1)
  • Product Reviews (1)
  • Speaking Events (18)
  • SQL for Beginners (5)
  • SQL Server (1)
  • SQLAzure (33)
  • SQLServer (15)
  • SQLServer on Azure VM (1)
  • SQLServer on Azure VM (17)
  • SQLTips (22)
  • Uncategorized (9)
  • Webcast (6)

Always Encrypted (6) azure (32) azure portal (6) Azure SQL Database (10) backup (5) backup encryption (6) cloud (6) Database (4) DDM (5) deadlock (4) Dynamic Data Masking (5) error log (3) event (21) Execute As (4) Execution context (3) free (10) Free event (8) free sql learning (6) Function (3) grant (3) gurgaon (9) in person (9) learn (3) Learning (9) limitations (4) MCT (8) Microsoft (8) MVP (8) permissions (3) powershell (8) Powershell4SQL (3) restore (3) sarab (19) sarabpreet singh anand (4) security (11) SQL (51) SQL 2012 (5) SQL 2014 (8) SQL Azure (12) SQLAzure (10) SQL Database (10) SQL Saturday (9) sql server (17) SQLServer (31) sql server 2012 (6) SQLServer 2014 (9) sql server 2014 (4) SQL Server 2016 (8) SQL Server day (9) SQLServerday (13) SQLServer Workshop (3) sql tips (4) step-by-step (4) t-sql (8) tech days (3) tips (4) Training (10) tricks (3) webcast (7) windows azure (6)

Copyright © 2023 SQLChamp. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.