SQL Cursor « SQL Server Journey with SQL Authority

Archive for the ‘SQL Cursor’ Category

SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor

Posted in Pinal Dave, SQL, SQL Authority, SQL Cursor, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on January 30, 2009 | 21 Comments »

I just wrote down following script very quickly for one of the project which I am working on. The requirement of the project was that every index existed in database should be rebuilt with fillfactor of 80. One common question I receive why fillfactor 80, answer is I just think having it 80 will do [...]

Read Full Post »

SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database

Posted in Pinal Dave, SQL, SQL Authority, SQL Cursor, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, T SQL, Technology on November 20, 2008 | 12 Comments »

SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method. USE AdventureWorks GO DECLARE @procName VARCHAR(100) DECLARE @getprocName CURSOR SET @getprocName = CURSOR FOR SELECT s.name FROM sysobjects s WHERE type = [...]

Read Full Post »

SQL SERVER – Guidelines and Coding Standards Complete List Download

Posted in Best Practices, Data Warehousing, Database, DBA, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Documentation, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, SQL Utility, SQLAuthority, T SQL, Technology on September 25, 2008 | 45 Comments »

SQL SERVER – Guidelines and Coding Standards complete List Download Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation [...]

Read Full Post »

SQL SERVER – 2008 – Interview Questions and Answers Complete List Download

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL DateTime, SQL Documentation, SQL Download, SQL Error Messages, SQL Function, SQL Index, SQL Interview Questions and Answers, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Stored Procedure, SQL Tips and Tricks, SQL Trigger, SQL Utility, SQL XML, SQLAuthority, T SQL, Technology on September 20, 2008 | 141 Comments »

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Download SQL Server 2008 Interview Questions and Answers Complete List UPDATE: This article series has been updated with new interview questions and answers series. Interview is very important event for any person. A good interview leads to good career if candidate [...]

Read Full Post »

SQL SERVER – 2008 – Interview Questions and Answers – Part 2

Posted in Data Warehousing, Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Cursor, SQL Function, SQL Index, SQL Interview Questions and Answers, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLAuthority, T SQL, Technology on September 13, 2008 | 35 Comments »

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Questions of SQL SERVER What is Cursor? Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of [...]

Read Full Post »

Older Posts »