Tags » SQL Server 2008 R2

Sql Server : Convert from INTEGER (decimal) to HEX and HEX to INTEGER

Quick one today:

Sometimes there is a need to convert data from integer to HEX and from HEX to integer. There are ways to accomplish this and today, this post covers one such ways. 27 more words

DBA

Sql Server : ORDER BY clause beauty and complexity (Tidbit 3)

A few days ago, there was an interesting requirement. We have a query that needs to bring data from a set of tables in a particular order that did not seem straight forward. 565 more words

DBA

Database Servers on Virtual Machines with vCPU

More and more database servers are being migrated into virtual machines. The momentum towards virtual machines is strong, with good reasons, and as a DBA we need to come up with ways to make sure that our database servers are correctly configured to fully utilize the capabilities of virtual environments. 503 more words

DBA

SCCM 2012 - Hierarchy with CAS - Installation Central Administration Site [Part 1]

Here is the first part of the SCCM 2012 R2 series. On part one I will show you guys how to configure a Central Administration Site for all your administration and reporting needs with your hierarchy. 712 more words

Microsoft

Sql Server OUTPUT Clause Examples with UPDATE INSERT DELETE MERGE

OUTPUT is an interesting clause added starting Sql Server 2005.

DELETE

Recently, in my previous post, we saw an example with some insight into the usage of OUTPUT clause with DELETE statement. 276 more words

DBA

How to restart an Interrupted Database Restore in SQL Server?

Steps to restart an Interrupted Database Restore in SQL Server

There may scenario when you are restoring VLDB database backup and the restore database command interrupted due network failure, power failure, SQL Server Service restart or cluster failover. 94 more words

SQL Server

REMOVE FILE and REMOVE FILEGROUP error message

Quick one today:

A few months ago, this interesting error occurred. As needed new FileGroups were being created and destroyed and that when I ran into this interesting error. 441 more words

DBA