SQLServerCentral / Discuss Content Posted by Grant Fritchey / Article Discussions / Article Discussions by Author

Operations Manager Custom Collection

Grant Fritchey — Thu, 05 Jun 2008 00:18:53 GMT

Comments posted to this topic are about the item [B]Operations Manager Custom Collection[/B]

SQL Server Execution Plans

Grant Fritchey — Sun, 15 Feb 2009 09:44:16 GMT

Comments posted to this topic are about the item [B]SQL Server Execution Plans[/B]

Statistics in Execution Plans

Grant Fritchey — Wed, 21 Sep 2011 05:30:39 GMT

Comments posted to this topic are about the item [B]Statistics in Execution Plans[/B]

Set Up And Schedule a Server Side Trace

Grant Fritchey — Wed, 01 Dec 2010 22:13:00 GMT

Comments posted to this topic are about the item [B]Set Up And Schedule a Server Side Trace[/B]

2005 Clean Indexes For All Databases on a Server

Grant Fritchey — Sun, 23 Sep 2007 10:59:34 GMT

Comments posted to this topic are about the item [B]2005 Clean Indexes For All Databases on a Server[/B]

Unit Testing With Visual Studio

Grant Fritchey — Fri, 03 Nov 2006 10:09:00 GMT

Comments posted here are about the content posted at temp

The Red Gate Guide to SQL Server Team-based Development

Grant Fritchey — Thu, 21 Oct 2010 09:51:06 GMT

Comments posted to this topic are about the item [B]The Red Gate Guide to SQL Server Team-based Development[/B]

2008 Index Fragmentation Maintenance

Grant Fritchey — Sat, 08 Nov 2008 13:55:26 GMT

Comments posted to this topic are about the item [B]2008 Index Fragmentation Maintenance[/B]

Recovery to a Point in Time

Grant Fritchey — Sat, 04 Jun 2005 13:20:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/recoverytoapointintime.asp

Multi-Environment Deployments Using Team Edition for Database Professi

Grant Fritchey — Wed, 23 Jan 2008 21:54:20 GMT

Comments posted to this topic are about the item [B]Multi-Environment Deployments Using Team Edition for Database Professi[/B]

Review of the Maxpedition Aggressor Tactical Attache

Grant Fritchey — Fri, 24 Jul 2009 01:50:09 GMT

Comments posted to this topic are about the item [B]Review of the Maxpedition Aggressor Tactical Attache[/B]

Deploying Databases From Visual Studio Team System Database Edition

Grant Fritchey — Sun, 21 Jun 2009 00:44:36 GMT

Comments posted to this topic are about the item [B]Deploying Databases From Visual Studio Team System Database Edition[/B]

The T-SQL Quiz

Grant Fritchey — Mon, 30 Apr 2007 12:32:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/2973.asp

How to Take Part in a Beta Test

Grant Fritchey — Fri, 26 Sep 2008 00:20:40 GMT

Comments posted to this topic are about the item [B]How to Take Part in a Beta Test[/B]

Virtualization for Database Development

Grant Fritchey — Mon, 07 Apr 2008 23:43:22 GMT

Comments posted to this topic are about the item [B]Virtualization for Database Development[/B]

Mappings

SQLEngine — Fri, 08 Aug 2008 09:30:30 GMT

Grant, excellent article, thank youTwo questions that I have are:Is it possible to report on more than 4 items, since there're only 4 mappings available, or would you create a separate rule for that?If you want an alert generating rule, the Probe rule won't work, so I'll need to use the timed command->execute a script rule. Did you encounter any problems executing that one?;)

Virtualization & databases in production environments?

Ronald Green — Wed, 09 Apr 2008 16:35:42 GMT

Hello everybody,Does anyone have experience with work intensive SQL Server instances on virtual machines (VMware or Virtual Server/Hyper-V)? My concern is mainly to keep the same level of performance in terms of disk IOs (but also of CPU and memory) as on a physical machine, while having the benefit of virtualization as a Disaster Recovery solution and perhaps also as High Availability solution (this Vmotion feature of VMware I keep hearing about).Your thoughts and experience sharing much apprciated!!R. Green

RE:

satheesh-203398 — Thu, 27 Jul 2006 06:30:00 GMT

Hello Sir

SELECT S.IIATransactionId ,substring(rats_filename,1+patindex('%{________-____-____-____-____________}%',rats_filename),36) AS OracleTransactionIdFROM iiafeedtransaction S,ratsiiafeedtransaction oWHERE S.IIATransactionId *= substring(rats_filename,1+patindex('%{________-____-____-____-____________}%',rats_filename),36)AND o.Rats_filename IS NULLORDER BY S.IIATransactionId

i think you have executed this in Query Analyser and what you said is right. However, try exeucting this query as a view in enterprise manager and i hope you will see the result which you are interested in.

I have seen the difference in this way in another case as well.. where the select statements brings lot of fields.

this looks confusing but pls try once and when you get time, pls give feedback to me.

Best REgardsSatheesh

RE:

Werner Dreyer — Sun, 21 May 2006 12:50:00 GMT

The explanation for the result is: In TSQL-style joins, where-clauses for the outer table are used to filter the result set (as expected from a where clause), while clauses for the inner table, as the "o.Rats_filename IS NOT NULL" in the example, go into the on-clause in the corresponding ANSI join. As a consequence, you filtered out rows from the inner table "ratsiiafeedtransaction o", so the outer join puts nulls in the result for these columns. You cannot express what you intended in TSQL-style joins, but rather have to use ANSI joins instead.

RE:

James Slebodnick — Thu, 01 Feb 2007 10:09:00 GMT

Grant,

I think this article is a great primer for using VS to test stored procedures instead of other non-MS tools like SQL Unit etc.

I would like to see this methodology be applied one step further - to use to test SSIS packages. For me this is a very gray area in unit testing since (unless thing have changed) you can only test at the package level and not the individual "task" level and I havent seen hardly any "best practice" methodology. You can run individual tasks in the VS Business Studio project but I have not seen any caommands that would run an individual task from a command line, only the "whole" package. Can you provide me and community with any links that approach the subject of iunit testing SSIS packages and tasks in VS. Good article!

Regards

James

Putting Unit Tests to Work

Grant Fritchey — Fri, 12 Jan 2007 13:41:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/2805.asp

Unit Testing and Code Generation

Grant Fritchey — Fri, 09 Jun 2006 12:32:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/unittestingandcodegeneration.asp

Unit Testing and Code Generation

Grant Fritchey — Tue, 06 Jun 2006 22:13:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/unittestingandcodegeneration.asp

Outer Join Mystery

Grant Fritchey — Fri, 14 Apr 2006 18:17:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/outerjoinmystery.asp

Outer Join Mystery

Grant Fritchey — Fri, 14 Apr 2006 18:14:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/outerjoinmystery.asp

SQL 2005 for the SQL2K Developer Part 2

Grant Fritchey — Fri, 14 Apr 2006 18:14:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/sql2005forthesql2kdeveloperpart2.asp

SQL Rescue Review

Grant Fritchey — Mon, 12 Sep 2005 11:54:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/sqlrescuereview.asp

Migration to Production

Grant Fritchey — Wed, 16 Mar 2005 22:19:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/gFritchey/migrationtoproduction.asp