Viewing 15 posts - 18,646 through 18,660 (of 22,214 total)
I've done it both ways and either will work, but in the long run, keeping the PK name the same throughout the structure seems to lead to less confusion.
January 22, 2009 at 5:45 am
I'm inclined to say the second without any data. But I've seen instances where the first can be faster.
Testing and examining the execution plans are the only way to be...
January 21, 2009 at 1:07 pm
They are two different things.
A trigger fires in response to either data manipulation, a DML trigger, or certain structural changes, a DDL trigger.
A stored procedure is a piece of TSQL...
January 21, 2009 at 12:00 pm
Paul just twittered that he was finishing the first draft of the 2008 version.
January 21, 2009 at 11:47 am
Bob Hovious (1/21/2009)
I don't have...
January 21, 2009 at 11:21 am
Bob Hovious (1/21/2009)
I don't have...
January 21, 2009 at 11:19 am
Lynn Pettis (1/21/2009)
GSquared (1/21/2009)
What's up with the grapes table that only has a priority column? What does that have to do...
January 21, 2009 at 11:18 am
Lynn Pettis (1/21/2009)
Grant Fritchey (1/21/2009)
http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx
No answers to the questions, no further interaction at all. I wouldn't be surprised to see...
January 21, 2009 at 11:06 am
Michael Earl (1/21/2009)
Lynn Pettis (1/21/2009)
Grant Fritchey (1/21/2009)
http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx
No answers to the questions, no further interaction at all. I wouldn't be surprised...
January 21, 2009 at 11:03 am
Matthew Zuberko (1/21/2009)
I have a view which includes joins to a single table view and a single table subquery, and UDF is called in the column list. The query runs...
January 21, 2009 at 10:52 am
This is the second time this exact question has been posted:
http://www.sqlservercentral.com/Forums/Topic640498-1291-1.aspx
No answers to the questions, no further interaction at all. I wouldn't be surprised to see it again in two...
January 21, 2009 at 10:35 am
First, a question, you're moving 1.8 million rows out of the EventInformation_rob table. How many rows total are in the table? If you're moving most of the table, you're going...
January 21, 2009 at 8:11 am
I'd suggest getting a copy of the book "Database Administration" by Craig Mullins. It's not technical and it doesn't focus on SQL Server at all. Instead it talks about the...
January 21, 2009 at 7:54 am
Kent Waldrop (1/21/2009)
The same question was posted here:http://www.sqlservercentral.com/Forums/Topic639228-145-1.aspx
You responded to that post also.
I thought I remembered seeing that before.
January 21, 2009 at 7:41 am
george sibbald (1/21/2009)
Grant Fritchey (1/21/2009)
January 21, 2009 at 7:06 am
Viewing 15 posts - 18,646 through 18,660 (of 22,214 total)