Viewing 15 posts - 1,156 through 1,170 (of 2,462 total)
SELECT BloggerName,Topic,[Year],Total,count(*)
FROM
BlogCount
group by BloggerName,Topic,[Year],Total
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 1:36 am
y.loewidt (12/7/2010)
"Kill SPID" merely makes the SP status KILLED/ROLLBACK but doesnt kill it
"Kill" always results the data in consistent state;either commit or rollback
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 8, 2010 at 12:04 am
anitha.chacko (12/7/2010)
Can u please tell me how to convert it exactly
http://msdn.microsoft.com/en-us/library/ms187928.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 7, 2010 at 11:24 pm
create the exec plan for both the approaches.and post it here along with index/table definition.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2010 at 11:14 pm
AlreadyPicked (12/6/2010)
If anyone knows why the resultset of sys.databases system view might change like that during a backup loop, feel free to enlighten me up!Thanks.
Sometime i observed that these...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2010 at 9:29 pm
ignacio.aranda (12/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2010 at 3:56 am
TcW_1978 (12/3/2010)
Where can I find that 'Schema Changes History' report for that database?I searched everywhere, to no avail.
Thanks
See my attachment. do we need set any settings/configuration ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2010 at 3:42 am
anolan (12/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2010 at 3:01 am
sraned (12/5/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2010 at 12:06 am
Sachin Vaidya (11/29/2010)
If I do,
SELECT col1, col2....
FROM table1 AS A
INNER JOIN
(SELECT col3, col4....
FROM table2) B
ON A.col1 = B.col3
Or, I first take the inner query in a temp table first and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 3, 2010 at 4:11 am
Dipesh Neema (11/30/2010)
Should i use like operator for that ? i am searching in the 6 varchar fields and table size is 15mil records.
Well , it depends if you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 3, 2010 at 4:08 am
AlreadyPicked (11/30/2010)
On some nights (about one out of three), the loop exits without any errors while there are still databases in the cursor.
it might be happening when it starts...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 3, 2010 at 3:45 am
Post your script which you are using
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 30, 2010 at 5:25 am
see this link also http://www.sqlservercentral.com/Forums/Topic1026649-145-1.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2010 at 6:11 am
post some sample data along with your query ..then you will get some faster results.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 26, 2010 at 6:10 am
Viewing 15 posts - 1,156 through 1,170 (of 2,462 total)