Viewing 10 posts - 1 through 10 (of 10 total)
I detached my databases, recording the file locations, uninstalled SQL Server 2012 and installed SQL Server 2014, and then attached the databases. You need to do this carefully so you...
May 28, 2017 at 7:05 am
Thank you for your thoughts. I've done SQL Server updates since updating SQL Server 7 to 2000, and have not seem this. But, after doing the uninstall from a command...
April 10, 2017 at 7:33 pm
Both sides are Standard edition.
Sorry for misunderstanding the question.
April 7, 2017 at 1:07 pm
I am upgrading SQL Server 2012 SP3 to SQL Server 2014 SP2. I want to keep using the default instance.
April 7, 2017 at 12:34 pm
Thank you - you've confirmed that all my web searching was for naught. Time to think about writing some code to parse the ERRORLOG files.
September 27, 2016 at 8:41 am
True, but after Windows, other services, and your application are cooking you may use considerably more then 64GB. My production server, running SS12SP2 Standard with 128GB of memory, an...
June 29, 2015 at 10:52 am
I recall that the 15k drives have a seek time around 2.5ms, and the 10k drives around 4ms, so there is a penalty. I hope your server has a...
June 29, 2015 at 9:09 am
The application will control and measure activity on maybe 20 other computers thru a few services running on both the SQL Server box and the target systems.
Are you...
September 5, 2014 at 7:08 am
I put together this script to copy a production database backup to a development server and restore it. The job will run at night, and keeps the development data parallel...
August 27, 2014 at 1:28 pm
These quirky functions keep us TSQL developers special. The ISNUMERIC tests a field, and CAST converts it if you want.
CASE ISNUMERIC(LEFT(a.[CHBID], 7))
...
July 15, 2014 at 7:19 am
Viewing 10 posts - 1 through 10 (of 10 total)