(Jay Nathan) Data cleansing is an important task for data warehouse specialists, database administrators, and developers alike. Deduplication, validation, and householding techniques can be applied whether you are populating data warehouse dimensions, integrating new data into an existing transactio

(Paul Kimmel) Data is king. Companies such as Google and eBay are based primarily on the value of their data. (In Google’s case, the data is actually indexes of data.) Providing access to data often is either mission critical to a company or the company’s raison d’être.

(Serdar Yegulalp) SQL Server stores data in “pages” or allocation units of approximately 8,000 bytes. If you want to see the raw data in a given database page and interpret the information produced, you can dump that data to the console (or to the SQL Server log) using the undocumented DBCC PAGE com

(Hilary Cotter) In larger development shops, you may find a dedicated SQL developer or even a SQL development team as well as a data architect (or data modeler), who is responsible for designing the logical and physical data models. The SQL development team often works independently or asynchron

(Matthew L. Wigdahl) Well, not really. But it is vitally important to understand when to use them and when to avoid them, as well as how best to construct them so as not to shoot your foot off.

(Arthur Fuller) Despite your numerous explanations about the value of identity columns and the usefulness of their arbitrary values, some of your coworkers insist upon sequential PKs within a given table. Then, when invoice numbers are missing, they panic, fearing litigation, fraud, or worse.

(KOMTEL_NET) The most often job we have to do during writing queries are the basic stored procedures for manipulating datas on existing tables of database. It is perhaps the most thing for hesitate and make of syntax errors. Project developed helps avoiding things mentioned, you just will fill requi

In Microsoft SQL Server 2000, when you open a server-generated trace file in SQL Profiler or when you read the trace file by using the fn_trace_gettable function, the trace file may be reported as corrupted. If you examine the file by using a hexadecimal editor, the section that was read when the er

(Douglas Reilly) In part 1 of this series, I wrote about the reasons you should backup. From losing your job, to killing off the company, to obeying the law, there are lots of reasons to backup in general, and to do SQL Server backup in particular. Unfortunately, SQL Server backup is a lot harder

(William Pearson) In this article, we will look at a common business need, the aging of values. Aging is typically a process by which the enterprise determines the length of time that has transpired since a transaction (usually financial) has taken place within an account. Examples of common sub