2012-01-25 (first published: 2011-11-09)
1,268 reads
Jon McGhee
2010-04-30 (first published: 2010-04-26)
5,083 reads
ServerProperty query with case function
Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition.
2010-03-08 (first published: 2010-02-18)
1,349 reads
Blogs
SQL Server Logins vs. Users: Why You Really Need to Know the Difference
By Kevin3NF
The Two-Layer Model Explained “We added them to the database, but they still can’t...
Using AI to Test a SQL Query
By Steve Jones
Someone sent me this code. WITH p AS ( SELECT ID, ROW_NUMBER() OVER (ORDER...
Your SQL Starting Line: Best Free Databases for Beginners
Wondering which database to tackle first? I’ve got the lowdown on the top free...
Forums
average duration increasing inline with exec counts
As the title says , I've got a handful of stored procs where the...
A Basic Data API Builder ADD
Comments posted to this topic are about the item A Basic Data API Builder...
Sentiment Analysis & Key Phrase Detection
Comments posted to this topic are about the item Sentiment Analysis & Key Phrase...
Question of the Day
A Basic Data API Builder ADD
What parameters are required for the dab add command in the Data API Builder?
See possible answers