Tags » SQL Server 2008 R2

Sql Server: How to remove existing data files

Quick one today:

In the last few weeks, there have been multiple incidents where there was a need to remove/add/modify data files on a Sql Server databaes. 170 more words

DBA

SQL Server - How To Find SQL Virtual Name From Host Name in SQL Failover Clustering Using PowerShell

Often times it is required to find out the SQL name from the host names in a clustered environment so you can use it to connect through SSMS. 333 more words

SQL Server 2012

Sql Server: Some differences between Temp tables and Table variables

Quick one today:

Temporary tables and table variables are a great addition in Sql Server. Pretty much every database code take advantage of this feature, for right reasons. 185 more words

DBA

(PR) OCZ Storage Solutions Announces Beta Program for Next ZD-XL SQL Release

OCZ Storage Solutions – a Toshiba Group Company and leading provider of high-performance solid-state drives (SSDs) for computing devices and systems, today announced that it has initiated a beta test program for the next release of ZD-XL SQL Accelerator and invites enterprise SSD…

http://rigsandgeeks.com/pr-ocz-storage-solutions-announces-beta-program-for-next-zd-xl-sql-release-2/

OPENQUERY() - Query timeout expired, really?

Did you receive this error while using an OPENQUERY() statement?:

OLE DB provider “SQLNCLI10″ for linked server “” returned message “Query timeout expired”.
Msg 7399, Level 16, State 1, Line 1…

83 more words
SQL Server 2008 R2

Sql Server: OPENXML (sample T-SQL querying techniques using OPENXML)

Sql Server, starting from 2005, has extensive methods to parse, slice & dice XML files. Before that, for DBA’s, XML is not a favorite topic — especially from T-SQL point of view. 450 more words

DBA

Antivirus Exclusion Policy for SQL Server

Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.

Anti-virus are very useful programs from security, audit & venerability detection & removal point of view. 360 more words

SQL Server