(Jeremy Kadlec) What do I need to do? There is so much, where do I start? What should I do next? Wow, my SQL Server is flying! If you start out not knowing where to go and end up with an exceptionally performing SQL Server, you made it. Take a look at this SQL Server performance-tuning checklist to

If you are considering Microsoft replication capabilities you need to understand how these capabilities compare to DataXtend RE. This white paper discusses the differences in SQL Server and DataXtend RE replication capabilities across several areas and also reviews the challenges of supporting multi

(Serdar Yegulalp) Many database software tools are designed to work with SQL Server or they are packaged with a SQL Server database. That’s all well and good, but you then have the thorny task of distributing the database to a client or end user. A parallel situation may involve creating a custom so

(Muthusamy Anantha Kumar) As we all know, SQL Server 2005 has new features when compared to SQL Server 2000. One of the features that we are going to discuss in this article is the Row_Number() function. SQL Server Database administrators and developers have been longing for this function for a long

(Thomas Moore and Ed Tittel) Learn about schema binding, data partitioning, and other aspects of advanced physical database implementation. This information, including practice questions, will help you prepare for the CAD/MCSE/MCDBA 70-229 certification exam. (pdf)

(Remus Rusanu) So you built your first Service Broker app, you’ve sent the first message and now you’re looking for the message on the target queue. Yet, the message is not there. What do you do? Where do you look first? Well, troubleshooting Service Broker is a bit different than troubleshooting yo

(Erland Sommarskog) This article tackles two related questions: How can I use the result set from one stored procedure in another, also expressed as How can I use the result set from a stored procedure in a SELECT statement? How can I pass a table as a parameter from one stored procedure to a

(Stephen Swoyer) What do IT organizations have on tap business intelligence-wise in 2006? A whole lot of SQL Server 2005, for starters: With so much pent-up demand, many SQL shops will make the move to Microsoft’s next-gen database this year.

(William Pearson) In this article, we will continue our examination, begun in Set Functions: The DRILLDOWNMEMBER() Function, of the MDX surrounding drilling up and down within our Analysis Services cubes. As we have noted, drilling up or down occurs along the lines of drilling paths that are defined

(Miles Trochesset) Using a CLR trigger we can register all user defined functions, procedures, types, aggregates etc., contained in an assembly when it is created in the database on “CREATE ASSEMBLY … “. This saves us the time of registering all these ourselfves. We skip the “CREATE PROCEDURE …”