For performance concerns or when the need arises to do some data manipulation/updates/inserts or any other code that requires a loop, use a table variable instead of the ever expensive cursor.
2003-04-01
522 reads
Some time you need to know only Date without Time.This is simple function that allows you truncate datetime field to date only.This function can help you to construct dynamic T-SQL for select date period. P.S. Thanks for ispaleny! Conversion only for real not enough! It is necessary convert to real that correct errors near the […]
2003-03-28
411 reads
Andy recently implemented a SAN and shares some of the info he picked up during the purchase and implementation. This article also discusses briefly the differences between SAN and NAS, and has some links to other sites for more info as well.
2003-03-28
8,103 reads
This is a sp_password enhanced by Dmitri Bobkov (see http://www.sqlservercentral.com/scripts/contributions/718.asp) and re-enhanced with a small changes from SQL2kSP3.For SQL Server in Mixed Authentication mode this stored procedure helps to validate users password. Currently this procedure checks for the next requrements: password must have length at least 8 characters plus among them at least one digit […]
2003-03-27
467 reads
When you want to export a table structure to T-SQL, everyone always points you to Enterprise Manager, or a script that calls BCP.Sometimes, a developer either doesn't have access to those tools, or just doesn't want to use them (like me) out of spite.I made this T-SQL because it was educational, and noone else seems […]
2003-03-26
4,045 reads
Chris Kempster (frequent contributor to the site) has released an ebook titled SQL Server 2000 for the Oracle DBA. The press release contains a brief overview of the book plus links to several reviews. Priced at $20 per copy, not bad at all!
2003-03-25
2,836 reads
This script will obscure email addresses from robots even ones that ignore the tags to not snoop. Usually robots that ignore the tags, and the robots.txt file are used by spammers. They pull down the SOURCE of your page and scrape the email addresses from them. This script breaks the mail href into its base […]
2003-03-23
108 reads
The three functions here can be used to store Bit Masks as Integers.These are functions to convert an integer into a binary string. This can be useful if you store Bit Masks in your database as integers.For example .. '00000000000011111001001001110011' to 1020531Each Bit could represent an ON or OFF value. One integer columncould be equivalent […]
2003-03-21
4,029 reads
Lockwood Tech continues to grow it's product line! This link points to an info page provided by the vendor that highlights the capabilities of this reporting product.
2003-03-20
1,183 reads
A Procedure gather Server Statistic per day or per run this Procedure.Output: Table TBL_SERVERSTATISTICS. You can use the results to analyze SQL-Server performance problems. You can analyze what changed after install new hardware or software, add or remove Application/DB/File/Index/Table etc.Recommendations: Run a Procedure once every day.Warning: If sql-server restarted after last run a Procedurecurrent running […]
2003-03-13
1,059 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
I recently used accounting assignment help, and it made a huge difference in my...
Comments posted to this topic are about the item This Week's AI Trust Problem...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers