more sql performance tips

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] 1) be careful in doing anything fancy on JOIN predicates (that is the condition in the “ON” ...

SQL Business Intelligence Developer Needed (Manila, Philippines)

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] Company Profile: Agilone LLC Norwalk, CT USA, Los Gatos CA USA , Istanbul, Turkey  and Manila, Philippines Companies who can effectively understand, ...

24 hours of high quality sql server training for free

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] Join us online on September 2, 2009* ...

TSQL to get SQL Server properties

TSQL script to get common SQL Server properties (edition, instancename et al) [more] SELECT   SERVERPROPERTY('Collation') Collation,   SERVERPROPERTY('Edition') Edition,   SERVERPROPERTY('Engine Edition') EngineEdition,   SERVERPROPERTY('InstanceName') InstanceName,   SERVERPROPERTY('IsClustered') IsClustered,   SERVERPROPERTY('IsFullTextInstalled') IsFullTextInstalled,   SERVERPROPERTY('IsIntegratedSecurityOnly') IsIntegratedSecurityOnly,   SERVERPROPERTY('IsSingleUser') IsSingleUser,   SERVERPROPERTY('IsSyncWithBackup') IsSyncWithBackup,   SERVERPROPERTY('LicenseType') LicenseType,   SERVERPROPERTY('MachineName') MachineName,   SERVERPROPERTY('NumLicenses') NumLicenses,   SERVERPROPERTY('ProcessID') ProcessID,   ...

caution in dropping a temp table before creating it

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] Say you have a script that ...

temp table (#), global temp tables (##) and @table variables

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 ...

Convert Delimited Values to a table with Ordinal Column

This is a script to conver a delimited/separated values given a delimiter into a table, via a User Defined Function.[more] 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 I based this script from but definitely ...

Performance, Measure and ANTS Profiler

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 are accurate first before optimizing. I would ...

Link : Configuring the Windows Firewall to Allow SQL Server Access

Not much to say but just wanted to share a common development/deployment task/concern which is to allow windows firewall (and also relevant information for any other firewall) from the following link: Configuring the Windows Firewall to Allow SQL Server Access

Link : Configuring the Windows Firewall to Allow SQL Server Access

Not mucht to say but just wanted to share a common development/deployment task/concern which is to allow windows firewall (and also relevant information for any other firewall) from the following link: Configuring the Windows Firewall to Allow SQL Server Access