If you think you know, then you have become ignorant; you have stopped your own evolution. I agree with most of the above posts: collaboration is number one.

Recently people...

Interesting article although it dwells more on C# than SQL. I too find Agile and Extreme Programming books fascinating but never found a way to make them useful in...

You're not gaining anything because you need to do a full backup immediately after doing your changes. There used to be a command to "dump tran with no_log" but...

I still strongly disagree. UDFs are much, much easier to incrementally add customization rather than throw away a CTE because it can no longer be used because of additional...

I'm completely sick of anti-rbar preachers. They're just getting their ego kicks through trying to one-up everybody. Here is what is happening: code is being run on a...

Only use nvarchar if you really need unicode otherwise use varchars. I make my varchars as small as possible because reports are generally formatted to handle the largest data...

This function will return an int from the beginning of a string.

SELECT dbo.LeadingNumbers('4568 Lancaster Avenue');

SELECT *

FROM Addresses

WHERE AddressLine like '%Lancaster%'

AND dbo.LeadingNumbers(AddressLine) >= 4000

AND dbo.LeadingNumbers(AddressLine) < 5000

;

IF EXISTS (SELECT *...

A "good" way to perform your query would be to design the table with address parts instead of address lines.

primary_number: ...

Here is an attempt. I would write a procedural function to add tons of checking before moving this to production.

declare @temp table (MyValues varchar(50));

insert into @temp values ('3/24/12 Saturday

')

insert...

-- You can put this in your templates for easy reuse

declare @list table (name varchar(128) not null);

-- fill the list with your custom subset

insert into @list

select name from sys.databases where...

declare @TableName varchar(128);

set @TableName = 'sysdiagrams';

if exists

(

select i.rowcnt

from sys.tables t

join sys.sysindexes i on t.object_id = i.id

where indid in (1,0)

and t.name = @TableName

)

print 'yes'

;

The whole mess of programming "between" different apps and data requires scripting or macro languages which are usually syntactically very ugly and kludgy. I generally end up doing a...

Check the column or parameter definitions for char instead of varchar. Conversions between those are very tricky.

Here are an additional 2600 nicknames in my attachment to add to the attachment in the post above.

My recommendation is to separate male from female names. Also use a...

I've used the rule in the past of logs get mirrored and data gets RAID 5. It seems to be a losing battle against the network guys who like...