As most of you know the general rule in performance tuning is .....
"measure, measure, measure" and "measure again"
But it doesn't hurt to give out some warning signs from time to time. And here goes two: More...
We are currently looking for a SQL BI Developer Professional to work with us on exciting, high-profile/scale projects. Feel free to contact me or visit http://www.lwsmedia.com/contact.htm. Looking forward to work with you. More...
The Professional Association for SQL Server or popularly known aka PASS, one, if not the most popular and biggest group of SQL Server professional in world will be having 24 hours of PASS - a series of online web meetings with the best speakers in the industry More...
TSQL script to get common SQL Server properties (edition, instancename et al) More...
Recently I ran into a script instead a stored procedure
IF OBJECT_ID(tempdb..#temp1) DROP TABLE #temp1
Basically, the object of this script is to check if #temp1 (regular temporary table) exists. If so drop it.
However, I think it can have unintended consequences and maybe safer not to include.
More...
I've been working "full-time" on TSQL scripts for the past month (no with .NET windows/web apps) and mostly on optimization. And I feel that I should share with everyone this article about temp tables and table variables and some of my own notes. Go read the article below then you may come back here. Take careful note of the Conclusion part at the end of the article. More...
This is a script to conver a delimited/separated values given a delimiter into a table, via a User Defined Function.More...