When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...
This article examines the File System Task which can perform numerous operations on files and directories such as create, move, delete, and also to set the attributes of files and folders.
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
Continuing with his series on how to centrally monitor your SQL Servers, Drew Salem looks at how to set up remote servers.
We have a named SQL instance and I am able to connect to the instance, but when I try to view the SSIS packages stored in the MSDB database I get an error. This does not happen with our default instances. Is there an additional setting that must be changed to get this to work?
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
The interface is crucial for getting data in and out of a system. Steve Jones talks a little about past interfaces and possible future ones.
Describes how SQL Server 2005 Data Mining allows aggregation directly at the algorithm level. Although this restricts what the third-party algorithm developer can support in terms of language and data types, it frees the developer from having to implement data handling, parsing, meta data management, session, and rowset production code on top of the core data mining algorithm implementation.
I read SQLBatman's post about his first week as an MVP , and it really resonated well with me. I think that he really hit it when he said that he wasn't going to sit around, he was going to go look for information and take things back from the...
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Comments posted to this topic are about the item Finding Bad Queries