This funciont return a date without end-of-week , it is useful to calculate a new date for any payment!YOU CALL with 'dias_uteis(getdate(), 5)' and will get five useful days after today
2006-01-17 (first published: 2005-12-22)
87 reads
Despite a growing range of options for integrating mixed database environments, some companies are sidestepping the problem by moving to a single database platform.
2005-12-16
2,322 reads
This script will create a single-line ALTER TABLE statement for each column in any table to change the collation to match the 'database default'. This is best accomplished in the Query Analyzer -- simply run the script, select all the records, and paste them into a new window to run them.
2005-12-29 (first published: 2005-12-12)
2,231 reads
2005-12-30 (first published: 2005-12-09)
138 reads
The final installment of Steve Jones' series on employee retention. This one examines the employee point of view in looking for and finding the ideal job, which you will then want to look at the other techniques to ensure you are employed for a long time.
2005-12-08
6,915 reads
This VB script allows you to search DTS packages for keywords, etc. It is also useful for quickly locating what server a given package is on. This is very useful for debugging. Example - you want to know the name of every DTS package the touches a certain table. The text files generated contain the […]
2006-01-18 (first published: 2005-12-07)
5,994 reads
Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.
2005-12-05
3,803 reads
Data, information, and knowledge. They're all different concepts and we sometimes lose sight of the fact that there are differences. This is a good look at the difference.
2005-11-14
2,393 reads
Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a lot of information on the little guy. To that end, new author Tim Mitchell brings us a great overview on what you should consider when setting up a SQL Server environment for a small scale setting.
2005-11-14
8,230 reads
This script has been on the SQL Server Central site for a while and has been revised a number of times. I enclose yet another revision that works with SQL Server 2005 (June CTP anyway) with much thanks to all those who have contributed to it in the past.Terry Grignon
2006-02-08 (first published: 2005-11-11)
1,080 reads
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item The Last Good DBCC Run
Hi everyone I have a SP that finds the average based on 3 tables. ...
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers