Viewing 15 posts - 211 through 225 (of 238 total)
Appreciate your help with this.
Erland,
I have never used that before and theres not much to explain on the web how to use it properly..
declare @thisserver nvarchar(50)
declare @databasename nvarchar(100)
declare @jobname nvarchar(100)
declare...
August 8, 2013 at 2:46 am
amitsingh308 (8/7/2013)
Because it effects the execution of other applications
Reduce the max memory allowed for SQL.
Personally.. If other applications require large amounts of memory, I would put them on seperate servers.
August 7, 2013 at 10:08 am
Kingston, I took your advise. So now I am trying to create a PROC which will create a SQL job to 1) create folder structure 2) delete old backups...
August 7, 2013 at 8:10 am
Kingston Dhasian (8/7/2013)
When you create a new database, the new database will automatically inherit this stored procedure from the model database
Check...
August 7, 2013 at 2:45 am
Install SSRS on each node, Add the other nodes into ssrs through the scale out deployment tab on each server and initialize it. Without doing it i cant remember the...
August 6, 2013 at 7:11 am
Koen Verbeeck (8/6/2013)
Does this work?
DECLARE @Databasename NVARCHAR(50);
DECLARE @Subdir NVARCHAR(150);
SELECT @Databasename = (SELECT DB_NAME());
--SELECT @Databasename;
SELECT @Subdir = N'C:\Test\' + @Databasename;
--SELECT @Subdir;
EXECUTE master.dbo.xp_create_subdir @Subdir;
It does indeed! thank you! Sanity saved!
August 6, 2013 at 3:34 am
personally i would do it the way you have said, then you have a roll back position if required.
August 5, 2013 at 9:28 am
My post was wrote with the understanding you would take a backup before shrinking the log file 😉
August 5, 2013 at 8:24 am
monitor your log file over the next month and do not shrink it. You should always set your log file to be the size it needs to be at its...
August 5, 2013 at 8:23 am
I would look at the reason behind why you are wanting to restore all system databases before just thinking "to keep it the same". If its to copy all user...
July 30, 2013 at 6:11 am
Lowell - Completely agree that the index fill factor wont be the only thing to address, I am just looking at all possibilities at the moment and wasn't aware how...
July 29, 2013 at 7:53 am
What information are you after? And do you mean from the SQL instance or the server registry?
July 26, 2013 at 3:10 am
The restore only version of lightspeed is free so download that and away you go. Otherwise you are stuck 🙂
July 25, 2013 at 8:12 am
The restore only version of lightspeed is free so just download that and away you go. Otherwise.. your stuck.
July 25, 2013 at 8:11 am
as you would imagine.. changing the port in IPALL Will make the change apply to them all 🙂 So just change it here.
Leave dynamic port blank.
July 25, 2013 at 4:16 am
Viewing 15 posts - 211 through 225 (of 238 total)