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
609 reads
Use NOLOCK hint to avoid block - this is what I have often heard/see in many forums I participate, during local...
2011-12-01
609 reads
MS has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 Released? which has fixes reported after SQL...
2011-11-22
942 reads
Microsoft has released SQL Server 2010 Developer Training Kit which includes :
LabsDemosand, Presentations
This kit will greatly help you learning Developer...
2011-11-07
822 reads
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,890 reads
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,815 reads
Couple of week back Megha Sharma send me an email with a document attached, this document is all about how...
2011-10-27
694 reads
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
Couple of week back I have received a special gift, from the person whom I admire as a elder bro...
2011-09-26
396 reads
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
Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web...
2011-09-22
650 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers