Viewing 15 posts - 1,906 through 1,920 (of 8,760 total)
My suggestion is to leave it as is until the next scheduled restart of the server / sql server services if possible, the shrink process fragments the files and my...
September 25, 2017 at 12:54 am
I am getting an odd error when trying to shrink tempdb a little bit
DBCC...
September 25, 2017 at 12:34 am
September 24, 2017 at 4:38 am
In SSMS, press CTRL+SHIFT+F to have the results written to a file.
😎
September 21, 2017 at 2:20 am
September 20, 2017 at 9:22 am
September 20, 2017 at 7:46 am
Arsh - Wednesday, September 20, 2017 6:52 AMDear Experts,
Please advise how one can configure the SQL server memory buffers. Thank you.
By setting...
September 20, 2017 at 7:00 am
Let's say I have a table with a couple of billion rows of data....
September 20, 2017 at 6:52 am
i am trying to set Max server memory on the SQL server memory settings, here...
September 20, 2017 at 6:44 am
The simplest way is to import the file line by line into a table and then parse it, the parsing can easily be done in a view.
😎
September 20, 2017 at 5:01 am
Why would you want to do that? That is only duplicating information that is already availale.
😎
September 19, 2017 at 12:03 am
Could any one show me the lead on how to add service accounts to...
September 18, 2017 at 11:56 pm
Here is something to get you started
😎
USE TEEST;
GO
SET NOCOUNT ON;
DECLARE @TXML XML = '<ROOT>
<Parameters xmlns="http://www.any.xsd">
<Parameter Name="Addendum2" StringValue="True"...
September 18, 2017 at 10:25 pm
GilaMonster - Monday, September 18, 2017 9:04 AMI shouldn't post when I'm exhausted. Saw the @ and brain interpreted as a parameter.
I...
September 18, 2017 at 11:15 am
Viewing 15 posts - 1,906 through 1,920 (of 8,760 total)