Viewing 15 posts - 586 through 600 (of 2,462 total)
HOG (1/2/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 4:29 am
Rama Chandra Gowtham. Peddada (1/2/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 4:21 am
brangaraja (1/2/2013)
hi can you please any one tell me what is exactly orphaned users and when will use this one and how to troubleshoot?
For details see this link http://www.mssqltips.com/sqlservertip/1590/understanding-and-dealing-with-orphaned-users-in-a-sql-server-database/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 4:19 am
4 years old thread
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 4:06 am
Mac1986 (1/2/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 2:54 am
venkatesh.b 88975 (1/3/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 2:30 am
kyleheath33 (1/2/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 2:22 am
i tried it with PIVOT but its more resource intensive (as compared to other provided solution ) . can we avoid UNION here
SELECT CompanyName, 'Low' as Type,
[Sunday], [Monday],...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2013 at 1:02 am
see this
--Bpool stats
select (bpool_committed * 8192)/ (1024*1024) as bpool_committed_mb
, (cast(bpool_commit_target as bigint) * 8192) / (1024*1024) as bpool_target_mb,
(bpool_visible * 8192) / (1024*1024) as bpool_visible_mb
from sys.dm_os_sys_info
go
-- Get me physical...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 11:43 pm
tbmabry (1/2/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 11:39 pm
jitendra.te (1/2/2013)
Scenerio is, I have a database server which have a harddisk size is 70 GB c drives is occupied...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 10:28 pm
Mark-101232 (1/2/2013)
To be honest, I'm not a big fan of text books, most of my learning has been on-the-job and by getting involved in sites such as this one.
+1...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 4:54 am
try with another paramter [ @body_format= ] = 'HTML '
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 1:52 am
lathish2kumar (1/1/2013)
please give answer to this question asap
it seems that you went straightaway to apply this . to gain some space. and if thats the case then you might...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 1:49 am
If you go with the basic structure of HASH join then you will find that temp table get created (either in memory or tempdb) which might the cause of tempdb's...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 12:06 am
Viewing 15 posts - 586 through 600 (of 2,462 total)