Viewing 15 posts - 541 through 555 (of 5,394 total)
SSMS reads the information from a number of sources and it's difficult to tell which one it uses when the path is not set.
This is what you get if you...
May 4, 2015 at 7:01 am
20% compared to what? Previous day? Previous month?
You have to record the database size in a table at regular intervals and then run a job to check the increment over...
April 30, 2015 at 2:45 pm
Lynn Pettis (4/30/2015)
ScottPletcher (4/30/2015)
ScottPletcher (4/30/2015)
Don't name the constraint, as constraint names have to be unique.ALTER TABLE dbo.test
ADD PRIMARY KEY CLUSTERED
( ReportRunTime, VisitID, SourceID, BaseID, OccurrenceSeqID, [DateTime], SeqID, QueryID, Response );
The...
April 30, 2015 at 2:43 pm
You can download SQL Server 2014 Express from here: https://www.microsoft.com/en-us/download/details.aspx?id=42299
April 30, 2015 at 2:34 pm
Two seconds in Google would have given you the answer.
However...
To add a user to a the local administrators group:
net localgroup Administrators AD\abc /add
To create a windows login and grant sysadmin...
April 30, 2015 at 2:31 pm
This means that master is not being backed up. Set the recovery model to simple and shrink the log file to a reasonable size (reasonable = data file size, which...
April 30, 2015 at 1:38 am
Grant Fritchey (4/29/2015)
April 29, 2015 at 8:20 am
Use the generate scripts task. Right click the database, tasks, generate scripts. Select all objects that apply, then generate the script file.
April 29, 2015 at 5:04 am
Recovery for master should be simple.
Don't move user objects if you're not sure nobody's using them.
April 29, 2015 at 3:02 am
The output appears to be in a single line in the SSMS results grid, but newline chars are actually preserved. If you copy/paste the object definition from the grid to...
April 29, 2015 at 2:47 am
The certification you're looking for is MCSE (Microsoft Certified Solutions Expert) Data Platform. You can find more information here: https://www.microsoft.com/learning/en-us/mcse-sql-data-platform.aspx
April 29, 2015 at 2:45 am
Copy / paste or Import/Export wizard are two possibilities.
April 27, 2015 at 3:39 am
April 27, 2015 at 2:31 am
You can empty a file and the delete it by using DBCC SHRINKFILE:
DBCC SHRINKFILE (N'MyDatafile' , EMPTYFILE)
April 27, 2015 at 1:46 am
Viewing 15 posts - 541 through 555 (of 5,394 total)