What is “SET STATISTICS TIME”?
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
375 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
375 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
452 reads
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File...
2016-12-12
2,651 reads
Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB...
2016-11-30
868 reads
After lots of crisis in last month, We are back again.
Sorry for inconvenience caused !
Reference : Rohit Garg (http://mssqlfun.com/)
You can find...
2016-11-15
517 reads
2016-10-18
491 reads
ERROR :
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS...
2016-05-17
964 reads
Data Compression
Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of...
2015-10-05
1,132 reads
ERROR :
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS...
2015-07-24
1,356 reads
Thanks every one for loving me, joining me & providing you extreme support.
I am very happy to share that we reach...
2015-06-11
589 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers