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
610 reads
hemantgiri@techgeek.co.in
- Interests: Reading,Writing,Painting
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
944 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
823 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,893 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,818 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
695 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
375 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
397 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
445 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
651 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...