(Arup Nanda) What do you store in an Oracle database? Mostly it’s data that you store in a relational format for easy mapping into some type of defined pattern and in a defined datatype: customer names, account balances, status codes, and so on. But it’s also increasingly likely that you may need to
Other News
Finding out largest tables on MySQL Server
(Peter Zaitsev) Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted to post little query I use for the purpose so I can easily find it later, plus it is quite handy in a way it presents information:
Using Oracle Table Compression
(kocakahin) In a data warehouse database it is always likely to find some static data portion (usually a large portion) . This means that this portion of data will not be updated any more but rather it will be queried. In this post you will find the benefit of compressing your historical segments in
XML data type in SQL Server 2005 vs. VARCHAR (MAX)
(Michelle Gutzait) As a database administrator, I tend to look closely at performance issues and how to make sure the use of XML does not affect SQL Server performance. In this tip, I’ll take you through an example using two tables, one inserted and queried with XML and the other with the VARCHAR (M
Building Custom Reporting Services Reports for SQL Server Management Studio
(Gregory A. Larsen) When Microsoft released Service Pack 2 (SP2) for SQL Server 2005, they added a new feature called Custom Reports. This new feature allows you to build Reporting Services reports that can be rendered within SQL Server Management Studio (SSMS). There is no requirement to install Re
How Are NULLs Actually Indexed ? (Fascination)
(Richard Foote) A nice question by Jeff regarding how Oracle goes about indexing NULLs has prompted me to show how one could go about actually determining the answer. The basic question is are NULLs treated as just another column value and grouped accordingly or does Oracle have to somehow search th
How to Find Keywords in SQL Server Stored Procs and Functions
(Tim Ford) How many times have you had to troubleshoot or make changes to an existing database that is not documented properly or completely? Even need to look for a specific stored procedure that references a specific table or process? If you have intimate knowledge of the database then this may
Best Practices with SQL Server – Do You Review?
The Virtual Conference is NEXT WEEK! Have you registered yet? Don’t forget too, we have group rates available, just drop me a note. Curious about what it’s all about? Check out this quick video (30 seconds, wmv) then head to the conference site. Featured Article(s) Outsourcing and Improving Productivity I recall having a discussion with a Vice President of a […]
MicrAhoo! Acquisition and SQL Server
The Virtual Conference is NEXT WEEK! Have you registered yet? Don’t forget too, we have group rates available, just drop me a note. Featured Article(s) SQL Server 2008 ‘Katmai’ Change Data Capture (CDC) A brief overview of the CDC technology in SQL 2008. Single Backup Solution, Multiple Applications and Platforms If you’re tired of using different utilities and applications to […]
XQuery creates HTML including images
(Marc Van Cappellen) This is the fourth post in the series XQuery generating multiple documents. Today we show how to create an HTML document referencing JPEG files through XQuery. The DataDirect XQuery built-in function ddtek:serialize-to-url is used to save the JPEG images.