(Madhivanan) Now we will see some example queries that invlove date calculation in the WHERE clause.

(Siddharth Mehta) SSIS packages can be used as a data-source for SSRS and this was well supported in SSRS 2005. In the SQL 2008 R2 release (Nov CTP), this data source extension is not enabled and supported. So when you create a data source in SSRS 2008 R2 (Nov CTP), you won’t be able to get SSIS lis

(BlackWasp) Transact-SQL includes the WAITFOR statement. This command allows the execution of a script or procedure to be blocked for a period of up to twenty-four hours. The process can be delayed until a specified time or for a number of hours, minutes and seconds.

(Steve Endow) If you are a fan of SQL Server Views, you probably eventually noticed a change that occurred in SQL Server 2005: Views no longer honored the ORDER BY clause.

(Adam Machanic) Ever since I started working with SQL Server, I’ve been seeing advice to filter system views based on session identifiers, in order to return only user processes. The general advice is to look for session IDs (or SPIDs) greater than 50. And this seems relatively safe if you look at t

(Richard Waymire) SQL Server has a variety of options to improve availability, including failover clustering. Failover clustering protects you from several kinds of hardware and software failures, such as a server crash, a local disk drive failure, or an application fault. Teamcenter fully supports

(Merrill Aldrich) My coverage of old SQL Server problems seems to be turning into a blog series. In any case, here’s at least a reminder, or perhaps just more fodder for the search engines.

(Don Jones) When your database becomes too big for the server it’s on or is handling too much traffic, what can you do?

(Arshad Ali) SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables. Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances

(David Robinson) I love GUIDs — the uniqueidentifier data type in SQL Server. I use them for everything, domain names, unique error message, and for primary keys in my database tables, etc… — don’t get me started. About two years ago, I started using uniqueidentifier for primary keys because of th