The Problem I was working on an ERP project for an electrical company. As a DBA my main task was to maintain database security and data consistency. A database developer was appointed on the client side to maintain the database. By mistake the developer used an update query in an important monetary transaction...
SQL BUILT IN FUNCTIONS PART – 2 In my last SQL BUILT IN FUNCTION ARTICLE ASCII & CHAR has been described, today the REPLACE system function provides the functionality of replacing all occurrences of a given value with another value. This system function is valuable for masking processes. If the value...
SQL BUILT IN FUNCTIONS PART –1 The ASCII and CHAR system functions provide the conversion functionality between character values and ASCII code values. These system functions are valuable when iterating through characters, mathematically determining characters and randomly deriving characters. The American...
Posted to
Rahul Kumar Ghosh's Blog
by
rahul kumar ghosh
on
07-19-2011
Filed under:
Filed under: ASCII, master..spt_values, CHAR, DATA TYPE, DATATYPE, TEMPORARY TABLE, SUBSTRING, WHERE, TABLE, SELECT, BRH
How quickly you can get information on individual user activity and pin-point the processes that are causing blocking and performance issues? As a DBA how many times you use Activity Monitor in your SQL Server platform? Monitoring the SQL Server paltform activity is one of the key responsibility for...
Posted to
SQLMaster
by
Satya Jayanty
on
03-07-2011
Filed under:
Filed under: best practices, sql server, #SQL Server, tsql, #TSQL, 2008, 2005, 2000, security, dba practices, select, permissions, activity monitor