Viewing 15 posts - 1,636 through 1,650 (of 2,497 total)
If you are just looking at elapsed time, then doing just a DELETE will be faster. Also, if the DELETE will almost always find data to delete then this...
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
July 4, 2008 at 3:03 am
In SSMS, select the Tools menu, then Options. Expand Query Results then set the values to what you need. There will always be a maximum size that can...
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
June 27, 2008 at 2:44 am
You would need to do the compress / decompress in a CLR stored procedure or in a CLR function. CLR would need to be used because you would be...
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
June 27, 2008 at 2:25 am
Just a guess - the KB article refers to a Windows configuration setting that at best has an indirect on the hardware configuration.
You may have to disable speed-step in 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
June 23, 2008 at 4:23 am
I had a similar issue using SHRINKFILE EMPTYFILE to move the data and then being unable to release the empty space.
It seems that in this situation the file...
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
June 23, 2008 at 4:12 am
I am sure you will be able to find good companies in Dakha. If not, the main IT service providers (Infosys, Wipro, etc) in India generally provide an excellent...
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
June 23, 2008 at 2:58 am
Thanks for the heads-up about syntax errors. I am working on a new version of FineBuild and will check these 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
June 20, 2008 at 2:41 am
A former colleague told of when he left his previous company...
He had worked a lot of extra hours and accumulated a lot of time off in lieu of payment. ...
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
June 13, 2008 at 6:38 am
It is a contractural issue.
Your employment contract says you spend x days per year in the office working for the company, and y days per year away from...
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
June 13, 2008 at 4:41 am
Carl has given good advice.
Looking at just Diskeeper itself, it is safe to run it while SQL Server is running, but not necessarily wise.
As a simplified example, SQL decides it...
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
June 4, 2008 at 3:46 am
Another 'interesting' to be aware of with the Vista SP1 install is disk space requirements.
The Readme says you need 6 GB free space on the system volume if...
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
May 30, 2008 at 2:50 am
The process was originally coded in the distant days of SQL Server 2000 so for us it is done in the application layer. It could be done as 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
May 28, 2008 at 9:42 am
We use McAfee VirusScan Enterprise 8.5
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
May 28, 2008 at 7:17 am
The reality is that if your client has not already started on a SQL Server 2005 migration project, it will not go live until after SQL Server 2008 is available....
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
May 28, 2008 at 4:18 am
We store files in our database as blobs. Our Dev people developed a .Net app that calls the virus scanner API to process the file before it is stored....
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
May 28, 2008 at 4:09 am
Viewing 15 posts - 1,636 through 1,650 (of 2,497 total)