Browse by Tags

SQL Server FILE STREAM error: Share name '<name>' is not valid or is already in use. Try a different share name or delete the existing share

Published 21 May 8 3:3 AM | SSQA.net

In most of the newsgroups and forums I have seen asking how to store/manage the image/video/documents/files within the SQL Server database. SQL Server 2008 version has addressed this issue by enabling the FILE STREAM feature that will integrate the data...

Filed under: sql server, 2008, share, sp_configure, filestream, operating system

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

Published 25 April 8 3:30 AM | SSQA.net

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...

Filed under: sql server, indexes, memory, databases, cache, cpu, monitoring, operating system, huge, dbcc shrinkfile

SQL Server consolidation and virtualization - hot topic in the industry

Published 12 February 8 5:35 AM | SSQA.net

I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall...

Filed under: sql server, microsoft, security, environment, sa, 2000, 2005, virtual server, vmware, operating system, windows server, benefit, costing

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!

Published 25 January 8 3:41 AM | SSQA.net

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation...

Filed under: sql server, performance, indexes, cache, users, tsql, best practice, backups, create, online, monitoring, operating system, busy, creation

Changing ports on production SQL Server - things to watch for 1433

Published 7 December 7 12:29 PM | SSQA.net

What is your criteria on assigning ports to SQL Server? Are you leaving them to default 1433? Is your SQL Server is exposed to Internet or any external sources where there is a chance to produce mass attach or run code injection? Every DBA should give...

Filed under: sql server, databases, microsoft, security, best practice, port, 1433, operating system