It is a very common requirement among the SQL Server developer community, how to pass multi-value strings to a stored procedure. As we all know multi-values are totally against the basic foundation of relational model and hence in T-SQL there are certain tricks you can apply to get them done. Note t

(Brian Larson and Martin Voegele) With apologies to composer Cole Porter, this is the song that Microsoft might be singing about its new SQL Server Reporting Services product. Slated for release by the end of 2003, Reporting Services handles the complete reporting life cycle—from a report’s design,

(Vinod Kumar) This topic has been in my mind for quite some time now. Just thought to get them into a understandable article for public use … Well, most of the DBA’s and many programmers of SQL Server should have heard of the terms data cache and procedure cache in conjunction with SQL Server. The

This article describes how to manually synchronize replication push subscriptions by using backup or restore. Sometimes, you cannot fully synchronize replication subscriptions by using the default method because of the following potential reasons: –You have large tables that you have to transf

(Vyas Kondreddi) Experts from within and outside Microsoft have always said that running Profiler on a production environment is not a recommended practice, as it could degrade the performance of the server. Instead they suggest doing server side tracing via SQL Trace system stored procedures. But D

(Brian Moran) In Yukon, the next major release of SQL Server, Microsoft is introducing several new technologies that will change the types of skills that traditional DBAs need. Although Yukon’s commercial release is still almost a year away, it’s time to start thinking about Yukon and preparing for

(Andrew Novick) Something like fifty percent of system outages are caused by “Out of space” conditions. I kid you not. I run into them all the time. Combine this problem with the need to maintain high availability and peak performance and the consequence is that disk configuration and space allocati

(Russ Whitney) One of the most common reader questions I receive is, “How can I use the PivotTable and PivotChart components in Microsoft Excel?” These components, which enable simple analysis in Microsoft Excel or a custom application, work with either OLAP data sources or relational data sources.

(Joél Contreras) Managing multiple versions of the same database across different environments (i.e. Development, Test, Production, and Disaster Recovery site) is perhaps one of the most important and least favorable Database Administrative duties. Whether it’s synchronizing database objects or actu

In Microsoft SQL Server 2000, you can trace SQL Server events by using a server-side trace that is performed by system stored procedures or by using a client-side trace that is performed by SQL Profiler. After you start a server-side trace, the trace continues to run and generates output until you s