This is quite a popular question and I have never wrote about this on my blog. A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, effectively rotating a table.
SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance
I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering…
Read MoreSQL SERVER – 2008 – Choosing the Right Edition for Your Needs
Enterprise SQL Server 2008 is a comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications. Standard SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications. Workgroup Run…
Read MoreSQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks
Note :Â Download PPT by Microsoft Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks The Windows Live Security team shares best practices – from platform and network security to incident management – in providing security for web applications and infrastructure. Organizations across the globe face…
Read MoreSQLAuthority News – SQL SERVER Database Administrator Job Description
I have previously written article about SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer. I have received quite a lot of request to update it or post something similar. Writing SQL Articles are easier then writing Job description for DBA. I have read many job description…
Read MoreSQL SERVER – Ideal TempDB FileGrowth Value
Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site.
SQL SERVER – Find Table in Every Database of SQL Server – Part 3
Previously I wrote two articles about SQL SERVER – Find Table in Every Database of SQL Server SQL SERVER – Find Table in Every Database of SQL Server – Part 2 I recently received email from SQL Expert and Blog Reader Greg Steinkuhler. People like Greg Steinkuhler makes this whole…
Read More