Common issue understanding the ways of the Foreign Key.

Every now and then if I haven't done one in months... I gotta go look!

Now which way does this thing go? ...

Aha, I think I understand now. How about this...

SELECT ParcelID from Field_Data where ParcelID not in

(SELECT ParcelID from GIS_Data)

Are any rows returned? Do all of the records...

More for you Paul....

The script I built was just so I can conceptually show you a simple example with your names. Run this script against a test blank test database.

It...

Hi Paul,

I guess this comes down to the guts of a Foriegn Key. What you are saying in your design is that you don't want any records in the...

A primary key is not needed, but a unique constraint at minimum.

CREATE TABLE GIS_Data

(ParcelID int)

CREATE TABLE Field_Data

(ParcelID int)

INSERT into GIS_Data

select 1 union

select 2 union

select 3 union

select 4 union

select 5...

9004 is a corrupted log file. See http://msdn.microsoft.com/en-us/library/aa337407.aspx

You may try...

move your .ldf file out to a temp directory.

IN Management Studio right-click> attach > add you .mdf file

Remove the log...

I borrowed a bit of logic from Pinal Dave http://blog.sqlauthority.com/2007/04/29/sql-server-random-number-generator-script-sql-query/

It will generate a random startdate and enddate between a range of dates. So in this example, setting @DateRangeStart to...

The best QotD's are the one's that cause such outrage! Just think of this... these contoversial questions cause us all to go investigate, research, etc. Personally, you can...

Found it! these folks ran accross the same issue. Looks like taking SQL resource offline from cluster administrator first does the trick.

http://www.sqlservercentral.com/Forums/Topic485250-357-1.aspx#bm485257

What a puzzle! And I can't seem to find anything about it documented anywhere. Sort of a catch-22 right? Start the SQL instance in single-user mode, but some...

I've been playing around with it trying to get grasp on PIVOT as well:

create table #temp

(month int,

category int,

value int)

insert into #temp

select 1,1,10 union

select 2,2,5 union

select 2,1,10 union

select 3,2,15 union

select 4,1,10...

Hi Edwin,

You could try running clusprep.exe

http://www.microsoft.com/downloads/details.aspx?FamilyID=bf9eb3a7-fb91-4691-9c16-553604265c31&displaylang=en

It runs some checks to see if you are properly configured for clustering.

I wonder if maybe you don't have a problem with...

Hi ezhil,

I battled with this one for a while. Try this out...

sp_MSforeachdb 'USE ? EXEC (''CREATE PROCEDURE TestProc AS BEGIN SELECT 1 END'')'

The only way I could get...

Working on the same issue here, and have started playing with some queries using AdventureWorks. But yes.. you are correct. The idea is that new filegroups are created...

If in multiple columns and you've got leading or trailing spaces:

CREATE TABLE #NAMES

(FirstName varchar (25),

LastName varchar (25))

INSERT INTO #NAMES

SELECT 'Bob ','Johnson ' UNION

SELECT ' Bob',' Johnson' UNION

SELECT...