Robert Marda

Output Parameters

Regular columnist Robert Marda writes about the basics of using output parameters. If you're not using output params we hope this article will get you started - they are a great way to return less data to the client, perfect if you need only a few values and not a recordset/resultset.

2.37 (35)

2007-10-26 (first published: )

31,862 reads

Nesting Stored Procedures

We're pleased to announce that Robert will be writing for us each month - generally on stored procedures, but occasionally on a different topic. This article discusses how nesting stored procedures works and how to use @@NextLevel. Good reading! If there is a stored procedure topic you'd like to see covered, add a comment to the article or email us at articles@sqlservercentral.com

3.5 (2)

2007-05-18 (first published: )

35,354 reads

Manipulating And Using DateTime Data

Working with date and time data in SQL Server can be a bit cumersome using just T-SQL. With the separate datatypes being pulled from SQL Server 2005 for the time being, however, it is something that a DBA needs to get used to. Robert Marda brings us an instructional look at the different datetime data types and some things you should be aware of when developing with them.

1 (1)

2004-10-27

16,644 reads

Creating a System Stored Procedure

Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do.

2.5 (2)

2004-05-20

12,305 reads

Blogs

Do you have rarely used indexes that are hurting performance of writes?

By

We know that indexes are necessary for query performance but comes with overhead during...

Working with SQLSaturday SpeedPASSes – revamped!

By

In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...

Happy Hour at SQL in the City Austin

By

Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

sql server 2012 data column used for 7 different languages

By wendy elizabeth

In a sql server 2012 database, I want to store some messages in the...

Table type

By Admingod

I just want to validate my use of a custom type. I'm doing a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers