Tags » Database Administrator

Splitting comma separated column’s values in rows

I have seen many Developer/DBA uses user defined function or stored procedure to split a comma separated ( or any delimiter to separate values like |,;-.& or any character/special character) column into rows using various coding logic like while/for loop or using cursor etc. 252 more words

Database Administrator

Tips To Fix MS SQL Server Master Database Corruption

There are two types of databases that are supported by SQL Server: System database and User database. The system databases are used by the SQL Server, SQL Server services and functions while the user database are used to store data of user’s choice, the data for which SQL Server is being set up. 848 more words

Database Administrator

Select rows with TIES option

Its very common when a Developer/DBA wanted to see sample of few records, commonly they use SELECT TOP N records from a table being ordered by a column,  the query look like as… 258 more words

Database Administrator

Database ‘MSDB’ marked as SUSPECT by recovery – Error 926.

It’s very rare but may be happen with us ,even we are trying to connect SQL Instance using sysadmin login and SSMS through error saying   209 more words

Database Administrator

Why you should hire a consultant for database services.

If you already have a database administrator you might be thinking that you don’t need a consultant. After all isn’t your DBA capable of doing everything… 205 more words

SQL

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people.

36 more words
Database Administrator

A SQL Server DBA - Day to Day Checklist

As a SQL Server DBA, I hope we have to maintain following day to day activities.

  1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.

  2. 193 more words
Database Administrator