Viewing 15 posts - 76 through 90 (of 120 total)
How about this one:
USE master
GO
CREATE DATABASE <YOURDBNAME>
ON (FILENAME = 'D:\<YOURMDFNAME>.mdf')
FOR ATTACH_FORCE_REBUILD_LOG
November 18, 2014 at 1:04 pm
R-click SSMS and then Run as Administrator. Then connect to SSAS.
November 18, 2014 at 8:15 am
Could they be the free Express Edition?
November 5, 2014 at 6:46 am
Just run the SQL installer (DVD) on each server and select what components to install (DB Services on Server1, SSAS on Server2, SSRS on Server3). Don't forget to service...
November 4, 2014 at 2:45 pm
I use a SSIS package (from Vidas Matelis) and a scheduled SQL Agent job with a CMDEXEC step from a different SQL DB Server w/SSIS installed to backup ALL SSAS...
November 4, 2014 at 1:57 pm
November 4, 2014 at 12:54 pm
Run SSMS as administrator. R-Click the SSMS Icon and click "Run as Administrator" then connect to SSAS and then try it.... If that works now is the time...
October 15, 2014 at 11:16 am
On a server with >16GB, (64 GB in this example) we usually set Max Mem to (64 GB - 4 GB = 60 GB or 61440), and Min Mem to...
October 15, 2014 at 9:01 am
SQL is not releasing the memory because it caches data in memory (among other things). SQL will also do data read ahead and cache data in memory as well....
October 2, 2014 at 8:21 am
Carl Sagan said: "There is no such thing as a dumb question." Sagan obviously never watched a congressional hearing!
This reminds me of an old Network World cartoon that I used...
September 30, 2014 at 7:49 am
How about single threaded vs multi-threaded performance on index rebuilds off-line vs on-line?
September 19, 2014 at 12:34 pm
Funny I am running Win 7 and typing this on my second monitor. I have been running this Win 7 setup w/Dual monitor for two years now so it...
September 5, 2014 at 9:43 am
I just click in the window on Monitor #2 (SSMS) to change the focus to the window I want to type in and then type away.
September 4, 2014 at 2:28 pm
I used to use the SSMS GUI; however, now I am a script kiddy and use my scripts!
August 13, 2014 at 1:37 pm
Viewing 15 posts - 76 through 90 (of 120 total)