Viewing 15 posts - 256 through 270 (of 2,462 total)
http://technet.microsoft.com/en-us/library/ms175106.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 6:39 am
Ford Fairlane (9/12/2013)
some of those users are going up to a mine site where the link is over satellite so latency is rather large
Please elaborate.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 6:12 am
select * from information_schema.columns
where column_name like '%col1%'
OR column_name like '%col2%' OR column_name like '%col3%'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 6:09 am
kapil_kk (9/16/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 5:34 am
wendy elizabeth (9/14/2013)
Thus cany ou tell me what I can do to make this sql run faster?
what made you to think that this query is behaving bad ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 5:27 am
i will second Jeff here. Do the NULL handling in all the vairables (ISNULL(@variable, ''))
Also Before sendin it to DBmail
Print the Text for @Subj =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 4:58 am
Thanks a ton for help ..to all guys here 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 1, 2013 at 3:02 am
Need help ..please .......
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
June 30, 2013 at 10:36 am
DBA_Learner (3/15/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2013 at 5:04 am
Now people would be looking for exec plan here 😀 like me .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 22, 2013 at 3:23 am
rohit.anshu (3/21/2013)
1. would a NC/C index slow down the truncation(not delete) of data from a huge table.
No. Truncation command dosent touch the indexes.Thats the another reason why truncate is faster....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 21, 2013 at 5:27 am
Minnu (3/21/2013)
1A
2B
3C
4D
5E
Tabe_2 : ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 21, 2013 at 5:19 am
kk.86manu (3/21/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 21, 2013 at 5:16 am
Kwisatz78 (3/21/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 21, 2013 at 4:57 am
declare @max-2 int , @cnt int
declare @t table (id int ,Company varchar(50),Site nvarchar(20),TransDate Datetime)
set @cnt =1
--select * from #TransDetail
select @max-2 = MAX(Number) from #TransDetail
while ( @max-2 >...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2013 at 6:06 am
Viewing 15 posts - 256 through 270 (of 2,462 total)