Alexander Chigrik

Introduction Mathematical UDFs Factorial PercentFrom PercentValue Degree Allocation Combination Introduction I would like to write the series of articles about useful User-Defined Functions grouped by the following categories: Date and Time User-Defined Functions Mathematical User-Defined Functions Metadata User-Defined Functions Security User-Defined Functions String User-Defined Functions System User-Defined Functions Text and Image User-Defined Functions In this […]

Introduction Date and Time UDFs DatePart TimePart GetWorkingDays FirstMonthDay LastMonthDay Introduction I would like to write the series of articles about useful User-Defined Functions grouped by the following categories: Date and Time User-Defined Functions Mathematical User-Defined Functions Metadata User-Defined Functions Security User-Defined Functions String User-Defined Functions System User-Defined Functions Text and Image User-Defined Functions In […]

Introduction String UDFs StrIns StrDel StrSeparate StrCHARINDEX StrREPLACE StrREVERSE Introduction I would like to write the series of articles about useful User-Defined Functions grouped by the following categories: Date and Time User-Defined Functions Mathematical User-Defined Functions Metadata User-Defined Functions Security User-Defined Functions String User-Defined Functions System User-Defined Functions Text and Image User-Defined Functions In this […]

Introduction Trace flags Literature Introduction In this article, I want to tell you, what you should know about trace flags, and how you can use some useful trace flags in SQL Server 2000 for administering and monitoring. Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You […]

Introduction General concepts OLE Automation Stored Procedures sp_OACreate sp_OADestroy sp_OAGetProperty sp_OASetProperty sp_OAMethod sp_OAGetErrorInfo sp_OAStop Example: generate script Literature   Introduction In this article I want to tell you about how you can work with COM objects from within Transact SQL. You can use OLE Automation Stored Procedures (extended stored procedures with sp_OA prefix) to create […]

Here you can find the great amount of useful literature about Microsoft SQL Server (available online). http://www.itknowledge.com/reference/dir.databases.html http://gshulkin.hypermart.net/books/DatabaseBook.html Microsoft SQL Server site http://www.microsoft.com/sql/ Microsoft seminars http://www.microsoft.com/seminar/1033/Index/BrowseTitle.htm Microsoft Personal Support Page for SQL Server http://support.microsoft.com/support/SQL MSDN Developer Center for SQL Server http://msdn.microsoft.com/sqlserver/ Microsoft TechNet http://www.microsoft.com/technet/sql/ Microsoft TerraServer http://terraserver.microsoft.com/default.asp Many interesting articles available online, SQL scripts, FAQ, […]

Introduction UDF examples Database creation date Date the object was created Get date part of datetime value Get time part of datetime value Get the number of working days between two dates Literature Introduction SQL Server 2000 supports User-Defined Functions (UDFs) – one or more Transact-SQL statements that can be used to encapsulate code for […]

Introduction sp_lock2 Literature Introduction As a SQL Server DBA, I often need a reference to information about locks. Microsoft recommends to use sp_lock system stored procedure to report locks information. This very useful procedure returns the information about SQL Server process ID, which lock the data, about locked database ID, about locked object ID, about […]

Introduction Undocumented DBCC commands: DBCC BUFFER DBCC BYTES DBCC DBINFO DBCC DBTABLE DBCC DES DBCC HELP DBCC IND DBCC LOG DBCC PAGE DBCC PROCBUF DBCC PRTIPAGE DBCC PSS DBCC RESOURCE DBCC TAB Literature Introduction In this article I want to tell you about some useful undocumented DBCC commands, and how you can use these commands […]

Introduction Undocumented DBCC commands: DBCC BUFFER DBCC BYTES DBCC DBINFO DBCC DBTABLE DBCC DES DBCC HELP DBCC IND DBCC LOG DBCC PAGE DBCC PROCBUF DBCC PRTIPAGE DBCC PSS DBCC RESOURCE DBCC TAB Literature Introduction In this article I want to tell you about some useful undocumented DBCC commands, and how you can use these commands […]

Introduction Undocumented DBCC commands: DBCC allocdump DBCC bhash DBCC buffer DBCC bytes DBCC dbinfo DBCC dbtable DBCC delete_row DBCC des DBCC extentchain DBCC extentcheck DBCC extentdump DBCC extentzap DBCC findnotfullextents DBCC help DBCC ind DBCC locateindexpgs DBCC lock DBCC log DBCC page DBCC pglinkage DBCC procbuf DBCC prtipage DBCC pss DBCC rebuildextents DBCC resource DBCC […]

Introduction General details Lock Escalation Setting insert row lock Introduction In this article I want to tell you about some general details of SQL Server 6.5 locking, about Lock Escalation, and how you can set insert row lock for a particular table or tables. General details There are three units of data storage in SQL […]