Maintenance Plan mystery
Last week I had interesting (or I can say weird ? ) case of Maintenance Plan. One of the server that we...
2011-12-14
569 reads
Hemantgiri
- Interests: Reading,Writing,Painting
- Twitter: @https://twitter.com/hemantgirig
- Website: https://www.sqlservercitation.com
- LinkedIn: https://www.linkedin.com/in/hemantgirisgoswami/
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
622 reads
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
969 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
839 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,943 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,894 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
713 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
404 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
410 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
460 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers