(Wayne Berry) Do you want to improve the performance of Teamcenter on SQL Server by finding and clearing the bottlenecks? Then fire up the PAL tool. This tool can help you find performance bottlenecks in SQL Server running Teamcenter by aggregating and evaluating the hundreds of Windows Performance

(Brad Schulz) There are often questions on the MSDN T-SQL Forum regarding how you can find all stored procedures (and/or functions and/or triggers and/or views) that contain a particular string. Thankfully, the object_definition() function gives us the ability to acquire the T-SQL code of those obje

(Pinalkumar Dave) This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query.

(Michael M. David) Modeling a hierarchical structure is a fairly basic operation where the structure is modeled a hierarchical node at time, usually top to bottom, and building on the hierarchical semantics gradually a node at a time. However, the capability of extending the limits of combining mult

(Ray Barley) I have some complex queries that I need to run against my SQL Server database and I’m using the Entity Framework (EF) in my application. I’m having difficulty crafting these queries using LINQ to Entities. What I really need is to just inject my native queries into the Entity Framewor

In one of our previous blog post, we had covered the new feature – PowerPivot that has been introduced in SQL Server 2008 R2. In today’s post, we will look into powerpivot reports. A powerpivot report is essentially an excel spreadsheet that allows us to present our powerpivot data in a summary fo

(Dany Hoter) We Excel geeks aren’t spoiled with fancy query builders. We have had MSQuery for the last what? 15 years?

(Robert Bruckner) Reporting Services 2008 introduced the ability to dynamically hide table columns and shrink the width of the table (and the report body) at the same time automatically. That said, you also have the ability to just hide the contents, but not the actual table column and preserve the

(Bru Medishetty) I am a SQL Server user and in my day-to-day work I use SQL Profiler for various purposes. Sometimes I run profiler to trace slow running queries and tune them appropriately; sometimes I run a trace to know details about failed Logins in addition to those reported in SQL Server error

(Wayne Berry) The Performance Analysis of Logs (PAL) tool is a free tool from CodePlex. It parses and analyzes Windows Performance Monitor logs to find performance bottlenecks. The PAL tool can help you find performance bottlenecks in SQL Server running Teamcenter by aggregating and evaluating the h