SQL Server Memory Management Explained
Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.
2011-09-20
14,262 reads
Multipage Allocator
RE: Syntax error with BEGIN
The syntax problem is that your subselect, ie: (SELECT SystemUserName .... .... <> 'valverde\rKepler') is expected to return a single value, which then must be compared with something. So, prior to the BEGIN you need a comparison operator and value. Eg. IF (SELECT SystemUserName FROM Teacher_Data_Main WHERE (SystemUserName = SYSTEM_USER) or SystemUserName <> 'valverde\pGist' or […]
2003-08-21
RE: Trigger Problem wiht Text Column
Does using instead of trigger mean I have to handle the insert and delete in my script after saving the record to my audit table?
2003-08-13
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers