Viewing 15 posts - 46 through 60 (of 1,654 total)
With SQL 2008 R2 and higher you don't really need to enable this traceflag.
You can get the same (and more) information form the System_Health extended events session which logs...
August 27, 2013 at 7:42 am
Using locking hints should only be done as a last resort.
Optimizing the query and indexes should come first. Also using READ_COMMITTED_SNAPSHOT isolation level can help.
This article may help you on...
August 22, 2013 at 6:34 am
With the little information you gave I can't really tell what's the problem, but this link might help you.
http://stackoverflow.com/questions/515273/reporting-services-total-and-percentages-for-each-row
August 16, 2013 at 7:32 am
You could open a query window in SQLCMD mode and then use the following syntax
:CONNECT Server\InstanceName
USE DATABASE
GO
EXEC STORED PROC...
July 16, 2013 at 6:23 am
Sorry If I wasn't clear enough but what I meant is this:
c4ntaloop (7/8/2013)
July 9, 2013 at 4:00 am
The licensing question depends very much on your current license, especially running on VmWare.
About your second question, since you're using Standard Edition you need to restart the server in order...
July 8, 2013 at 3:22 am
mJai (7/7/2013)
My current SQL configuration is SQL 2008 standard edition (Vmware virtualized 2 node failover cluster) on windows 2008 R2 .
Whenever I run my SQL backup the CPU shoots...
July 8, 2013 at 3:12 am
Correction:
User can only see tables where they have any permission on, doesn't have to be "Select".
July 8, 2013 at 1:58 am
I don't think you can disable the expanding option, but users can only see those tables, which they have select permission on.
So unless you give select permission to either...
July 8, 2013 at 1:53 am
Yes, you still have to give DB access to the logins.
User-defined server roles simply offer you a more granular option to defeine server permissions,but you still have to set...
July 8, 2013 at 1:46 am
What would be the reason of configuring server memory via Resource Governor instead of via SQL properties page? What is the benefit over each other?
Configuring the max\min server memory is...
July 8, 2013 at 1:37 am
Check the maintenance plan history or the Maintenance plan logfile if you have one configured.
Jobhistory won't give you the error details.
June 28, 2013 at 2:58 am
In the SSMS menu look under "Tools>Options" for Fonts and Colors.
There are no color themes available, but you can configure any part you like.
June 20, 2013 at 6:47 am
Viewing 15 posts - 46 through 60 (of 1,654 total)