http://www.mssqltips.com/ Last five SQL Server tips from MSSQLTips.com en-us http://www.mssqltips.com/images/mssqllogo.gif http://www.mssqltips.com 119 70 Thu, 11 Mar 2010 08:00:00 GMT You’re leaving your current employer for a new opportunity and want to make the move as smooth as possible. You don’t want to burn your bridges and want to make sure that everything you’ve left behind can be managed by the people you’ve left behind or the DBA who is replacing you. So, you’ve done your handover documentation and trained up the new guy. You definitely don’t want to be that DBA who is cursed the week after they leave when their network account is disabled and a bunch of stuff ‘breaks’. http://www.mssqltips.com/tip.asp?tip=1960 Thu, 11 Mar 2010 08:00:00 GMT Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you are asked to provide proof that the audit itself has not been tampered with. http://www.mssqltips.com/tip.asp?tip=1959 Wed, 10 Mar 2010 08:00:00 GMT SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APPLY operator becomes evident when you have a table-valued expression on the right side and you want this table-valued expression to be evaluated for each row from the left table expression. In this tip I am going to demonstrate what APPLY operator is, how it differs from regular JOINs and what are few of its applications. http://www.mssqltips.com/tip.asp?tip=1958 Tue, 9 Mar 2010 08:00:00 GMT The SQL Server Integration Services (SSIS) Merge Join transformation requires input data streams to be sorted for its operation. If during the design time you try to join two non-sorted inputs, it won't allow you to do so. One of the options is to sort the data in the database rather than using the Sort transformation in SSIS, which is a more speedier option. But if the sort order is changed unknowingly, SSIS would not raise an exception and the results would be unpredictable. http://www.mssqltips.com/tip.asp?tip=1957 Mon, 8 Mar 2010 08:00:00 GMT The institution I work with receives data files in a variety of formats for import into a central SQL Server 2000 repository. We have a good handle on importing the files; however, some of the providers want to send data using XML files. Is there a simple process I can create to import these files? http://www.mssqltips.com/tip.asp?tip=1956 Fri, 5 Mar 2010 08:00:00 GMT