Viewing 15 posts - 11,956 through 11,970 (of 26,486 total)
CELKO (5/15/2012)
May 15, 2012 at 1:48 pm
Alone (5/15/2012)
How to change non clustered index scan to non clustered index seek?The concerned tables already have non clustered index configured.
I have no idea based solely on what you...
May 15, 2012 at 1:44 pm
CELKO (5/15/2012)
May 15, 2012 at 12:37 pm
Welsh Corgi (5/15/2012)
The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches ore than one...
May 15, 2012 at 12:32 pm
halifaxdal (5/15/2012)
exec spGetCategoriesByDocIDAsTable 811
This will return result like:
ID Category Checked
1 Category1 0
2 Category2 0
3 Category3...
May 15, 2012 at 12:22 pm
bighow2008 (5/15/2012)
Thanks for the reply.I went with a simpleir query
update master_sub
set [lab count] = o_list.[lab count],
= o_list.
from master_sub m, o_list o
where m.id = o.id
Just one little thing,...
May 15, 2012 at 12:13 pm
There was a recent thread where the OP wanted to return the difference between two date/time values as hh:mm:ss. Does anyone remember this thread?
May 15, 2012 at 12:06 pm
L' Eomot Inversé (5/15/2012)
Revenant (5/14/2012)
GilaMonster (5/14/2012)
Revenant (5/14/2012)
GilaMonster (5/14/2012)
Steve Jones - SSC Editor (5/14/2012)
Jack Corbett (5/14/2012)
I haven't done a backup, restore, or anythign with security since I've been there.
Whaaa?...
May 15, 2012 at 11:55 am
Are you trying to move the sorting of the result set from the server to the client? How big is the result set?
May 15, 2012 at 11:48 am
Can you provide the DDL (CREATE TABLE statement) where this data is stored (and there by selected from). It wold help to know more about the data.
May 15, 2012 at 11:08 am
If you can swing it, try getting to PASS instead. Not saying its better, just saying you may learn more there and the opportunity to meet many of your...
May 15, 2012 at 9:59 am
Craig-315134 (5/15/2012)
This punter...
May 15, 2012 at 9:37 am
Give this a try.
SELECT TOP 1000
E.[Last Name]
, E.[First Name]
, E.[Department]
, Support.[SupportLvl]
FROM
...
May 15, 2012 at 9:32 am
Eugene Elutin (5/15/2012)
Lynn Pettis (5/15/2012)
Eugene Elutin (5/15/2012)
Transactions that involve table variables last only for the duration of an update on the table variable. Therefore, table variables require less locking and...
May 15, 2012 at 9:16 am
Craig-315134 (5/15/2012)
It's been an interesting ride! But I'm honestly at a loss to understand where Meryl Streep comes into any of this (although she was outstanding in Iron Lady).
My youngest...
May 15, 2012 at 9:11 am
Viewing 15 posts - 11,956 through 11,970 (of 26,486 total)