Every day, out in the SQL Server forums, the same questions come up again and again: why is this query running slow? Why isn't my index getting used? In order to arrive at the answer you have to ask the same return question in each case: have you looked at the execution plan? Grant Fritchey provides the only dedicated and detailed book on this essential topic.
2009-02-10
48,114 reads
A description of the things to avoid and do when involved with a beta test.
2008-09-26
2,895 reads
An overview of how to collect data from TSQL into Operations Manager Performance Rules.
2008-06-05
7,076 reads
Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.
2008-05-01 (first published: 2007-05-28)
18,504 reads
The trials and tribulations of our first attempt using Virtual Servers
2008-04-08
7,659 reads
Check Indexes on all databases and rebuild/reindex based on fragmentation
2008-02-01 (first published: 2007-04-05)
1,458 reads
In order to support multiple environments, a number of choices, not readily apparent, need to be made. This article outlines one approach that is working.
2008-01-24
3,495 reads
Testing is an important part of any software development process, but it's a part that many of us skimp on or ignore because of the tedious nature of testing. Longtime author Grant Fritchey has been working with Visual Studio Team Edition for Database Professionals and has written us an article on how you can make your unit testing easier.
2008-01-16 (first published: 2007-02-01)
7,860 reads
Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.
2006-11-15
9,950 reads
One of the fundamental skills a developer needs is the ability to test their code. Most people don't really do a good job, partly because they don't have a good process and leave testing until the end. Grant Fritchey brings us a new method of unit testing T-SQL stored procedures that can help you build automated tests for your code.
2006-06-20
17,776 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCP Permata Ujung Menteng Telpon/WA:085188120691 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18,...
BCA KCU KALIMALANG Telpon/WA:085188120691 Jl. Blk.Tarum Barat. E No.5, Wil. Kota, Kec. Duren Sawit,...
BCA KCP Buaran Raya Telpon/WA:085188120691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers