Viewing 15 posts - 1,816 through 1,830 (of 2,497 total)
All your jobs are stored in msdb, so a backup of msdb will contain all your jobs.
As other people have said, it is a good idea to also have scripts...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 25, 2008 at 2:52 am
Dio you have 8.3 filename creation disabled? SQL Server 2005 install requires that 8.3 filename creation is switched on, as the path names used to create the service entries...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 24, 2008 at 5:41 am
SQL Server components are split across 2 install folders. The Server folder on the DVD (CD1 on CD media) contains only the server components. The Tools folder on...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 24, 2008 at 4:02 am
Like someone else just said, SQL Server 2008 won't support DTS.
SQL Server 2008 will support the same DTS Designer component as SQL Server 2005. There are some blog postings...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 22, 2008 at 2:43 am
Windows compressed folders do not compress files over 2GB. What may be happening is that as you write the log backup, Windows is compressing the data. When the...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 18, 2008 at 2:41 am
I think SSAS needs enough memory to hold all the dimemsions of all the cubes. Therefore the more cubes you have, the more memory you need.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 18, 2008 at 2:29 am
Steve,
Sounds reasonable. Hopefully you can update the what is displayed on old postings to show the new name the person uses.
However, I think you should stay as 'Steve...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 17, 2008 at 3:55 am
The critical time for synchronising backups is not the start time, not the end time, but the time in the middle when the actual full backup ends and the built-in...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 17, 2008 at 3:50 am
As Steve said, some blocking is normal.
After you install SQL 2000 SP4, you may well see blocking happening when nothing was reported in SP3. The blocking is not anything...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 16, 2008 at 3:07 am
We make extensive use of free text searching where I work. John is right, you need to construct a dynamic SQL query using the data supplied by the user....
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 16, 2008 at 2:58 am
As people have said, SSIS is the favoured tool for developing DTS-like functionality on SQL 2005 and onwards.
However, you can still use all the SQL 2000 functionality in SQL 2005,...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 16, 2008 at 2:51 am
You simply cannot synchronise backups in this way. All it needs is a few milliseconds difference in the backup completion time and you have committed data on machine A...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 16, 2008 at 2:42 am
If your main server is 64-bit and your DR server is 32-bit, then you should test that all your application code works in both environments.
Also test that the...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 16, 2008 at 2:33 am
I gave the limit of 1 MB for the type of reasons given by Dave and Grant.
On small tables the optimiser will often find it is cheaper to...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 11, 2008 at 2:33 am
Lots of posts in thi sforum, but no-one has asked Arun why he wants to know if a #temp table exists already.
There are very few situations where this information is...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 10, 2008 at 5:03 am
Viewing 15 posts - 1,816 through 1,830 (of 2,497 total)