SQL Server Archives - Page 373 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Find Length of Text Field

June 20, 2007

To measure the length of VARCHAR fields the function LEN(varcharfield) is useful. To measure the length of TEXT fields the function is DATALENGTH(textfield). Len will not work for text field. Example: SELECT DATALENGTH(yourtextfield) AS TEXTFieldSize Reference : Pinal Dave (https://blog.sqlauthority.com)

SQLAuthority.com News – Journey to SQL Authority Milestone of SQL Server

June 19, 2007

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Download

SQLAuthority.com News – Journey to SQL Authority Milestone of SQL Server I am very glad to write this 200th post of this blog. I would like to express my gratitude to all of YOU – my readers for continuously reading this blog. I receive many comments and emails with feedback,…

SQL SERVER – Delay Function – WAITFOR clause – Delay Execution of Commands

June 18, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Blocks the execution of a batch, stored procedure, or transaction until a specified time or time interval is reached, or a specified statement modifies or returns at least one row. This is very useful. Every day when I restore the database to backup server for reports post processing, I use…

SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance

June 17, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Computer Network, DBA, SQL Index, SQL Scripts

This issues was brought to me by our Sr. Network Engineer. While running operating system level de-fragmentation using either windows de-fragmentation or third party tool it always skip all the MDF file and never de-fragment them. He was wondering why this happens all the time. The reason MDF file are…

SQL SERVER – sp_HelpText for sp_HelpText – Puzzle

June 15, 2007

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

It was interesting to me. I was using sp_HelpText to see the text of the stored procedure. Stored Procedure were different so I had copied sp_HelpText on my clipboard and was pasting it in Query Editor of Management Studio. In rush I typed twice sp_HelpText and hit F5. Result was…

SQL SERVER – Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY

June 14, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, DBA, SQL Scripts

I was called many times by Jr. Programmers in team to debug their SQL. I keep log of most of the problems and review them afterwards. This helps me to evaluate my team and identify most important next thing which I can do to improve the performance and productivity of…

SQL SERVER – Explanation SQL SERVER Hash Join

June 14, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins

Hash Join works with large data set. I have seen this join used many times in data warehouses applications as well as data mining algorithms. While its characteristics are similar to merge join it does not required ordered result set to join. Hash join requiresequijoin predicate to join tables. Equijoin…