Why QUOTENAME is important
Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.
2020-04-10 (first published: 2018-08-13)
12,061 reads
Injection
RE: How to determine DBCC Checkdb , execution time?
It depends on your server hardware. Just kidding , but hardware an RAM definitely has an impact. Dont' know if this helps you or not, but I have a 16.5 Gig user DB on a 2 X 2.4 gig CPU server with 2 gigs of RAM and DBCC CheckDB's complete on this in about 7 1/2 […]
2005-04-20
2005-04-20
RE: Problem with Variables. SQL Server 2000
Personally, I do prefer (and use) the 'single-update' method to increment and return the next countervalue in one go. It makes it unnecessary to wrap in explicit transactions and such. It's physically impossible for the server to return the same counter to more than one caller.update counterTable set @nextid = nextId = nextId + 1 […]
2005-04-20
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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