Viewing 15 posts - 21,781 through 21,795 (of 26,484 total)
Even in an OLTP system there is a point at which you stop normalizing the data and start denormalizing it. There are trade offs that are made during this...
March 25, 2009 at 10:08 am
I am assuming you are running your query from Management Studio. Run the query in one tab, and run SP_WHO2 in a second while your first query is active....
March 25, 2009 at 10:01 am
Can't really help you based on what you posted. Does the query complete, just not as quickly as for previous day data? You may want to capture and...
March 25, 2009 at 9:49 am
RBarryYoung (3/25/2009)
I tried deleting the duplicates, but I don't think that...
March 25, 2009 at 8:48 am
RBarryYoung (3/25/2009)
Grant Fritchey (3/25/2009)
I just don't understand how you do it Lynn. I...
March 25, 2009 at 7:03 am
Jeff Moden (3/24/2009)
RBarryYoung (3/24/2009)
GilaMonster (3/24/2009)
RBarryYoung (3/24/2009)
Q: How many psychiatrists does it take to change a light bulb?
A: Only one. But it takes a very long...
March 24, 2009 at 5:03 pm
And then to read CozyRock's last post, sorry, but that doesn't show me much in the way of character. Personal opinion. I guess I hold myself to a...
March 24, 2009 at 4:43 pm
Steve, Not a problem. You'll get my bill in the mail. 😉
It just felt right to try and step in and help smooth out a possible problem before it...
March 24, 2009 at 4:35 pm
I'd like to verify something first. You have posted this question in a SQL Server 7, 2000 forum, ar you using SQL Server 2000 or SQL Server 2005?
The answer...
March 24, 2009 at 4:20 pm
polo_sport09 (3/24/2009)
when i drop all my tables and recreat them and insert whit this...Insert into personal (chef_id,lonekat_id,fornamn,efternamn,titel)
VALUES (NULL,1,'Johan','Forsberg','Säljare');
Then the personal_id on personal get the value of 3
what does this mean?
It...
March 24, 2009 at 4:17 pm
polo_sport09 (3/24/2009)
VALUES (34,1,'Johan','Forsberg','Säljare');
Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK__personal__chef_i__2645B050". The conflict occurred in database "Gangster",...
March 24, 2009 at 4:15 pm
Two things. What is the error message you are getting, and what is the actual INSERT statement look like, or did i just miss it in your original post?
March 24, 2009 at 4:00 pm
Looks like CR has left for the day.
Maybe cooler heads will prevail tomorrow.
March 24, 2009 at 3:54 pm
Bob Hovious (3/24/2009)
(rolling 3xD6 for wisdom.... apply modifiers for age and experience .... )I make you out to be a 20 for Wisdom, Lynn.
And my wife would probably say that...
March 24, 2009 at 3:43 pm
Very true, Roy, definitely a communication break down. However, even though the OP didn't state they were lost and had no clue, CR didn't need to be unresponsive to...
March 24, 2009 at 3:40 pm
Viewing 15 posts - 21,781 through 21,795 (of 26,484 total)