One of the common problems that you would encounter when you are building applications that utilize views is that sometimes there are cases wherein a view gets out of date. This happens when you add a new column to a table a view is refrencing. To fix this some people would delete the view and recreate...

I've been doing a lot of code deployments lately and I've come across several occasions wherein my stored procedures wouldn't run as fast as expected compared to it's previously known execution time. The problem lies on the statistics not getting updated after change has been made against...

Here's an update to my blog entry 3 years ago regarding the same topic: ---Calculates the first day of the previous month SELECT DATEADD (mm, DATEDIFF (m, 0, GETDATE ()) - 1, 0) AS [First day of the previous month ] ---Calculates the first day of current month SELECT DATEADD (mm, DATEDIFF (m, 0,...

hi my name is danil espinosa from ZMG were a headhunting firm and right now were looking for IT professionals interested to work in Singapore. were looking for java developers, Perl developers, tester, release engineers (java) and application support analyst for our client base in Singapore. if anyone...

Finally i'm back after a month of crazyness due to my webhost not performing up to its promise of 99.9% uptime. Enough with the rant and on with the article, today i'm going to talk about how to list databases in a SQL Server by just using T-SQL and then showing you how to truncate the logs on...

we have a number of batch scripts at work which executes sql-related tasks for each of our project releases. last time, i incorporated errorlevel checks so we know if there was a problem with the execution and in order to abort the rest of the operations if something else has gone wrong. i was surprised...

For all the guys and girls out there who are interested in joining Lawson PSSC, you can email me your CVs (my email ad is monica.lacuna @ lawson.com ). Currently, there are NUMEROUS new positions open. If you have any background in developing or supporting ERP modules / web-based applications, there...

For all the guys and girls out there who are interested in joining Lawson PSSC, you can email me your CVs (my email ad is monica.lacuna @ lawson.com ). Currently, there are NUMEROUS new positions open. If you have any background in developing or supporting ERP modules / web-based applications, there...

ALGOS, INC. is a new company focused on providing consulting services in the Business Intelligence (BI) Software Market. BI is now the future of IT. When everyone has already all the necessary data they need captured on different ttransactional and operational systems like Oracle, SAP, ERIC and others...

Good day... I need your help guys... can somebody please state what's the difference bet. SQL Server Express and SQL Server Standard?? what are the features of both SQL? please pardon me about this, because i'm new in this field... Thank you guys... Have a merry christmas and a happy new year...