Viewing 15 posts - 1,606 through 1,620 (of 2,497 total)
Data protection forms part of Information Lifecycle Management (ILM). ILM covers not just who should be able to access the information, but also how long the information should survive,...
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
September 10, 2008 at 4:05 am
It might be the 'right' answer but it is a bit simplistic.
Looking at the SELECT... If a column is not in the SELECT list or a WHERE predicate 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
September 9, 2008 at 7:07 am
If your queries need to sort and group data they will use space in tempdb. Basically you have 3 choices:
1) Rewrite your queries to avoid the sorting and grouping....
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
September 9, 2008 at 6:50 am
Your problem is because the syntax in the KB article is wrong.
During the SQL Server 2008 development process, the syntax for setup.exe was changed and all keywords must now start...
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
September 9, 2008 at 2:51 am
Non-compete clauses are a way for your employer to say you are worth more to the business than the value of your salary. This means we should be looking...
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
September 9, 2008 at 2:36 am
It is possible to get a good backup of SQL Server databases using block level copy, providing you do all the right things. If you miss something out, you...
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
September 4, 2008 at 6:14 am
Thanks for the clarification 🙂
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
September 1, 2008 at 7:08 am
My advise is to use whatever your organisation has the most skills in.
The first preference is to leave it in DB2, as moving it means you are paying...
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
September 1, 2008 at 3:28 am
I don't think that the question gives enough detail to say that limiting SQL Server memory to 512 MB is the right answer.
If you are trying to tune...
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
September 1, 2008 at 3:17 am
Heh. No, I am asking: what is the security difference between xp_CmdShell and a CmdExec Job step?
If xp_cmdshell or CmdExec are run by an account with sysadmin authority, they...
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
August 26, 2008 at 5:09 am
Cath has a good idea... Get the Windows admin folk to rename your login so it uses only upper case characters.
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
August 26, 2008 at 3:58 am
There are 2 parts in using SQL Server 2008, both of which will take some time getting used to:
* Using the database engine, AS, RS, etc
* Using the client tools
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
August 19, 2008 at 4:58 am
"Customer Service" ..although there are some companies that DO know how to do 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
August 19, 2008 at 4:52 am
Copy Only backups should not be seen as a 'second class' backup. For large-scale OLTP shops they have an important role to play in maintaining availability. They are...
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
August 19, 2008 at 4:48 am
Leaving the services as not started is not relevant. The SQL Server install starts and stops the SQL services a number of times. The SP2 install also starts...
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
August 19, 2008 at 2:43 am
Viewing 15 posts - 1,606 through 1,620 (of 2,497 total)