Viewing 15 posts - 676 through 690 (of 2,008 total)
Refresh your memories please 😉
Below is NON-ANSI outer join example for Oracle. Was it working for SQL Server as well?
SELECT T1.ID
FROM
T1,
T2
WHERE
T1.ID = T2.ID(+) -- OUTER JOIN
December 22, 2011 at 1:27 am
assistan11 (12/21/2011)
@dev Try open http://img100.imageshack.us/img100/9936/42805049.jpg
Thanks for sharing it but I can't access it. Never Mind...
You got what you were expecting from SSC. Enjoy 😉
December 22, 2011 at 1:18 am
One of my bad habits, if I need some info then I NEED that info. 😀
Google-d it and found one snippet of Temporary Stored Procedure (sharing it here). But it’s...
December 22, 2011 at 1:13 am
Judging a design as Good or Bad is very difficult because it’s usually a trade-off. If design advantages beets design limitations I would consider it Good Design.
I prefer Flexible Data...
December 22, 2011 at 12:42 am
Jeff Moden (12/21/2011)
December 22, 2011 at 12:29 am
Jeff Moden (12/21/2011)
Dev (12/21/2011)
"Doctor & Mrs. Johnathan van Huron Esq. - DO, MD, MVP"
Title FName LName Degree
Agree on Names but Titles & Degrees shouldn't be in source data.
"Shouldn't...
December 21, 2011 at 11:08 pm
David Moutray (12/21/2011)
Jeff Moden (12/21/2011)
David Moutray (12/21/2011)
Is anyone aware of an incident where a database administrator "went postal" on an application development department?
Yep... me. I got tired of some...
December 21, 2011 at 10:59 pm
ahmed_b72 (12/21/2011)
frankly, that doesn't make sense to me...but thank you for clarification anyway.
Me too...
I don't have access to SQL Server right now. Can you please try following?
EXEC SA.MYCUR1 sysdatetime() --...
December 21, 2011 at 10:53 pm
Can I define a proceudre B in procedure A?
NO
so that procedure B can
onlybe called by the code in procedure A.
YES
For More: (Check for Best Practices & Restrictions)
December 21, 2011 at 10:45 pm
In my organization, we have restricted the use of VIEW to avoid these problems. It’s equivalent to adding a TABLE (virtually) and requires approval from Architects / DBAs.
December 21, 2011 at 10:40 pm
@Minto: Please don't hijack the thread and post your problem in another thread. You have different issue than OP (Venu). For almost 10 minutes, I was trying to figure out...
December 21, 2011 at 10:34 pm
"Doctor & Mrs. Johnathan van Huron Esq. - DO, MD, MVP"
Title FName LName Degree
Agree on Names but Titles & Degrees shouldn't be in source data.
December 21, 2011 at 10:19 pm
SQLRNNR (12/21/2011)
December 21, 2011 at 5:25 pm
bcsims 90437 (12/21/2011)
disappointed'cuz no trip to space
Really??? :w00t: Please confirm it. I can't access that URL (it's blocked).
December 21, 2011 at 5:01 pm
Most probably the covering index is forcing Optimizer to perform better for more columns.
INCLUDE (column [ ,... n ] )
Specifies the non-key columns to be added to the leaf level...
December 21, 2011 at 4:33 pm
Viewing 15 posts - 676 through 690 (of 2,008 total)
