Viewing 15 posts - 40,741 through 40,755 (of 49,571 total)
Asha Richardson (2/26/2009)
INSERT @OrdersSELECT @OrderId, ProductId, (Quantity * UnitPrice) As ItemTotal
FROM [Order Details]
WHERE @OrderID IN (select orderID from @CaracasOrders)
Use =...
February 27, 2009 at 2:08 am
Or detach, copy files, attach. Either will work
February 27, 2009 at 1:58 am
Can you explain a bit more what you're trying to do?
February 27, 2009 at 1:53 am
sqlserverdba.dba (2/27/2009)
Thanks. But i need to run it on on-going basis. Will this not cause an overhead on performance if I run daily?
Not if you do it properly. Server-side trace...
February 27, 2009 at 1:52 am
That'll say index seek but, behind the scenes it's almost equivalent to an index scan.
Seek to find the start of the range for column 1 - the beginning of the...
February 27, 2009 at 1:51 am
Lynn Pettis (2/26/2009)
Didn't get me to the page where we discussed it, but it gets to the thread
I can find the thread just fine, all 200 pages of it!
I think...
February 26, 2009 at 4:35 pm
Steve Jones - Editor (2/26/2009)
Bob Hovious (2/26/2009)
Sheep without a shepherd are prone to wander....
I'm just glad we have a consistent URL and I don't need to Google for this. Not...
February 26, 2009 at 4:11 pm
Jeff Moden (2/26/2009)
All database names, table names, procedure names, column names, column aliases, variable names (basically, my stuff) etc, in MixedCase with no underscores. ...
February 26, 2009 at 1:44 pm
GSquared (2/26/2009)
February 26, 2009 at 12:40 pm
Jack Corbett (2/26/2009)
At least the first post hits the high points and keeps you up to speed.
Yup. Half way through and I was reaching for my books. I really enjoyed...
February 26, 2009 at 12:18 pm
GSquared (2/26/2009)
CREATE NONCLUSTERED INDEX [IX_NONCLUSTERED_ORDER_BY_KEYS_PersonURN_200901] ON [dbo].[PersonURN_200901]
(
[ServiceDate] DESC
[Client_id] )
INCLUDE
(
...
February 26, 2009 at 12:14 pm
While following links from that, I ran across this: http://www.tor.com/index.php?option=com_comprofiler&task=searchByTag&tag=Wheel%20of%20Time%20re-read
A re-read and summary of the entire Wheel of Time, reducing each chapter to what looks like 500-700 words. At that...
February 26, 2009 at 11:13 am
Lynn Pettis (2/25/2009)
Someone want to explain what the statistics profile is saying?
Each line in the stats profile corresponds to an operator in the query. If it were a...
February 26, 2009 at 10:10 am
Viewing 15 posts - 40,741 through 40,755 (of 49,571 total)