Check out my latest article: A Simple Guide to Understanding sys.indexes linkedin.com/pulse/simple-g… via @LinkedIn
SQL Server Question & Answers-01 What is the difference between DELETE and TRUNCATE statements?handbookofsuresh.blogspot.com/2025/08/sql-se…
Understanding SWITCHOFFSET in SQL Server sureshsimkumar-xblfi.wordpress.com/2025/08/06/und…
How to find the "nth" row in SQL Server table using ROW_NUMBER() handbookofsuresh.blogspot.com/2025/04/how-to…
DATEDIFF_BIG in SQL Server [SQL Server Date Functions-02] handbookofsuresh.blogspot.com/2025/03/datedi…
![sureshsimkumar's tweet image. DATEDIFF_BIG in SQL Server [SQL Server Date Functions-02] handbookofsuresh.blogspot.com/2025/03/datedi…](https://pbs.twimg.com/media/Gww5iECboAA9kAB.png)
SWITCHOFFSET in SQL server [SQL Server Date Functions ]-01 handbookofsuresh.blogspot.com/2025/03/switch…
![sureshsimkumar's tweet image. SWITCHOFFSET in SQL server [SQL Server Date Functions ]-01 handbookofsuresh.blogspot.com/2025/03/switch…](https://pbs.twimg.com/media/Gww5YWPbgAEw6vH.png)
PARSENAME in SQL Server PARSENAME is a built-in SQL Server function used to return a specific part of a fully qualified object name (e.g., a table name or column name). #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/parsen…
PATINDEX in SQL Server The PATINDEX function in SQL Server is used to find the starting position of a pattern within a string. It works similarly to the CHARINDEX function but is more versatile because..... #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/patind…
TRANSLATE() Function in SQL Server The TRANSLATE() function in SQL Server is used to replace multiple characters in a string with corresponding characters from another string. #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/transl…
Memory-Optimized Tables in SQL Server Memory-Optimized Tables in SQL Server are a feature designed to improve performance and scalability by storing table data in memory instead of disk. #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/memory…
SQL Server Data Encryption Techniques Data encryption in SQL Server ensures that sensitive information remains secure and protected from unauthorized access. #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/02/sql-se…
Advanced Indexing: Filtered Indexes and Columnstore Indexes in SQL Server Efficient indexing is crucial for improving query performance in SQL Server. Two advanced indexing techniques—Filtered Indexes and Columnstore Indexes #sql #sqlserver #dba handbookofsuresh.blogspot.com/2025/01/advanc…
Estimate Types in PMP Estimation is a critical part of project management and is essential for planning, budgeting, and scheduling. #pmp #pmo #projectmanagement #project handbookofsuresh.blogspot.com/2024/04/estima…
Check out my latest article: How to find the last day of a month in SQL Server? linkedin.com/pulse/how-find… via @LinkedIn
Isolation Levels in SQL Server Isolation levels in SQL Server determine how transactions interact with each other and control the level of locking, blocking, and concurrency. SQL Server supports five isolation levels #sql #sqlserver #dba #dbadmin handbookofsuresh.blogspot.com/2025/01/isolat…
Dynamic SQL and Its Use Cases in SQL Server Dynamic SQL refers to SQL statements that are constructed and executed at runtime rather than being hardcoded in the script. #sql #sqlserver #dba #dbadmin handbookofsuresh.blogspot.com/2025/01/dynami…
SQL Injection in SQL Server: Prevention and Best Practices SQL Injection (SQLi) is a security vulnerability that allows attackers to manipulate SQL queries by injecting malicious SQL code into input fields. handbookofsuresh.blogspot.com/2025/02/sql-in…
New Logical Function "GREATEST" in SQL Server 2022 The GREATEST function in SQL Server, introduced in SQL Server 2022, returns the maximum value from a list of expressions. handbookofsuresh.blogspot.com/2025/02/new-lo…
"GENERATE_SERIES" in SQL server GENERATE_SERIES function is a new table-valued function that generates a series of numbers in a specified range. It simplifies the process of creating sequential nos. without the need for recursive queries or temp tables. handbookofsuresh.blogspot.com/2025/02/new-fu…
United States 트렌드
- 1. Luka 93.2K posts
- 2. Dodgers 121K posts
- 3. Blue Jays 80.6K posts
- 4. #WorldSeries 103K posts
- 5. #LakeShow 3,392 posts
- 6. #TheLastDriveIn 4,466 posts
- 7. Mavs 13.1K posts
- 8. Snell 14.3K posts
- 9. Toronto 66.9K posts
- 10. Marcus Smart 3,442 posts
- 11. #SmackDown 33.8K posts
- 12. Halo 160K posts
- 13. Addison Barger 17.8K posts
- 14. Vando 2,596 posts
- 15. Kyshawn George 4,130 posts
- 16. Nico Harrison 2,402 posts
- 17. Blazers 10.7K posts
- 18. Reaves 8,709 posts
- 19. #WANTITALL 44.3K posts
- 20. Wizards 10.3K posts
Something went wrong.
Something went wrong.