Linked servers are a way to link to different OLEDB compatible data sources from within SQL Server. One can create these links to either other SQL Server instances or even to other heterogeneous sources like Oracle, DB2 LUW, text files, MS Excel etc. This is akin to database links in Oracle which we
Other News
Using dbx collector
(Fairlie Rego) It is quite possible that you have a single piece of sql which consumes more and more cpu over time without an increase in logical i/o for the statement or due to increased amount of hard parsing.
FOR ALL COLUMNS SIZE AUTO
(Vivek Sharma) After publishing “Performance Issues after Migrating from Oracle 9i to 10g” on 3rd of July 2007, I received many mails across the globe to know to know about ‘FOR ALL COLLUMNS SIZE AUTO’. Many of them wanted to know what actually this option of method_opt does. So thought of writing a
Moving the Tempdb and Master Database in SQL Server
(Steven Warren) There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to pe
Configuration with XML
(Stanley B. Lippman) This is the second column in a series that explores using C++/CLI as a pure Microsoft .NET Framework-compliant language rather than as a transitional bridge in order to bring native C++ code into the managed environment. My application, EEK!, as described in the last column, is
Configuration with XML
(Stanley B. Lippman) This is the second column in a series that explores using C++/CLI as a pure Microsoft .NET Framework-compliant language rather than as a transitional bridge in order to bring native C++ code into the managed environment. My application, EEK!, as described in the last column, is
PHP Large result sets and summary tables
(Peter Zaitsev) We’re working with web site preparing for massive growth. To make sure it handles large data sets as part of the process we work on generation test database of significant size as testing your application on table with 1000 rows may well give you very dangerous false sense of securit
Are You A Real DBA??
Featured Article(s) Understanding Asynchronous Javascript and XML (AJAX) In the earlier days of classic web development scenario, every time a page was requested for, it had to be submitted to the web server. Hence, the application’s response time increased because of repetitive pages refreshes and reloads. Ajax is a cross-platform technology that can be utilized to make your web pages […]
SQL Server DBAs Visionary?
Don’t Miss The Latest SQL Server Show, SelectViews > Watch here – this week’s show is about understanding SSIS. What is "Vision" And Do You, As A DBA, Participate? Last week I posted a request for questions to be included in our survey of database professionals. One of the question suggestions I received (Thanks Jeremy!) was about vision. Specifically, do […]
InDesign CS3 and XML Authoring: Could be Good
(Eliot Kimber) In my new job at Really Strategies I have started digging pretty deeply into how to get XML into and out of Adobe InDesign CS3. This has turned out to be pretty interesting.