|
|
-
|
|
Kun Cheng from SQL Server Customer Advisory Team has come up with an interesting article that points out three tips that helps you to optimize XML operations. The first tip is to use property promotion, the next is using TYPED XML and the third is using XML indexes. http://blogs.msdn.com/sqlcat/arc......
|
|
-
|
|
This article explains how to generate an RSS feed with iTunes extensions using TSQL.
What is an RSS Feed?
RSS is an XML document format that websites use to publish frequently updated information. An RSS reader application such as google reader or outlook RSS reader can query the RSS feed ......
|
|
-
|
|
If you have a partitioned table with concurrent access to different partitions, you may want to experiment with the LOCK_ESCALATION = AUTO setting in SQL Server 2008. Because this setting enables SQL Server to use a finer grain of lock escalation, it may improve concurrency in your environment. htt......
|
|
-
|
|
Excepts from a conversation between Sumit and Leena, that I overheard last week. Don’t know who they are?? Never mind, I will introduce them later! Leena: “Sumit, I am playing with the FILESTREAM access level and I am bit confused as I am getting a ‘3’ while querying!” Sumit: “I warned you not ......
|
|
-
|
|
Tuesday, March 16, 2010 9:30 AM Pacific Time (US & Canada)
Attend this webcast to learn how Microsoft IT is deploying PowerPivot as a service for Microsoft in collaboration with the Microsoft SQL Server Customer Advisory Team (SQLCAT) team. We share best practices for technical architecture, ......
|
|
-
|
|
Lutz has submitted another tricky scenario where there are 3 records in the activity log for the same 30 minute slot.
Schedule Table
INSERT INTO TC24_Schedules (EmpName, Activity, StartTime, Duration)
SELECT 'Tom', 'HR Meeting', '2010-01-04 09:30:00', '00:15'
UNION ALL
SELECT 'Tom', 'Trai......
|
|
-
|
|
Microsoft Tech.Ed India 2010
a:link
{color:gray;
text-decoration:none;}
a:visited
{color:black;
text-decoration:none;}
For IT Professionals
<area sha......
|
|
-
|
|
After reading XQuery Lab 51, my friend and database expert Brad Schulz send me a note showing another way of achieving the same results. The approach he suggested was much cleaner than my version. My code used the following expression in the WHERE clause to filter the records where @about and @reso......
|
|
-
|
|
Lutz Mueller, an active participant of the Early Review Team has built a tricky data set for TSQL Challenge 24. It is recommended that you test your solutions against this data set before submitting your solutions.
Schedule Table
INSERT INTO TC24_Schedules (EmpName, Activity, StartTime, Dur......
|
|
-
|
|
This post looks closer into a common problem many people may have faced while storing Microsoft Office documents into the FILESTREAM column of a SQL Server database.
I heard this question recently on one of the forums. The situation is as follows: Save an Excel 2003 document in a FILESTREAM c......
|
|