Scalar Functions with Query Plans: Not all is obvious!
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
853 reads
scalar functions
Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#
In this article, see how to created shared functions using C# assemblies in U-SQL.
2017-06-14
871 reads
Stairway to U-SQL Level 14: Local U-SQL Scalar Functions with C#
Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.
2017-05-31
1,090 reads
RE: Need SQl Help
just change this : ON [4gl Datamart].dbo.tmp_D_Customer.cust_sys_num = [4gl Datamart].dbo.test_D_Customer.cust_sys_num
2005-04-06
SQL Setup 2005 survey
The SQL Setup team is looking for feedback related to your setup and installation experience with SQL Server 2005. Please take a few minutes to complete the survey, this data is very important for us to capture and help improve the user experience. Click here to take the survey
2005-03-17
1 reads
Memory Performance Counters
I am currently running some performance stats against our SQL server. I have been looking at CPU, Memory and Disk IO but am confused by the counter Memory - Page Faults/sec, what would an average be for this counter for reasonable performance. Whilst i'm on the topic aswell, what is a good figure for Memory […]
2005-01-25
1 reads
RE: Reporting Services Programming Guideline
I like these books: Microsoft Reporting Services in Action by Teo Lachev Hitchhiker's Guide to SQL Server 2000 Reporting Services by Blackburn/Vaughn
2005-01-25
DB Design question
Hi everybody I would appreciate some help with the following design problem: The application is about documents with paragraphs. The documents are in a table, and each document consists of various paragraphs, which are also kept in a table. If a document is created using paragraphs 1, 13, 27 & 54, it is easy to […]
2005-01-25
RE: Query Date Range Against Date Range
You have staff who are contracted (with date ranges) You have jobs (with date ranges) and you want see if any staff can fulfill any jobsQuestions Where is the relationship between staff and jobs? (or is that the contracted date range) How do you determine whether the member of staff is qualified to do the […]
2005-01-20
Blogs
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...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
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