SQL Tips
Tag details
Welcome to the 'SQL Tips' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'SQL Tips'.
Latest blogosphere posts tagged “SQL Tips”
-
SQL SERVER – Whitepaper SQL Server 2008 Full-Text Search: Internals and Enhancements
Journey to SQL Authority with Pinal Dave —
Authority: 530
Database systems must go beyond the traditional realm of relational data by covering an increasing amount and variety of unstructured and semistructured information, be it speech, documents, XML, bioinformatics, chemical, or multimedia. Search is a key technology capable of working with vast amounts of data: it is ...1 day ago -
SQL SERVER – CDC and TRUNCATE – Cannot truncate table because it is published for replication or enabled for Change Data Capture
Journey to SQL Authority with Pinal Dave —
Authority: 530
Few days ago, I got the great opportunity to visit Bangalore Infosys. Please read the complete details for the event here: SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore . I mentioned during the session that CDC is asynchronous and it reads the log file to populate its data. I had received a ...2 days ago -
SQL SERVER – ORDER BY Clause and TOP WITH TIES
Journey to SQL Authority with Pinal Dave —
Authority: 530
Recently, on this blog, I published an article on SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY; this article was very well received because of the observation made in it. One of the comments suggested the workaround was to use clause WITH TIES along with TOP and ORDER BY. That is not the ...4 days ago -
SQL SERVER – ORDER BY Clause and TOP WITH TIES
Visit SQLAuthority.com —
Authority: 127
Recently, on this blog, I published an article on SQL SERVER – Interesting Observation – TOP 100 PERCENT and ORDER BY; this article was very well received because of the observation made in it. One of the comments suggested the workaround was to use clause WITH TIES along with TOP and ORDER BY. That is not the ...4 days ago -
Windows 7 Company in free test for 90
Script For All —
Authority: 128
Technology – companies S? not being yet procurees version RTM of Windows 7 can from now on download it in French and L? to use free during 90 days. Attention however since the number of licences available is limiting. Microsoft has obviously very has heart to convince the companies D `to [...]4 days ago -
SQLAuthority News – Meeting SQL Expert Imran at Hyderabad
Journey to SQL Authority with Pinal Dave —
Authority: 530
I was very fortunate to meet the SQL Server Expert and one of the top participants of this blog Imran Mohammed . Imran has been very active on this blog and have previously contributed with few articles as well. I have been communicating with Imran for a long time; he is always very active and quick to reply. Many ...5 days ago -
SQLAuthority News – Meeting SQL Expert Imran at Hyderabad
Visit SQLAuthority.com —
Authority: 127
I was very fortunate to meet the SQL Server Expert and one of the top participants of this blog Imran Mohammed . Imran has been very active on this blog and have previously contributed with few articles as well. I have been communicating with Imran for a long time; he is always very active and quick to reply. Many ...5 days ago -
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
Journey to SQL Authority with Pinal Dave —
Authority: 530
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column . The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9 . One of the very interesting points that was discussed on show was about ...6 days ago -
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
Visit SQLAuthority.com —
Authority: 127
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column . The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9 . One of the very interesting points that was discussed on show was about ...6 days ago -
title
Script For All —
Authority: 128
Cloud Computing: great refractory groups in public Cloud – Current events – ZDNet. Fr Plays vidé O of Noë L Activetechpros class=”; clearfix tWhite whiteLink”; >; Copyright &Copy; 2009 Interactive [...]6 days ago -
SQLAuthority News – Migrating DTS Packages to Integration Services
Journey to SQL Authority with Pinal Dave —
Authority: 530
SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and DBAs engineer an ETL process. In this whitepaper, you will see the benefits of ...1 week ago -
SQLAuthority News – Migrating DTS Packages to Integration Services
Visit SQLAuthority.com —
Authority: 127
SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and DBAs engineer an ETL process. In this whitepaper, you will see the benefits of ...1 week ago -
SQLAuthority News – Migrating to SQL Server from Other Database Products
Journey to SQL Authority with Pinal Dave —
Authority: 530
Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL Server 2008 This white paper explores challenges ...1 week ago -
SQLAuthority News – Migrating to SQL Server from Other Database Products
Visit SQLAuthority.com —
Authority: 127
Guide to Migrating from MySQL to SQL Server 2008 In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server. Guide to Migrating from Oracle to SQL Server 2008 This white paper explores ...1 week ago -
the setting day of Windows Vista towards Windows 7 will be able to take 30 minutes 21 hours
Script For All —
Authority: 128
Technology – Microsoft proceeded has an evaluation of the various scenarios of update of Windows Vista towards Windows 7. There are great differences according to the type D? installation and configuration of the PC. class=”; poll”; >;Survey of the 14/09/2009 to the 14/10/2009 8112 votes Do you consider an ...1 week ago -
SQL SERVER – Differences in Vulnerability between Oracle and SQL Server
Journey to SQL Authority with Pinal Dave —
Authority: 530
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A. Microsoft development platforms are ...1 week ago -
SQL SERVER – Differences in Vulnerability between Oracle and SQL Server
Visit SQLAuthority.com —
Authority: 127
In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A. Microsoft development platforms are ...1 week ago -
SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation
Journey to SQL Authority with Pinal Dave —
Authority: 530
To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,” or enterprise data warehouse (EDW) that supports company-wide detail data is achievable, building and maintaining “spokes,” or ...1 week ago -
SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation
Visit SQLAuthority.com —
Authority: 127
To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,” or enterprise data warehouse (EDW) that supports company-wide detail data is achievable, building and maintaining “spokes,” or ...1 week ago -
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Journey to SQL Authority with Pinal Dave —
Authority: 530
I would like to start this post with an interesting question: Where in MS SQL Server is “100” equals to “0”? And I am not talking about data types now.. Today I will be presenting the answer to this question and some topics related to it. Creating Indices in SQL Server is one of the most important ...1 week ago

