Viewing 15 posts - 1,951 through 1,965 (of 7,168 total)
midnight251 (2/14/2013)
Great info thanks. What would a sensible size be, 50 gig?
It's mostly a guess. The only way to know for sure would be to capture the output of...
February 14, 2013 at 10:11 am
balasach82 (2/14/2013)
OPC, am reading at the link
The article I linked to answers #2 and #3 quite well.
To move a heap to a new filegroup create a new heap with a...
February 14, 2013 at 8:29 am
I wouldn't worry about 752 but I would definitely change from 10% to something in MB. I use 128MB by default. Then shrink your file once to a sensible size...
February 14, 2013 at 8:08 am
Good deal. Thanks for posting back that it was sorted.
February 14, 2013 at 8:05 am
You're welcome. Thanks for the feedback.
February 14, 2013 at 8:02 am
durai nagarajan (2/14/2013)
working method like connection in sql authentication any way we have to give user and pwd credentials, windows authentication hope wont work on adminstrator access.
A connection method of...
February 14, 2013 at 7:43 am
You're welcome. Thanks for the feedback.
February 14, 2013 at 7:36 am
That's not a PowerShell thing per se. What that is saying is:
echo textToPipeIn | executableName executableOptions
Which works fine in cmd Shell as well. How to pipe in more than one...
February 14, 2013 at 7:35 am
zi (2/14/2013)
How to use it please
It's part of the RAISERROR function, you say WITH LOG and SQL Server will additionally write the error to the SQL Error...
February 14, 2013 at 7:09 am
DBArrr! (2/14/2013)
You could use RAISERROR to write to the eventlog instead
I would not rely on RAISERROR writing to the event log. SQL Server no longer does that in SQL Server...
February 14, 2013 at 7:07 am
That makes perfect sense. You can now use DBCC SHRINKFILE (once) to reclaim log space. The command can be blocked from shrinking the file for various reasons so post back...
February 14, 2013 at 7:03 am
What do you mean by "working method"?
SSMS will function as usual, but it will be "running as" the Administrator so will be setup using the Administrator's preferences, e.g. their Registered...
February 14, 2013 at 6:53 am
Here is good info on how to "rebalance" the data in your data files, and why you should do it that way:
February 14, 2013 at 6:48 am
Google must be on the fritz again...
When it comes to defining I/O response times related to SQL Server, there are three primary sources of data that you should watch regularly....
February 13, 2013 at 4:03 pm
Viewing 15 posts - 1,951 through 1,965 (of 7,168 total)