Using NOLOCK hint
Use NOLOCK hint to avoid block - this is what I have often heard/see in many forums I participate, during local...
2011-12-01
615 reads
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Download SQL Server 2008 SP3 CU2
MS has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 Released? which has fixes reported after SQL...
2011-11-22
963 reads
Download SQL Server 2012 Developer Training Kit
Microsoft has released SQL Server 2010 Developer Training Kit which includes :
LabsDemosand, Presentations
This kit will greatly help you learning Developer...
2011-11-07
832 reads
Resolving 701 There is insufficient system memory to run this query
In recent past while working on an assignment I have encounter an error 701 There is insufficient system memory to run...
2011-11-07
1,929 reads
DATABASE_OBJECT_CHANGE_GROUP do not audit SP or other object
Deepak Kumar (friend of mine and founder of http://www.sqlknowledge.com ) were chatting yesterday. We were discussing about audit feature in SQL...
2011-10-29
1,872 reads
Refresh QA Database with Manual Scripts
Couple of week back Megha Sharma send me an email with a document attached, this document is all about how...
2011-10-27
703 reads
workaround for orphaned users
The server principal is not able to access the database under the current security context, is the error message appears...
2011-09-27
394 reads
SQL 2008 R2 Administration Cook Book
Couple of week back I have received a special gift, from the person whom I admire as a elder bro...
2011-09-26
404 reads
CU 16 for SQL Server 2008 SP1
Microsoft has recently released a Cumulative Update (CU) # 16 for SQL Server 2008 SP1 which contains hotfixes which were resolved...
2011-09-23
453 reads
SQL Server DBA Quiz on BeyondRelational
Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web...
2011-09-22
659 reads
Blogs
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
T-SQL Tuesday #200: Bad Query signals
NO AI was used to generate this content. Grammarly was used to check and...
Project Management – Part 1
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
Forums
Reading Parquet using openrowset
Hi, We are looking out to read parquet file directly from on premise shared...
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers