Viewing 15 posts - 1 through 15 (of 226 total)
I can confirm, this works in reverse as well...(going from tabular to multidimensional mode)
Thanks
November 11, 2019 at 4:35 pm
Just a quick update...Performance Dashboard is still alive and well. Here's a great article on installing the latest version from Pinal Dave: https://blog.sqlauthority.com/2014/09/22/sql-server-ssms-performance-dashboard-installation-and-configuration/
October 8, 2019 at 5:27 pm
The graph only displays a 15 minute window.
October 20, 2015 at 7:07 am
http://www.bidn.com/blogs/kylewalker/ssis/1915/how-to-match-your-subcription-names-with-its-job-id
Some things I've learned researching this topic in sql 2008 r2.
1) ssrs scheduled tasks create a corresponding sqlagent job with a nasty guid name that is...
November 12, 2013 at 1:17 pm
PowerPivot and PowerView for most users. Sql Server Management Studio (SSMS) can also be used to do cube browsing although a power user can't do much else with it....
June 11, 2013 at 8:13 am
Specifically, the user that the sql database server is running as has to have permissions to read the backup file. If possible, browse to the bak file as the...
November 19, 2012 at 8:04 pm
By default, SQL server grants all rights that are referenced within a stored procedure to who ever you give execute rights to. Based on my testing, you cannot override...
October 11, 2012 at 12:20 pm
Method 1. Sharing user ids and passwords among multiple people is a security worst practice.
April 25, 2012 at 5:16 pm
sibir1us (7/28/2009)
Change the...
June 17, 2010 at 6:26 am
SQL server maybe on a different windows domain than that one you are logged into. Try logging directly onto the server with your id. You may need help...
June 9, 2010 at 7:01 pm
You have to enable logging of that message. You can query sys.messages to see all the available messages. The english version of the message you are looking for...
June 2, 2010 at 7:01 pm
Not likely. Why would you want to?
You can create the view based on an existing table then drop the table and the view will remain. It won't work,...
June 2, 2010 at 5:59 pm
What sybase driver is the sql 2000 database using?
I have ran into issues connecting to 32 bit Oracle from 64 bit sql with ssis. The solutions deal...
June 2, 2010 at 5:52 pm
This error, vague as it is, can also indicate a permissions problem. Compare the permissions between the original file and the copy you made.
May 29, 2010 at 12:44 pm
Does dbo.EmployeeList table have indexes? If so, you should disable or drop the index before the insert and rebuild it after the insert has completed.
May 13, 2010 at 7:04 am
Viewing 15 posts - 1 through 15 (of 226 total)