SQL Server Service Broker provides support for building asynchronous messaging and queuing applications with the SQL Server Database Engine. This paper describes a large scale customer scenario and the techniques employed in scaling Service Broker to process tens of thousands of messages per second on one server.
2009-09-11
2,807 reads
It is not always easy to spot "antipatterns" in your SQL, especially in more complex queries. In this article, Plamen demonstrates some of the most common SQL coding errors that he encounters, explains their root cause, and illustrates potential solutions.
2009-09-11
8,634 reads
This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-09-11
1,604 reads
A last push for the 2009 PASS Summit before registration goes up.
2009-09-10
12 reads
A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.
2009-09-10
5,604 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-10
1,154 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-09-10
845 reads
Whether a query uses Scan or Seek can have a big impact on the cost of excuting that query. This article examines when each is used and which is optimal.
2009-09-10
6,054 reads
In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).
2009-09-10
4,815 reads
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
2009-09-09
42,625 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers