SQL SERVER - Creating Comma Separate Values List from Table - UDF - SP frontimage1

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL SERVER - Creating Comma Separate Values List from Table - UDF - SP frontimage2

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.

Error 2501 : Cannot find a table or object with the name . Check the system catalog. This is very generic error beginner DBAs or Developers faces. The solution is very simple and easy. Follow the direction below in order. Fix/Workaround/Solution: Make sure that correct Database is selected. If not…
Read More

SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion

MIS2007 is really going good. There are many things going on. As I mentioned in my previous article, It is really pleasure to meet industry leaders. There was discussion about what is good for database RAID 5 configuration or RAID 10. This subject is always very interesting. We were discussing…
Read More

SQL SERVER – Index Optimization CheckList

Index optimization is always interesting subject to me. Every time I receive requests to help optimize query or query on any specific table. I always ask Jr.DBA to go over following list first before I take a look at it. Most of the time the Query Speed is optimized just following basic rules mentioned below. Once following checklist applied interesting optimization part begins which only experiment and experience can resolve.

Read More

SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas

I am attending The 2007 Marketing Innovation Summit“, Las Vegas. It started on 5/6/2007 and will continue till 5/9/2007. Unica Corporation has arranged this conference. The MIS 2007 Agenda includes: Case studies and best practices Sessions focused on Relationship Marketing, Internet Marketing and Marketing Operations Hands on “how to” sessions…
Read More
Menu