SQLCLR is used to code SQL Server functions using some flavor of .NET, as opposed to T-SQL. They can be useful for bringing business logic closer to the raw data...

Glad you got it running. I know how troubleshooting Replication issues can make for some long days.

There sort of is...

Brandie Tarvin (11/10/2011)

How about queries with joins to tables that aren't used anywhere in the query. As if the dev changed track mid-stream and forgot to clean up afterwards? (I...

I can see this. If Google forced everyone to...

When reviewing colleagues' code, I find that there can be three things that get pointed out:

1) Bugs: in this case they should be grateful that you found something they missed...

Jack Corbett (10/6/2011)

create function [dbo].[SYSDATE]()

returns datetime

as

begin

declare @sysdate_l datetime

select @sysdate_l = sdv.system_date

from...

While I agree completely with Grant that fetching data you may not need can add unwanted, and unneeded, overhead to to back-end systems, there's can be an efficiency in returning...

If it's a development database, can you simply replace the data using the same table in production? This may not include data modified during development, though if you saved your...

GilaMonster (9/14/2011)

---

Another request:

I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction Logs[/url]. Other than when and when not to shrink (which definitely has...

GSquared (9/14/2011)

•80 percent of poor households have air conditioning

•Nearly three-fourths have a car or truck, and 31 percent have two or more cars or trucks

•Nearly two-thirds have...

The Geospatial features in 2008 (and 2008R2) are very cool and have the potential to become an in-demand skill set.

I'm using figures from sources like the US Census Bureau, the US Department of Labor, and various Congressional reports.

...

Most of the people in the US have never encountered actual...

Grant Fritchey (8/26/2011)

---

Need the advice of the Thread.

Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four...

Jeff gets my vote.

One of the first articles I read on...