Viewing 15 posts - 1,726 through 1,740 (of 2,462 total)
reefshark (5/4/2010)
Are CTE's usually created by the DBA or the Developer?
it has nothing to do with developer or DBA , the person whoi knows/wants to work on TSQL ,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 7:59 am
Oscar Janson (5/5/2010)
I've read the article linked to your topmost signaturelink, and I've come up with the following. Hope it becomes clear enough. 🙂
/* Generating and populating tables. */...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 7:50 am
this is more or less business logic failure/misunderstanding by you ? . i would suggest break your SP( select statement ) in chunks then verify one by one.if you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 7:48 am
GregoryF (5/5/2010)
Bhuvnesh (5/5/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 7:25 am
Answer to your question has been given by Schadenfreude-Mei. if you are not satisfied with answer elaborate your question/requirement.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 6:56 am
Where is exec plan for IN query ? i didnt find it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 6:14 am
Best practice is create/transfer login to new server and then map users(should exist in particular database)there
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 6:01 am
MY BAD, i need a strong coffee.:-)
I treated (misread ) "non clus " index as "clus" and viceversa :-D. thats why i asked this foolish question
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 4:51 am
David Portas (5/4/2010)
SQLJocky (5/4/2010)
It's true that a nonclustered index always contains the cluster key columns
Here you are talking about "when the clustered index is not a unique index" ....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 4:23 am
hbujar (5/5/2010)
I create every month automatically partitions for tables, i have a question is it possible to delete the partitions physically from the disc which that partition is empty,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 4:09 am
george sibbald (5/4/2010)
I think we agree david that the important point is that the non-clustered index be covering.
thats true.above of all optimizer always choose that index which cost it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 4:01 am
David Portas (5/4/2010)
SQLJocky (5/4/2010)
It's true that a nonclustered index always contains the cluster key columns
something new to me . Are you sure for it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 3:59 am
moorthy.jy (5/5/2010)
master..xp_readerrorlog will list out the error logs.
but wont show the error log location/path .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 5, 2010 at 3:32 am
thanks a ton to all guys , i will keep ur thought and work acc to them while working in it , thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 8:29 am
CREATE FUNCTION [dbo].[uf_utl_SplitNString]
(
@InStr nvarchar(4000) = null ,
@token nvarchar(4000) = ','
)
RETURNS @RtnElement TABLE ( item nvarchar(4000))
AS
BEGIN
declare @rec_no int
declare @pos int, @tokenlen int
declare...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 8:27 am
Viewing 15 posts - 1,726 through 1,740 (of 2,462 total)