Browse by Tags
All Tags »
sql server (
RSS)
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...
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...
This is a script to conver a delimited/separated values given a delimiter into a table, via a User Defined Function. This has saved me a lot of work already including just now so I gfigured this is a good share My apologies as I could not determine where...
Might need to create a separate page for notes on performance since I've been doing a lot of C# and database tuning lately but having them on this post so far. Here are some of my notes on performance [more] * Before you optimize, ensure that your results...
Needed some TSQL code again to retrieve descendant and ancestor entries in a self-referencing table. I've done this a couple of times already and although I can write it from the top of my head, sometimes you just want to make life easier and have a script...
There seems to be a number of SQL injection attacks happening lately involving adding of <script src=http://www.banner82.org/b.js></script> , adword71.com/b.js (and the likes ) to entries under string/text/varchar columns in the database targetting...
More Posts