Viewing 15 posts - 901 through 915 (of 2,462 total)
Hem.Singh (10/16/2012)
there are multiple solutions in the link you provided. still thinking which one is best.
YOu have to tuse something like this
Where Col1 = @v1 OR Col2 =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2012 at 5:59 am
Sqlsavy (10/16/2012)
Would you be able to give any advise on what will be the impact on Database/Memory/CPU?
its purely depends on what you have encapsulated in that SP.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 16, 2012 at 11:59 pm
grant exec on "stored_proc" to "user"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 16, 2012 at 5:51 am
1. ensure Shared Memory protocol is enabled
2. ensure Named Pipes protocol is enabled
3. ensure TCP/IP is enabled, and s ahead of the Named Pipes in the settings
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 16, 2012 at 5:48 am
Sqlsavy (10/15/2012)
How to plan the resources for such a massive requirement?
there is not any hard and fast rule for hardware upgradation , it depends on variuos factors like
no...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 16, 2012 at 5:45 am
..
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 16, 2012 at 5:44 am
simon4132-806507 (10/16/2012)
I totally agree - I am now at the last resort phase!
We simply cannot have a database which slows down after 3-10 days.
I have looked at the statistics, but...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 16, 2012 at 5:38 am
lema-922661 (10/15/2012)
I realise this could be a windows or network issue but I would like to ensure I have checked all I can Sql side.
How did you check...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 16, 2012 at 5:36 am
Mahesh Bote (10/12/2012)
[font="Verdana"]one delete statement, its causing major blocking.[/font]
Why ? is it deleting the high volumned data here ?
Mahesh Bote (10/12/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 4:17 am
Ratheesh.K.Nair (10/15/2012)
stopped for the other one.
Check if it is related with above mentioend reporting server and wheher it is intentionally stoped ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 3:33 am
go to the services section and check the status " running or stopped" ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 1:47 am
chewychewy (10/15/2012)
So actually wish to know what is this group and is it needed for sql server to function.thanks
See it this can helps you http://msdn.microsoft.com/en-us/library/ms143547(v=sql.100).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 1:39 am
Yuri55 (10/14/2012)
What means "used pages"? Can you please clarify. Thanks
used means the pages which contain data .
refer this link http://msdn.microsoft.com/en-us/library/ms175477(v=sql.90).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 12:05 am
durai nagarajan (10/12/2012)
as per me no body can access using that logins so how security issue?
i second here , the above mentioend accesses are given by sql installation ,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2012 at 12:02 am
achtro (10/14/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 14, 2012 at 11:44 pm
Viewing 15 posts - 901 through 915 (of 2,462 total)