Viewing 15 posts - 2,206 through 2,220 (of 2,462 total)
Post your Execution plan
and IO statistics.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 2, 2010 at 7:00 am
No, query is returning correct results.
i have planned to add event_duration column as include column.
Will it help ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2010 at 11:05 pm
create nonclustered index idx on #emp (e_name)
create nonclustered index idx on #dept (dept_name)
select
e.e_name,
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 25, 2010 at 7:06 am
Why u require User defined variables , what exactly u want to do, post some details about your issue
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 20, 2010 at 5:50 am
RESOLVED !!!!!!!!!!!!!
i simply opened it in notepad and replace d: with t::-P
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 20, 2010 at 5:47 am
can u post the link ? where i can find the difference between them
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 19, 2010 at 5:45 am
GO
CREATE TABLE dbo.PENDING_ANSWER_FILE
(
acct_id dbo.ut_synthetic_key NOT NULL,
qstn_stub dbo.ut_stub NOT NULL,
entity_stub dbo.ut_stub NOT NULL,
evt_stub dbo.ut_stub NOT NULL,
invitee_stub dbo.ut_stub NOT NULL,
entity_type_id smallint NOT NULL,
answer_file_stub dbo.ut_stub NOT NULL,
physical_file_name dbo.ut_medium_description NOT NULL,
friendly_file_name dbo.ut_medium_long_description NOT NULL,
file_image...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 19, 2010 at 5:35 am
amar , try to run the script i pasted in my previous past and u will find reply
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 19, 2010 at 5:28 am
i read that (you had asked me in my prior post)
but how it will help
when we have table (with Pk + non clustered ) on one filegroup
and clustered...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 19, 2010 at 5:03 am
is this what u looking for ?
create table #tmp
(
Roll_No int,
S_Name nvarchar(100),
Subject nvarchar(100),
Branch nvarchar(20))
insert into #tmp
select 1 , 'jack', 'Bio', 'A' union
select 1 , 'alex', 'tech', 'f' union
select 1 , 'Sona',...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 19, 2010 at 5:00 am
send some sample data and ur requirement ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 19, 2010 at 4:11 am
Thanks
it working well
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 18, 2010 at 10:32 pm
Gail ,
Thanks a lot , your links helped me a lot.
i am very curiuos about how index works and found very interesting them.
mean while, i am also...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 13, 2010 at 10:53 pm
hi
i read somewhere in your blog ( missd that ) . where you have mentioned about the link
from where i can douwnload eBook of Sql server 2005 :...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 12, 2010 at 7:01 am
Thanks a lot
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 12, 2010 at 5:07 am
Viewing 15 posts - 2,206 through 2,220 (of 2,462 total)