Additional Articles

SQL Server 2008: Table Valued Parameters

by Additional Articles

SQLTeam.com

Table Valued Parameters (TVP)

In SQL Server 2005 and earlier, it is not possible to pass a table variable as a parameter to a stored procedure. When multiple rows of data to SQL Server need to send multiple rows of data to SQL Server, developers either had to send one row at a time or come up with other workarounds to meet requirements. While a VB.Net developer recently informed me that there is a SQLBulkCopy object available in .Net to send multiple rows of data to SQL Server at once, the data still can not be passed to a stored proc.

2008-08-11

3,885 reads

Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I

by Additional Articles

Database Journal

Writing high-performance reports against Analysis Services cubes means learning MDX to some extent. Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor. BI Architect Bill Pearson demonstrates a way to parameterize the highly useful TopCount() function.

2008-08-08

1,846 reads

Processing XML Showplans Using SQLCLR in SQL Server 2005

by Additional Articles

TechNet Blogs

Showplan

Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.

2008-08-08

2,494 reads

Calculating Mathematical Values in SQL Server

by Additional Articles

MSSQLTips.com

T-SQL

In our application we have the need to perform mathematical calculations. Right now we are doing so in our front end application. Unfortunately we are starting to experience performance problems with large data sets and differences in calculations due to developers using different logic. We are seeking some other options to perform the calculations. Does SQL Server perform basic mathematical calculations?

2008-08-07

5,628 reads

SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects

by Additional Articles

Database Journal

SQL Server Express

Marcin Policht explains the interaction of the primary elements of Service Broker's asynchronous messaging framework and describes a process of setting up the database objects necessary to demonstrate their sample implementation (which will be the subject of our next article).

2008-08-07

1,930 reads

Capture DDL Changes using Change Data Capture with SQL Server 2008

by Additional Articles

SQL Server Performance

Change Data Capture (CDC)

In this article we will see how Change Data Capture (CDC) in SQL Server 2008 can help DBA's to track DML changes

2008-08-06

2,183 reads

Relational Database Integration with RDF/OWL

by Additional Articles

DevX

Database Design

Using the W3C OWL ontology standard lets you get more out of all kinds of data. Find out how this standard and some free software lets you query two databases as if they were one.

2008-08-06

2,110 reads

SQL Server System Configuration Values

by Additional Articles

MSSQLTips.com

Often times we need to review the SQL Server instance configuration values while troubleshooting performance problems. What alternatives are available to capture this information? With all of the new views in SQL Server 2005, is one available with the configuration values, a description and the list of possible values?

2008-08-05

3,958 reads

Virtual database storage for SQL Server: Friend or foe?

by Additional Articles

SearchSQLServer

Storage Management

Virtual database storage in SQL Server comes with flexibility of tiered storage and block storage. Get the pros and cons of virtual storage area networks.

2008-08-05

2,581 reads

Alerts for when Login Failures Strike

by Additional Articles

Database Journal

alerts

When repeated SQL Server login failures occur, a DBA should investigate. It could just be someone repeatedly typing in the wrong password. Worst case is a virus attack flooding your network with connection requests. Receiving an e-mail while login failures are occurring allows DBAs to investigate and fix the issue as soon as possible. So how is DBA notified of login failures without flooding their inbox?

2008-08-04

6,362 reads

All authors

Additional Articles

SQL Server 2008: Table Valued Parameters

Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I

Processing XML Showplans Using SQLCLR in SQL Server 2005

Calculating Mathematical Values in SQL Server

SQL Server 2005 Express Edition - Part 27 - Implementing Basic Service Broker Objects

Capture DDL Changes using Change Data Capture with SQL Server 2008

Relational Database Integration with RDF/OWL

SQL Server System Configuration Values

Virtual database storage for SQL Server: Friend or foe?

Alerts for when Login Failures Strike

Blogs

Ramblings about data communities and your contributions, no excuses

SQL Server Journey till 2025 (brief)

Building Power BI Reports: Desktop vs Fabric

Forums

Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE

Having a Little Fun at SQL Server Central

Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI

Question of the Day

String Similarity I