Viewing 15 posts - 1 through 15 (of 1,654 total)
Another option would be using an database audit specification using the SCHEMA_OBJECT_ACCESS_GROUP
[font="Verdana"]Markus Bohse[/font]
June 5, 2019 at 9:58 am
Sorry missed that in my first reply.
But after some more testing I think it must be related to your SSMS version. I cannot reproduce the issue with SSMS 2014. Also...
[font="Verdana"]Markus Bohse[/font]
November 27, 2014 at 7:38 am
Why would you think this is a bug?
If anything, the restore sequences shown in SSMS 2008 is wrong, but then again connecting with SSMS 2008 to a SQL 2014...
[font="Verdana"]Markus Bohse[/font]
November 27, 2014 at 3:42 am
Philip,
The rendering process in Report Server is the operations the report do to show the report content (paint report items, paint data, pagination,…) on the renderer selected (in this case...
[font="Verdana"]Markus Bohse[/font]
October 29, 2013 at 2:19 am
Obviously, adding more memory results in a different, less efficient plan.
Could you try what happens if you simulate even more memory, like let's say 16Gb.
You can do this by using...
[font="Verdana"]Markus Bohse[/font]
October 25, 2013 at 6:46 am
To answer your question in the subject header, it depends on your collation. Each collation contains some special varchar characters, but they vary.
What is the collation of your column?
[font="Verdana"]Markus Bohse[/font]
October 15, 2013 at 4:58 am
You can only configure the synch settings for the AG, not per database.
Either synch both databases or create two AG's one having only one secondary and another AG having...
[font="Verdana"]Markus Bohse[/font]
October 4, 2013 at 3:28 am
Are you using SCCM?
Could be the same issue as here http://social.msdn.microsoft.com/Forums/officeapps/en-US/4dee5138-4726-4c5b-a7e5-a79ab3a6286c/sql-passive-node-could-not-open-error-log-file ?
[font="Verdana"]Markus Bohse[/font]
October 2, 2013 at 7:11 am
Just like the DB Engine, SSAS contains several DMV's you can query for this kind of data.
As a starter open a DMX Query window and run:
SELECT * FROM $System.DBSCHEMA_CATALOGS
SELECT *...
[font="Verdana"]Markus Bohse[/font]
October 2, 2013 at 5:57 am
kishoremcp (10/2/2013)
I have an sql query in Excel Existing connections through which i am able to pull the data. I am giving the required date range manually in sql...
[font="Verdana"]Markus Bohse[/font]
October 2, 2013 at 3:26 am
While keeping one witness for one production database instance makes sense to me, why on earth would I want one witness for multiple DB instances?
One reason could be licensing fees,...
[font="Verdana"]Markus Bohse[/font]
October 1, 2013 at 7:35 am
We have a SP which is giving performance issues. As an example it has been executed 4 times and has an total elapsed time of 68961914. It is the costliest...
[font="Verdana"]Markus Bohse[/font]
October 1, 2013 at 6:03 am
Or did I misunderstand you? You think that because it is pre-release it might change until the official release of SQL Server 2014? Then of course forget my remark above....
[font="Verdana"]Markus Bohse[/font]
October 1, 2013 at 1:35 am
You can't do it directly from SSMS, but you can download the SQL 2005 report definitions from here:
http://blogs.msdn.com/b/managingsql/archive/2006/08/30/ssms-reports-3.aspx
You can then upload these to your own SSRS instance (a few changes...
[font="Verdana"]Markus Bohse[/font]
October 1, 2013 at 1:21 am
Not sure about this question.
I think there is no correct answer given, because even the link provided for SQL 2014 says "Topic Status: Some information in this topic is...
[font="Verdana"]Markus Bohse[/font]
October 1, 2013 at 1:06 am
Viewing 15 posts - 1 through 15 (of 1,654 total)