Viewing 15 posts - 16 through 30 (of 48 total)
July 10, 2017 at 6:42 am
Steve Jones - SSC Editor - Monday, July 3, 2017 8:48 AMStrange. You are applying SP1, not SP2? http://www.sqlservercentral.com/articles/SQL+Server+2014/101274/
Was testing...
July 3, 2017 at 10:44 am
July 3, 2017 at 8:40 am
Restoring from backup is the only option for corruption on PFS tables. As we don't have a clean backup, we won't be able to fix the corruption
July 3, 2017 at 8:04 am
I tried to save it to table & alert got triggered again. As I mentioned earlier, D drive is a dedicated drive for TEMPDB and in SSMS available free space...
June 6, 2017 at 11:56 pm
June 6, 2017 at 7:31 am
Hi Thom
Thanks for replying
I have executed the code & it returned 57000MB.For some reason the query execution is entering into IF condition
Hi Dim,
Yes, There is...
June 6, 2017 at 7:05 am
Thanks a lot Sue and I marked your comments as answer 🙂
May 24, 2017 at 6:03 pm
Expand Databases; right click thedatabase and select Properties .Go to Files & change theAutogrowth/Maxsize settings to Limited
You will be able to script this Action to new query window as well.
May 24, 2017 at 3:36 pm
Below code works fine on SQL Server 2012,but for 2008R2 it is not working as "sqlserver.
March 7, 2017 at 8:25 am
Thanks..We are using SQL Server 2008 R2.Is there any script to create extended events to accomplish this ?
March 6, 2017 at 7:11 am
Try this query :
select DB_NAME(mf.database_id) database_name
, mf.name logical_name
, CONVERT (DECIMAL (20,2) , (CONVERT(DECIMAL, size)/128)) [file_size_MB]
, CASE mf.is_percent_growth
WHEN 1 THEN 'Yes'
ELSE 'No'
END AS [is_percent_growth]
, CASE mf.is_percent_growth
WHEN 1 THEN CONVERT(VARCHAR, mf.growth) +...
January 9, 2017 at 1:58 pm
Thanks 🙂
The long hex-named subkeys in the registry path HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\. cotains infomation about patch installed date.
Now the challenge is to search through the Hexadecimal folders ,for InstallProperties...
December 27, 2016 at 9:57 pm
Here you go and Good luck for your exam:-)
https://www.microsoft.com/en-in/learning/mcsa-sql-certification.aspx
December 22, 2016 at 9:00 am
Viewing 15 posts - 16 through 30 (of 48 total)