Viewing 15 posts - 1,651 through 1,665 (of 2,497 total)
There is woefully little documentation about how SQL Full Text indexing works from Microsoft. You need to do a lot of Googling to find posts and documents that explain...
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 22, 2008 at 3:37 am
To me, it looks like you do not have anything that consumes the variables @status, etc.
I have not tested this to ensure the syntax is correct, but you need something...
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 22, 2008 at 3:27 am
There are lots of levels to defragmentation of SQL Server databases. All of them are important.
The first is index defragmentation. There are lots of threads about this, so...
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 21, 2008 at 2:55 am
Rajan has some good ideas, but I don't think the DBA should touch the Windows hotfix logs. These are the 'property' of the Windows infrastructure dudes, and they should...
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 1, 2008 at 4:43 am
Vishal,
You need to grant execute rights on xp_cmdshell to user Test.
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
April 30, 2008 at 3:31 am
Security practitioners think it is good there is separation of duties between the people administering a service and the people granting authority to use the service. Equally, they see...
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
April 29, 2008 at 3:57 am
I completly agree with Steve. My policy is never shrink a data or log file if you expect it to grow within the next 3 months. Even then,...
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
April 29, 2008 at 3:12 am
SSMS is SQL Server Management Studio. I have not noticed any changes in the way is works between 32-bit and 64-bit.
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
April 24, 2008 at 4:28 am
Is the user trying to use the SP_OA procedures a member of sysadmin? In SQL Server 2005 only members of sysadmin can use SP_OA procs. In SQL Server...
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
April 24, 2008 at 3:07 am
You should only give db_owner rights to users that can be trusted and need to have db_owner functionality to do their job.
If you have given db_owner authority to more people...
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
April 24, 2008 at 3:03 am
When SSMS starts, by default it will try to connect to the default instance on the local server. Does this happen for you?
If you want to have a list...
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
April 24, 2008 at 2:56 am
A named pipe connection requires far more traffic to transmit data than does TCP.
If you are running clients on a local LAN, in practice you will find very...
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
April 23, 2008 at 2:55 am
Apart from the datetime formatting capabilities of CONVERT, CAST and CONVERT do identical jobs.
Personally I prefer to use CAST in all situations except where I want to format datetime 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
April 22, 2008 at 3:25 am
Michael is right - you need to update the number of history rows stored for the job.
You also need to go into SQL Agent properties and increase 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
April 18, 2008 at 4:25 am
There is no way to influence security within SQL Server via GPOs (apart from password policy). This is true also in SQL Server 2008.
IMO it would be great 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
April 18, 2008 at 4:22 am
Viewing 15 posts - 1,651 through 1,665 (of 2,497 total)