Sending a Variable Number of Elements in a Parameter
What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use.
2014-02-06
9,441 reads
Alex Grinberg
The Multi-valued Parameters problem in Reporting Services
Longtime SQLServerCentral author, Alex Grinberg, brings us a short piece on how to deal with multi-valued parameters in Reporting Services when you have a stored procedure call.
2009-04-21
14,809 reads
Creating Functions for Stored Procedures
With the advent of so many new technologies in the Microsoft space, a DBA needs to learn more and more about many of them that aren't a part of SQL Server. Alex Grinberg brings us a technique he has used to create ADO functions for your stored procedures.
2008-10-10
13,682 reads
The ARRAY In SQL Server 2000
SQL Server 2000 and Transact-SQL have many features, but one of the most often asked for features has been the implementation of some sort of array data type. This basic programming concept is notably absent from the development platform and results in many headaches and frustrations for DBAs. New author Alex Grinberg brings us his techniques for simulating arrays in SQL Server 2000.
2008-02-15 (first published: 2005-05-16)
144,962 reads
Self Eliminated Parameters
Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.
2006-10-09
9,122 reads
Working With System Tables
It's not recommended, but sometimes writing scripts against the system tables and getting information is a great way to work with SQL Server. Alex Grinberg brings us a look at some of the things you can get from system tables along with some sample scripts.
2006-01-16
14,538 reads
Blogs
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
UNION vs UNIONALL: #SQLNewBlogger
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Forums
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Over or Under Provisioned
Comments posted to this topic are about the item Over or Under Provisioned
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers